DVAR
Estimates variance based on a sample from selected database entries.
DatabaseDatabase & Lists
What it does
Calculates variance (sample) for database entries matching criteria.
Syntax
DVAR(database, field, criteria)
Arguments
database(range) — Database range.field(text) — Column to evaluate.criteria(range) — Criteria range.
Examples
Filtered Variance
Variance of Score for 'A'.
FORMULA
=DVAR(A1:B5, "Score", D1:D2)
RESULT
4.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 |