Quick Navigation
VARP Function
Summary
The VARP function calculates variance for an entire population dataset in Excel. Use it when your data represents the complete set of values rather than just a sample.
Syntax
VARP(number1,[number2],...)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number1 | Number |
Yes | Required first numeric value from the population |
| number2,... | Number |
No | Optional additional numeric values (2-255 total arguments) |
Using the VARP Function
VARP measures how far individual population values deviate from the mean, using the population variance formula. Essential for complete datasets like all sales from a single store location or total test scores from an entire class.
Common VARP Examples
Population Variance for Tool Strengths
=VARP(A2:A11)Calculates variance for complete population of 10 tool strength measurements (678.84)
Compare Population vs Sample
=VARP(B2:B11)Shows difference between VARP (population) and VAR (sample) on same dataset
Multiple Value Arguments
=VARP(95, 98, 97, 96, 99, 94)Direct population values without cell references
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Non-numeric arguments that can't convert to numbers
Solution: Ensure all arguments contain valid numbers
#DIV/0! error
Cause: Single numeric value or all identical values
Solution: Provide at least two different numeric values
Notes
- Replaced by VAR.P but remains available for compatibility
- Uses formula: σ² = Σ(x - μ)²/n where μ is population mean
- Logical/text values counted only when typed directly
- Empty cells in ranges are ignored
Compatibility
Available in: Excel 2007+, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365