|
<< Click to Display Table of Contents >> STDEV.S (standard deviation of a sample) |
Syntax:
STDEV.S(Number1, Number2 [, Number3 ...])
Description:
Estimates the standard deviation of a population based on a sample.
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).
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 "unbiased" or "n-1" method.
Example:
STDEV.S(2, 2, 3, 4, 1) returns 1.14018
Compatibility notes:
Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.
See also: