The VAR.S function returns the variance of a sample of the population contained in a column.
VAR.S(
column
)
- column: Column for whose values you want to calculate the variance.
The VAR.S function returns a real number.
The function uses the following formula:
...where x̄ is the mean value of x for the population sample and n is the sample size. The use of n-1 instead of n is known as the Bessel's correction.
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 variance of the prices -assuming that it is a sample of the population- with the following measure:
Varianza = VAR.S(Ventas[Precio])
...which, taken to a card-like display, returns the following result: