DSTDEV
Estimates the standard deviation based on a sample of selected database entries.
DatabaseDatabase & Lists
What it does
Calculates standard deviation (sample) for database entries matching criteria.
Syntax
DSTDEV(database, field, criteria)
Arguments
database(range) — Database range.field(text) — Column to evaluate.criteria(range) — Criteria range.
Examples
Filtered StDev
StDev of Score for 'Group A'.
FORMULA
=DSTDEV(A1:B5, "Score", D1:D2)
RESULT
2.12
SAMPLE DATA
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Group | Score | Group | |
| 2 | A | 10 | ||
| 3 | B | 15 | ||
| 4 | A | 13 | ||
| 5 | B | 12 | ||
| 6 | A |