|
<< Click to Display Table of Contents >> STDEVPA (standard deviation of entire population) |
Syntax:
STDEVPA(Number1, Number2 [, Number3 ...])
Description:
The STDEVPA function is almost identical to the STDEVP function (see note). It returns the standard deviation of an entire population.
Number1, Number2, etc., are single values, cell ranges or arrays that contain the values to be evaluated. Please note that all values of the entire population have to be specified. 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 is evaluated as 0, while TRUE is evaluated as 1. Text is evaluated as 0.
Empty cells, however, are also ignored here.
Additional info:
The standard deviation is calculated using the "biased" or "n" method.
Example:
STDEVPA(2, 2, 3, 4, 1) returns 1.0198
See also: