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.
Use =VAR.P(...) if the dataset that you analyse is a whole population.
Use =VAR.S(...) if the dataset is a sample of a population.
Fant du det du lette etter? Did you find this helpful?
[Average: 0]