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:
Argument | Description |
---|
value1/2/n | Up 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.
