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