STDEV.S

The STDEV.S function returns the sample standard deviation of the values contained in a column.

Syntax

STDEV.S(
    ColumnName
)

Parameters
  • ColumnName: Column for whose values you want to calculate the standard deviation.
Returned value

The STDEV.S function returns a real number.

Additional Information

The function uses the following formula:

√ [∑ (x - x̃) ² / (n-1)]

where x̃ is the mean value of x for the population sample and n is the sample size.

Empty cells are not considered in the calculation.

If the column contains less than two non-empty cells, the function returns an error.

Examples

Suppose we have the following sales list that includes the number of items sold and their unit price:

VARX.S. function Example of use

We can calculate the standard deviation of prices -assuming that it is a sample of the population- with the following measure:

Desviación estándar = STDEV.S(Ventas[Precio])

...which, taken to a card-like display, returns the following result:

STDEV.S function. Example of use
Category
Statistical
Submitted by admin on Sun, 01/13/2019 - 18:25