Article updated on March 13, 2018

The STDEVPA function returns the standard deviation based on the entire population, including text and logical values.

The standard deviation is how widely numbers are distributed around the average value.

Formula in cell D3:

=STDEVPA(B3:B12)

Excel Function Syntax

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

Arguments

value1 Required. The first number argument that represents the entire population.
[value2] Optional. Up to 253 additional number arguments.