Calculates standard deviation based on an entire population, setting text to the value ‘0’.
Sample Usage
STDEVPA(1,2,3,4)
STDEVPA(A2:A6)
STDEVPA(A2:A10, B2:B10))
Syntax
STDEVPA(value1, [value2, ...])
- value1 - The first number or range of the population.
- value2, .. - [OPTIONAL] Additional numbers or ranges to include in the population.
Examples
STDEVPA(1,2,3,4) returns a value of 1.118
STDEVPA(A2:A6) returns the returns the standard deviation of the numbers in cells A2 through A6, assuming this to be the complete dataset.
Notes
- A minimum of two values must be supplied as value arguments. Else, STDEVPA will return an error.
- STDEVPA will interpret text values as 0. To ignore any cells that include text and logical values, use STDEVP.
- STDEVPA calculates variance for the entire population. To calculate variance for a sample, use STDEVA.