The STDEVX.P function returns the standard deviation of the entire population extracted from a table to whose rows a certain expression is applied.
STDEVX.P(
table,
expression
)
- table: Table containing the rows for which the expression will be evaluated.
- expression: Expression to evaluate for each row of the table.
The STDEVX.P function returns a real number.
The function evaluates the expression included as the second argument for each of the rows of the indicated table, returning the standard deviation of the results assuming that the table refers to the entire population. If the table represents a sample of the population, the STDEVX.S function should be used.
The STDEVX.P function applies the following formula:
...where x̃ is the mean value of x for the entire population and n is the size of the population.
Empty rows are ignored in the calculation. If there are less than two non-empty rows, the function returns an error.
Suppose we have the following table showing a list of products and their sale price:
Assuming that the data shown is the entire population, we can calculate the standard deviation of the prices using the following measure:
Desviación estándar = STDEVX.P(Ventas, Ventas[Precio])
If we take this measure to a card-type display, we obtain the following result:
If, instead of a list of products and prices, we had a list of sales including the quantity sold and the unit price of each sale:
...We could calculate the standard deviation of the invoiced figures (that is, of the product of the quantity and the unit price) -assuming that they represent the entire population- with the following measure:
Desviación estándar = STDEVX.P(Ventas, Ventas[Cantidad] * Ventas[Precio])
...which, taken to a card-like display, returns the following result: