Functions
DSTDEV
Sample standard deviation of field values for rows matching criteria
Try it
When to use it
When should I use DSTDEV?
Use DSTDEV to compute the sample standard deviation of a field for rows matching criteria — useful when the matching rows are a sample drawn from a larger population and you need a measure of spread.
Used in
Syntax
DSTDEV(database, field, criteria)Examples
=DSTDEV({"Cat","Val";"A",10;"A",20;"A",30},"Val",{"Cat";"A"}) // => 10
=DSTDEV({"G","V";"X",2;"X",8;"X",5},2,{"G";"X"}) // => 3
=DSTDEV({"Name","Score";"Alice",80;"Bob",90;"Carol",70},"Score",{"Score";">75"}) // => 7.0710678118654755