Formulas and functions > Functions from A to Z > STDEVPA (standard deviation of entire population)

Syntax:

STDEVPA(Value1, Value2 [, Value3 ...])

Description:

The STDEVPA function is almost identical to the STDEVP function (see note). It returns the standard deviation of an entire population.

Number1, Number2, etc., are single values, cell ranges or arrays that contain the values to be evaluated. Please note that all values of the entire population have to be specified. To calculate the standard deviation of a sample, use the STDEVA function instead. This returns an estimate of the standard deviation.

Note:

Unlike the STDEVP function, STDEVPA also evaluates logical values and text. Both FALSE and text are evaluated as 0. TRUE is evaluated as 1.

Empty cells, however, are also ignored here.

Note:

The standard deviation is calculated using the "biased" or "n" method.

Example:

STDEVPA(2, 2, 3, 4, 1) returns 1.0198