Excel functions / Database
DVARP function
The variance of a column of a table for the matching rows, treating them as the whole population.
Syntax
=DVARP(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
DVARP gives the variance of one column of a table for the matching rows, treating them as the whole population.
Examples
Variance of all North sales
A B C D E 1 Region 2 North 140000 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:
=DVARP(A4:C9, "Sales", A1:A2)→ 140000
Common mistakes
- Sample or population. Use DVAR for a sample.
DVARP 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
- Danish: DVARIANSP
- Dutch: DBVARP
- Finnish: TVARIANSSIP
- French: BDVARP
- German: DBVARIANZEN
- Hungarian: AB.VAR2
- Italian: DB.VAR.POP
- Norwegian: DVARIANSP
- Polish: BD.WARIANCJA.POPUL
- Portuguese (Brazil): BDVARP
- Portuguese (Portugal): BDVARP
- Russian: БДДИСПП
- Spanish: BDVARP
- Swedish: DVARIANSP
- Turkish: VSEÇVARS