Quick Navigation
VARPA Function
Summary
The VARPA function calculates variance for an entire population, including numbers, text representations of numbers, and logical values (TRUE/FALSE) in your dataset. Unlike VARP, it treats text as 0 and TRUE as 1, providing comprehensive population variance analysis.
Syntax
VARPA(value1, [value2], ...)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| value1 | Any |
Yes | First value, cell reference, or array containing population data |
| [value2], ... | Any |
No | Additional values, references, or arrays (up to 254 more arguments) |
Using the VARPA Function
VARPA is ideal when analyzing complete populations where your dataset includes logical values or text numbers. Use it for quality control analysis of all produced items, survey results with yes/no responses, or any scenario where non-numeric data contributes to variance calculation.
Common VARPA Examples
Population Variance with Logical Values
=VARPA(10, TRUE, 15, FALSE, 20)Calculates variance treating TRUE=1, FALSE=0: Result ≈ 22.7. Includes logical values directly in calculation.
Manufacturing Quality Analysis
=VARPA(A2:A11)Variance of tool breaking strengths (1345,1301,1368,1322,1310,1370,1318,1350,1303,1299) for entire production batch: 678.84
Mixed Data Types
=VARPA(B1:B5)Analyzes range containing numbers, "5", TRUE, FALSE: Text "5"=5, TRUE=1, FALSE=0 in variance.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Arguments contain unconvertible text or error values
Solution: Remove error values or use VARP to exclude logical/text data
Incorrect results
Cause: Using VARPA for sample data instead of population
Solution: Use VARA for sample populations
Missing variance distinction
Cause: Confusing population vs sample analysis
Solution: VARPA=population (÷n), VARA=sample (÷n-1)
Notes
- VARPA uses population formula: σ² = Σ(x-μ)²/n
- TRUE=1, FALSE/text=0 when typed directly
- Empty cells and text in ranges ignored
- Available since Excel 2007
- Maximum 255 arguments
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+