Excel functions / Database
DVAR function
The variance of a column of a table for the matching rows, treating them as a sample.
Syntax
=DVAR(database, field, criteria)
Arguments
database: The table, with its column labels in the first row.field: The column to work on: its label in quotes ("Profit") or its number counting from 1.criteria: The conditions: a range with column labels in its first row and what to match below them.
When to use it
DVAR gives the variance of one column of a table for the matching rows, treating them as a sample.
Examples
Variance of North sales
A B C D E 1 Region 2 North 210000 3 4 Region Rep Sales 5 North Ana 1200 6 South Ben 800 7 North Chloe 900 8 West Ana 400 9 North Ana 300 In E2:
=DVAR(A4:C9, "Sales", A1:A2)→ 210000
Common mistakes
- Squared units. Variance is in squared units. Its square root, DSTDEV, is in the data's own units.
DVAR in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DVAR.VÝBĚR
- Danish: DVARIANS
- Dutch: DBVAR
- Finnish: TVARIANSSI
- French: BDVAR
- German: DBVARIANZ
- Hungarian: AB.VAR
- Italian: DB.VAR
- Norwegian: DVARIANS
- Polish: BD.WARIANCJA
- Portuguese (Brazil): BDVAREST
- Portuguese (Portugal): BDVAR
- Russian: БДДИСП
- Spanish: BDVAR
- Swedish: DVARIANS
- Turkish: VSEÇVAR