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:

Argument	Description
value1/2/n	Up 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.