To use this function, choose .
Measures the dispersion (how spread out the data are) about the mean. While the range estimates the spread of the data by subtracting the minimum value from the maximum value, the standard deviation approximately estimates the "average" distance of the individual observations from the mean. The greater the standard deviation, the greater the spread in the data.
Column statistic |
---|
STDEV(number) |
For number, specify the column number.
Row statistic |
---|
RSTDEV(number,number,...) |
For number, specify each column number to define the length of the rows.
Column | Calculator expression | Result |
---|---|---|
C1 contains 6, 3, 15 | STDEV(C1) | 6.245 |
C1 contains 6, C2 contains 3, and C3 contains 15 | RSTDEV(C1,C2,C3) | 6.245 |