Using the Excel STDEVPA Function
SummaryThe 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 BreakdownValue 1
Required. The first value that corresponds to a population. An array or reference to an array can also be used.
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 NotesSTDEVPA 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|