Functions
VARPA
Population variance including text and logical values
Try it
When to use it
When should I use VARPA?
Use VARPA when you need population variance and your range might include text (counted as 0) or logical values (TRUE=1, FALSE=0) that should contribute to the calculation — it is the population counterpart of VARA.
Used in
Syntax
VARPA(value1,...)Examples
=VARPA(1,2,3,4,5,6,7,8,9,10) // => 8.25
=VARPA(2,4,4,4,5,5,7,9) // => 4