3. Calculate the variance

To calculate the variance of a series, you may choose between using the =VAR.P(...) and =VAR.S(...) functions. Both functions provide the variance, but based on different assumptions and therefore on slightly different formulas.

Skjermbilde 2016-11-28 23.23.05Use =VAR.P(...) if the dataset that you analyse is a whole population.



Skjermbilde 2016-11-28 23.23.46Use =VAR.S(...) if the dataset is a sample of a population.

  Fant du det du lette etter? Did you find this helpful?
[Average: 0]