|
<< Click to Display Table of Contents >> STDEVA (standard deviation of a sample) |
Syntax:
STDEVA(Value1, Value2 [, Value3 ...])
Description:
The STDEVA function is almost identical to the STDEV function (see note). It estimates the standard deviation of a population based on a sample, including logical values and text.
The standard deviation indicates the amount that the specified values deviate from the average value.
Number1, Number2, etc. are single values, cell ranges, or arrays containing the values to be evaluated (sample).
Note:
Unlike the STDEV function, STDEVA also evaluates logical values and text: FALSE evaluates as 0. TRUE evaluates as 1. Text evaluates as 0.
Empty cells, however, are also ignored here.
Annotation:
The standard deviation is calculated using the "unbiased" or "n-1" method.
Example:
STDEVA(2, 2, 3, 4, 1) returns 1.14018
See also: