|
<< Click to Display Table of Contents >> STDEVP (standard deviation of entire population) |
Note: STDEVP is supplemented by the new identical function STDEV.P, which is available in newer versions of Microsoft Excel (2010 or later).
Syntax:
STDEVP(Number1, Number2 [, Number3 ...])
Description:
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 STDEV.S/STDEV function instead. This returns an estimate of the standard deviation.
If this function refers to empty cells or cells with error values, these are ignored. Also cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus be taken into account.
Annotation:
The standard deviation is calculated using the "biased" or "n" method.
Example:
STDEVP(2, 2, 3, 4, 1) returns 1.0198
See also: