Standard deviation function

To use this function, choose Calc > Calculator.

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.

Syntax

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.

Example

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
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy