STDEVA

Calculates the sample standard deviation[1] of the values in a data set.

This is the square root of the sample variance.

Syntax:

STDEVA( list )

Returns the sample standard deviation[1] of the values in the list.

list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).

Note that numeric values and text cells are included in the calculation - with text being treated as zero - but that blank elements still do not upset the average.

Formula:

STDEVA, s = ( ni 1n (xi2) − (i 1n xi)2 )  ∕  (n⋅(n − 1))  )

where n is the number of values and xi is the i‑th value.

Example:

STDEVA(A1:A15)

returns the sample standard deviation of the contents of cells in the range A1:A15.

Revisions:

This function was added in Fireworkz 2.00.

  1. Weisstein, Eric W. "Standard Deviation." From MathWorld--A Wolfram Web Resource. https://mathworld.wolfram.com/StandardDeviation.html