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 set values will display horizontally when the syntax is STATS(a..b,c).
- The set of 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)
See Also