STDEVPA

Using the Excel STDEVPA Function

Summary

The Excel STDEVPA function estimates the standard deviation based on the entire population, including logical values and text. Standard deviation is a measure of how widely values are dispersed from the mean. The mean can be found using the AVERAGE function.

Use the STDEVA or STDEV.S function to calculate the standard deviation for a sample of the population.


Syntax

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

Syntax Breakdown

Value 1
Required. The first value that corresponds to a population. An array or reference to an array can also be used.

Value 2
Value 2 and subsequent value arguments are optional. The function can accept up to 255 arguments. An array or reference to an array can also be used.


Usage Notes

STDEVPA returns the standard deviation from data that is representative of an entire population. Unlike the STDEV function, STDEVPA accounts for logical and text values.

TEXT evaluates as 0 (zero), TRUE evaluates as 1, and FALSE evaluates as 0 (zero).

Standard deviation is used to calculate the variance in a set of numbers compared to the average, or mean, of the numbers. The STDEVPA function finds the standard deviation of an entire population. Use STDEVA to estimate the standard deviation for a sample of the population.

Standard deviation is calculated using the "n" method.

STDEVPA includes text and logical values. To ignore text and logical values, use the STDEVP or STDEV.P function.

Variations of Standard Deviation Functions in Excel
Function Data Set Text & Logical Values
STDEV Sample Ignored
STDEVP Population Ignored
STDEV.S Sample Ignored
STDEV.P Population Ignored
STDEVA Sample Evaluated
STDEVPA Population Evaluated