Excel STDEVPA Function
Excel STDEVPA function calculates the standard deviation of the entire population, including text and logical values supplied in cell references. It is used to identify the amount that a set of population values differ or deviate from the average value of the entire population.
=STDEVPA(value1, [value2], ...)
Excel STDEVPA function can accept 255 arguments in total and its syntax has the following arguments:
value1 (required argument) – It is the first argument of population data set.
[value2], … (optional arguments) – These are additional arguments corresponding to a population.
Excel STDEVPA function assumes that data values supplied in arguments represent the entire population instead of a sample. Arguments can be supplied as numbers, named ranges, arrays or cell references, which may contain numbers, text values, logical values, and empty cells.
Excel STDEVPA function evaluates numbers, text and logical values provided in cell references, but empty cells are ignored. Logical value FALSE and text value are evaluated as 0 and logical value TRUE is evaluated as 1. Text representations of numbers supplied directly as an argument in Excel STDEVPA function are also counted.
For example, you have subject scores of the entire population and you want to calculate the standard deviation of population data including text and logical values found in cell references. Following formula is used to return standard deviation of a population by using Excel STDEVPA function:
Figure 1. STDEVPA_Function
You must remember these points while using Excel STDEVPA function correctly:
- Data values supplied in arguments are assumed to represent the entire population. If a data set is a sample of the population then use Excel STDEVA function.
- Excel STDEVPA function calculates standard deviation using the “n” method.
- It measures the standard deviation of the data set including text and logical values in cell references. If you want to exclude text and logical values supplied in cell references of population data set, then use Excel STDEVP function.
- Text representations of numbers supplied directly as an argument in Excel STDEVPA function are evaluated and counted in the calculation.
- If text representations of numbers are supplied inside cell references then these values are considered as text values and evaluated as 0 in standard deviation calculation.
- It returns #VALUE! error if text value is directly entered as an argument.