STDEVPA function

Category: Statistical
Introduced: Excel 2003

Summary

Calculates standard deviation based on the entire population, including numbers, text, and logical values

Syntax

STDEVPA(value1, [value2], ...) The STDEVPA function syntax has the following arguments:
• Value1, value2, ... Value1 is required, subsequent values are optional. 1 to 255 values corresponding to a population. You can also use a single array or a reference to an array instead of arguments separated by commas.

Example

=STDEVPA(A3:A12)

Microsoft Support Page

https://support.microsoft.com/en-us/office/stdevpa-function-5578d4d6-455a-4308-9991-d405afe2c28c

Back to Functions