Article updated on June 15, 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:


Excel Function Syntax

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


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