Skip to main content

STDEVPA function

The STDEVPA function is one of the statistical functions. It is used to analyze the range of data and return the standard deviation of an entire population.

Syntax​

STDEVPA(value1, [value2], ...)

The STDEVPA function has the following arguments:

ArgumentDescription
value1/2/nUp to 255 values for which you want to calculate the standard deviation.

Notes​

Text and FALSE values are counted as 0, TRUE values are counted as 1, empty cells are ignored.

How to apply the STDEVPA function.

Examples​

The figure below displays the result returned by the STDEVPA function.

STDEVPA Function