Functions
VAR.P
Population variance
Try it
When to use it
When should I use VAR.P instead of VAR.S?
Use VAR.P when your data represents the entire population (divides by n), not a sample — for example, calculating variance across all products in a catalog or all students in a class rather than a random subset.
Used in
Syntax
VAR.P(value1,...)Examples
=VAR.P(1,2,3,4,5,6,7,8,9,10) // => 8.25
=VAR.P(2,4,4,4,5,5,7,9) // => 4