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