Excel STDEVA Function

Using the Excel STDEVA Function


The Excel STDEVA function estimates the standard deviation based on a sample of a 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 STDEVPA function or STDEV.P function to calculate the standard deviation for the entire population.


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

Syntax Breakdown

Value 1
Required. The first value that corresponds to a sample of 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

STDEVA returns the standard deviation from data that is representative of a sample of a population. Unlike the STDEV function, STDEVA 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. STDEVA is intended to estimate the standard deviation for a sample of the entire population. Use the STDEVPA function to find the standard deviation of an entire population.

Standard deviation is calculated using the "n - 1" method.

STDEVA includes text and logical values. To ignore text and logical values, use the STDEV or STDEV.S 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