Difference between revisions of "Manuals/calci/STATS"

From ZCubes Wiki
Jump to navigation Jump to search
Line 42: Line 42:
 
|}
 
|}
 
<font color ="Red">Need to give examples for horizontal result.STATS(220,270,5) </font>
 
<font color ="Red">Need to give examples for horizontal result.STATS(220,270,5) </font>
 +
2. STATS(198,134,6)
 +
{| class="wikitable"
 +
|-
 +
| COUNT || SUM || AVERAGE || VAR || STDEV || VARP || STDEVP || MIN || MAX || MEDIAN ||MODE
 +
|-
 +
| 1 || 198 || 198 || NaN || NaN || 0 || 0 || 198 || 198 || 198 || #ERROR
 +
|}
  
 
==Related Videos==
 
==Related Videos==

Revision as of 13:58, 25 January 2018

STATS(a,b,c)


  • is the starting number of the set.
  • is the ending number of the set.
  • is the step number.

Description

  • This function gives the statistics value of the given set of numbers.
  • Statistics is the general term and it is used to summarize a process that an analyst, mathematician or statistician can use to characterize a data set.
  • So Statistics is the science of learning from data, and of measuring, controlling, and communicating uncertainty.
  • If the data set is based on a sample of a larger population, then the analyst can extend inferences onto the population based on the statistical results from the sample.
  • Statistical measures include regression analysis, mean, kurtosis, skewness, analysis of variance and variance.
  • Here STATS(a,b,c),where a is the first number,b is the last number and c is the step number.
  • In Calci,STATS function showing how many numbers, sum of the given numbers,average,variance,standard deviation,minimum and maximum value of the given set of numbers, median and mode of the numbers.
  • The result values will display horizontally when the syntax is STATS(a..b,c).
  • The result values will showing vertically when the syntax is STATS(a..b..c).

Examples

  • 1.STATS(5..450)
COUNT 446
SUM 101465
AVERAGE 227.5
VAR 16613.5
STDEV 128.89336678045152
VARP 16576.25
STDEVP 128.7487864020473
MIN 5
MAX 450
MEDIAN 227.5
MODE #ERROR

Need to give examples for horizontal result.STATS(220,270,5) 2. STATS(198,134,6)

COUNT SUM AVERAGE VAR STDEV VARP STDEVP MIN MAX MEDIAN MODE
1 198 198 NaN NaN 0 0 198 198 198 #ERROR

Related Videos

Statistical Functions

See Also

References