The STDEV.P function returns the standard deviation of the total population contained in a column.
STDEV.P(
ColumnName
)
- ColumnName: Column for whose values you want to calculate the standard deviation.
The STDEV.P function returns a real number.
The function uses the following formula:
√ [∑ (x - x̃) ² / n]
where x̃ is the mean value of x for the entire population and n is the size of the population.
Empty cells are not considered in the calculation.
If the column contains less than two non-empty cells, the function returns an error.
Suppose we have the following sales list that includes the number of items sold and their unit price:
We can calculate the standard deviation of prices -assuming that it is the total population- with the following measure:
Desviación estándar = STDEV.P(Ventas[Precio])
...which, taken to a card-like display, returns the following result: