Skip to main content

STDEVA function

The STDEVA function is one of the statistical functions. It is used to analyze the range of data and return the standard deviation of a population based on a set of numbers, text, and logical values (TRUE or FALSE). The STDEVA function treats text and FALSE as a value of 0 and TRUE as a value of 1.

Syntax​

STDEVA(value1, [value2], ...)

The STDEVA function has the following arguments:

ArgumentDescription
value1/2/nUp to 255 values for which you want to calculate the standard deviation.

Notes​

How to apply the STDEVA function.

Examples​

The figure below displays the result returned by the STDEVA function.

STDEVA Function