Excel STDEVA Function
Excel STDEVA function estimates standard deviation based on the sample including logical and text values. It gives an estimate how much sample values differ or widely disperse from an average of sample values.
=STDEVA (value1, [value2], ...)
Excel STDEVA function syntax has the following arguments:
value1 (required) – It is first value of sample
[value2], … (optional) – These are additional values of the sample
Excel STDEVA function estimates the standard deviation of the sample data set including logical and text values. Logical value FALSE and text value are evaluated as 0 and logical value TRUE is evaluated as 1 in cell references of sample data.
You can add total 255 arguments in Excel STDEVA function as numbers, named ranges, arrays or cell references. These arguments can have numbers, logical values, and text values, all of these values are evaluated in standard deviation calculation of sample. Empty cells found in cell references of sample data set are ignored.
Cell references containing text representations of numbers are considered as text values, therefore evaluated as 0. But, text representations of numbers entered directly as an argument in Excel STDEVA function are evaluated as numbers.
Suppose you have the sample of values derived from entire population data and you want to estimate the standard deviation of sample values by evaluating logical and text values also. The formula using Excel STDEVA function is:
Figure 1. STDEVA_Function
Following points must be taken into consideration before using Excel STDEVA function:
- Arguments containing data must represent the sample of a population. If data set represents entire population then Excel STDEVPA must be used.
- It evaluates text and logical values found in cell references of the sample. If you don’t want to evaluate these values then use Excel STDEV.S or STDEV function.
- It calculates standard deviation using “n-1” method.
- Text values in cell references are evaluated as number as 0. However, logical values entered either in cell references or directly as arguments in function are evaluated as numbers.
- Text representations of numbers in cell references are evaluated as text values as 0, but these values entered directly as an argument in function are evaluated as numbers.
- It generates error value #VALUE! if any text value is supplied directly as an argument.