|
<< Click to Display Table of Contents >> STDEVA (standard deviation of a sample) |
Syntax:
STDEVA(Number1, Number2 [, Number3 ...])
Description:
The STDEVA function is almost identical to the STDEV function (see note). It thus provides an estimate of the standard deviation of the population based on a sample.
The standard deviation indicates the average amount by which the specified values deviate from the mean.
Number1, Number2, etc., are single values, cell ranges or arrays that contain the values to be evaluated (sample).
Note:
Unlike the STDEV function, STDEVA 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 "unbiased" or "n-1" method.
Example:
STDEVA(2, 2, 3, 4, 1) returns 1.14018
See also: