The VARX.P function returns the variance of the entire population extracted from a table to whose rows a certain expression is applied.
VARX.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 VARX.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 variance of the results assuming that the table refers to the entire population. If the table represents a sample of the population, the VARX.S function should be used.
The VARX.P function uses 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 sales list that includes the number of items sold and their unit price:
We can calculate the variance of the invoiced figures (that is, of the sales considering the quantity purchased) -assuming that it is the entire population- with the following measure:
Varianza = VARX.P(Ventas, Ventas[Cantidad] * Ventas[Precio])
...which, taken to a card-like display, returns the following result:
