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