The VARX.S function returns the variance of a sample of the population extracted from a table to whose rows a certain expression is applied.
VARX.S(
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.S 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 a sample of the population. If the table represents the entire population, the VARX.P function should be used.
The STDEVX.S function uses the following formula:
...where x̄ is the mean value of x for the sample population and n is the size of the population. The use of n-1 instead of n is known as the Bessel's correction.
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 a sample of the population- with the following measure:
Varianza = VARX.S(Ventas, Ventas[Cantidad] * Ventas[Precio])
...which, taken to a card-like display, returns the following result:
