Functions
DVAR
Sample variance of field values for rows matching criteria
Try it
When to use it
When should I use DVAR?
Use DVAR to compute the sample variance of a field for rows matching criteria — useful when the filtered rows are a sample and you need a measure of variability for statistical analysis.
Used in
Syntax
DVAR(database, field, criteria)Examples
=DVAR({"Cat","Val";"A",10;"A",20;"A",30},"Val",{"Cat";"A"}) // => 100
=DVAR({"G","V";"X",2;"X",8;"X",5},2,{"G";"X"}) // => 9
=DVAR({"Name","Score";"Alice",80;"Bob",90;"Carol",70},"Score",{"Score";">75"}) // => 50