Functions
VARP
Population variance
Try it
When to use it
When should I use VARP?
VARP is the legacy population variance function equivalent to VAR.P; use it only when maintaining older spreadsheets — for new work, prefer VAR.P which has the same behavior but follows the modern naming convention.
Used in
Syntax
VARP(value1,...)Examples
=VARP(1,2,3,4,5,6,7,8,9,10) // => 8.25
=VARP(2,4,4,4,5,5,7,9) // => 4