- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Statistical - VARPA Function
Description
The VARPA function calculates variance based on the entire population.
Syntax
VARPA (value1, [value2] ...)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Value1 | 1 to 255 value arguments corresponding to a population. | Required |
Value2,... | Optional |
Notes
The equation for VARPA is −
$$\frac{\sum \left ( x-\bar{x} \right )^2}{n}$$
Where x is the sample mean AVERAGE (value1,value2,…) and n is the sample size.
VARPA assumes that its arguments are the entire population. If your data represents a sample of the population, you must compute the variance by using VARA.
Arguments can be numbers, names, arrays, or references that contain numbers, text representations of numbers or logical values, such as TRUE and FALSE, in a reference.
Logical values and text representations of numbers that you type directly into the list of arguments are counted.
Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
If you do not want to include logical values and text representations of numbers in a reference as part of the calculation, use the VARP function.
If none of the values that have been supplied to the function are numeric, VARPA returns the #DIV/0! Error value.
If any values that are supplied directly to the Function are text values that cannot be interpreted as numeric values, VARPA returns the #VALUE! Error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016