Formulas and functions > Functions from A to Z > STDEVA (standard deviation of a sample)

Syntax:

STDEVA(Value1, Value2 [, Value3 ...])

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 from 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. Both FALSE and text are evaluated as 0. TRUE is evaluated as 1.

Empty cells, however, are also ignored here.

Note:

The standard deviation is calculated using the "unbiased" or "n-1" method.

Example:

STDEVA(2, 2, 3, 4, 1) returns 1.14018