Functions
VAR
Sample variance
Try it
When to use it
When should I use VAR?
Use VAR to compute the sample variance of a set of values — it divides by n-1 (Bessel's correction) to give an unbiased estimate of the population variance when working with a sample rather than an entire population.
Used in
Syntax
VAR(value1,...)Examples
=VAR(1,2,3,4,5,6,7,8,9,10) // => 9.166666666666666
=VAR(2,4,4,4,5,5,7,9) // => 4.571428571428571