VAR.P

The VAR.P function returns the variance of the entire population contained in a column.

Syntax

VAR.P(
    column
)

Parameters
  • column: Column for whose values you want to calculate the variance.
Returned value

The VAR.P function returns a real number.

Additional Information

The function uses the following formula:

Función VARX.P

...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.

Examples

Suppose we have the following sales list that includes the number of items sold and their unit price:

VARX.P function. Example of use

We can calculate the variance of the prices -assuming that it is the entire population- with the following measure:

Varianza = VAR.P(Ventas[Precio])

...which, taken to a card type display, returns the following result:

VAR.P function Example of use
Category
Statistical
Submitted by admin on Sun, 01/13/2019 - 17:53