|
<< Click to Display Table of Contents >> STDEVPA (standard deviation of entire population) |
Syntax:
STDEVPA(Value1, Value2 [, Value3 ...])
Description:
The STDEVPA function is almost identical to the STEVP function (see note). It returns the standard deviation of an entire population.
Number1, Number2, etc. are single values, cell ranges, or arrays containing the values to be evaluated. Please note that all values of the entire population have to be given. To calculate the standard deviation of a sample, use the STDEVA function instead. This returns an estimate of the standard deviation.
Note:
Unlike the STDEVP function, STDEVPA 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 "biased" or "n" method.
Example:
STDEVPA(2, 2, 3, 4, 1) returns 1.0198
See also: