Author: Oscar Cronquist Article last updated on June 15, 2018

The STDEVA function estimates the standard deviation from a sample of values. Standard deviation shows how much the values differ from the mean value of the group.

If your data contains the entire population use instead the STDEVPA function to calculate the standard deviation.

Formula in cell D3:

=STDEVA(B3:B14)

Excel Function Syntax

STDEVA(number1,[number2],...)

Arguments

number1 Required. This argument can be an array of constants or a cell reference to a group of values.
[number2] Optional. Up to 254 additional arguments.

Comments

Use the STDEV function if you don't want to include boolean values and text that represents numbers in your calculation.