Quick Navigation
DVARP Function
Summary
The Excel DVARP function calculates the population variance for values in a specified field of a database that match your defined criteria. Perfect for statistical analysis of filtered datasets representing complete populations.
Syntax
DVARP(database, field, criteria)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| database | Range |
Yes | Complete database range (headers + data rows) |
| field | Text/Number |
Yes | Field name in quotes or column position number |
| criteria | Range |
Yes | Criteria range with headers and conditions |
Using the DVARP Function
DVARP analyzes variance across your entire matching population from database tables. Use it when your filtered dataset represents the complete population rather than a sample. Ideal for business metrics, quality control, and research data where you need true population statistics.
Common DVARP Examples
Variance of Apple/Pear Tree Yields
=DVARP(A4:E10, "Yield", A1:A3)Calculates population variance for yields of apple and pear trees (criteria: Tree=Apple or Pear). Returns 7.04 representing complete orchard population variance.
Employee Salary Variance by Department
=DVARP(A1:D20, "Salary", F1:F3)Finds population variance of salaries for Sales department employees only.
Product Sales Variance - Above Target
=DVARP(B1:F50, 3, H1:H2)Population variance of sales for products exceeding 1000 units.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Field name doesn't match database header exactly or invalid column number
Solution: Check spelling/case of field names and ensure column number is valid
Incorrect results
Cause: Criteria range overlaps database or placed below list
Solution: Move criteria range away from database; never below the data
#NUM! error
Cause: No matching records found or non-numeric data in field
Solution: Verify criteria matches data and field contains numbers
Notes
- DVARP divides by N (true population variance)
- First criteria row must exactly match database headers
- Multiple criteria rows act as OR conditions
- Use blank row in criteria for entire column operations
- Don't place criteria below database to avoid expansion issues
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+