Functions
DVARP
Population variance of field values for rows matching criteria
Try it
When to use it
When should I use DVARP instead of DVAR?
Use DVARP when the rows matching your criteria represent the entire population — it divides by N rather than N−1 and gives a lower (population) variance.
Used in
Syntax
DVARP(database, field, criteria)Examples
=DVARP({"Cat","Val";"A",10;"A",20;"A",30},"Val",{"Cat";"A"}) // => 66.66666666666667
=DVARP({"G","V";"X",2;"X",8;"X",5},2,{"G";"X"}) // => 6
=DVARP({"Name","Score";"Alice",80;"Bob",90;"Carol",70},"Score",{"Score";">75"}) // => 25