STDEVP (Primitive Spread Function) calculates standard deviation based on the entire population given as arguments.

SYNTAX:

STDEVP(value1,value2,...)

REMARKS:

The standard deviation is a measure of how widely values are dispersed from the average value.

Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.

The standard deviation is calculated using the "biased" or "n" method. The function uses the following formula to calculate the standard deviation:

                                                              

The STDEVP function assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using the STDEV function. 

EXAMPLES:

STDEVP(A1,B2,C3,D4,E5,F6)
STDEVP(A1:A9)
STDEVP(95,89,73,87,85,76,100,96,96)=8.8079649700