Excel VARPA Function
Excel VARPA function calculates the variance of the entire population including logical and text values. Text and the logical value FALSE have the value 0 and logical value TRUE has the value 1. Excel VARPA function is categorized under Statistical functions.
The syntax for Excel VARPA function is:
=VARPA( Value1, [Value2, ... Value_n] )
It has the following arguments:
Value1 – It is required argument and is first population value. It can be a number, text, or a logical value.
[value2], … – These are optional arguments and additional population values. These can be numbers, text, and logical values and can be up to 255 values entered in total.
Excel VARPA function is used for entire population data instead of just sample data. Excel VARPA function accepts arguments as numbers, range name, arrays or cell references that contain numbers, text values, logical values, such as TRUE and FALSE in a reference. Empty cells in arrays or cell references are ignored in Excel VARPA function.
For example, you have subject scores of your given population and population data contains numbers, logical value and text values in an array. You can calculate the variance of entire population evaluation numbers, logical and text values using cell references in Excel VARPA function as shown in below table.
Figure 1: VARPA_Function
Following points must be remembered while using Excel VARPA function.
- VARPA assumes that arguments values represent the entire population. If your data represents a sample of the population you must use Excel VARA function to calculate variance.
- Logical and Text values within arrays or reference arguments are evaluated in Excel VARPA Function. Text and logical value FALSE are taken as 0 and logical value TRUE is taken as 1.
- The text representations of numbers typed directly as an argument in Excel VARPA function argument are counted.
- To ignore logical and text values in references you must use VARP or VAR.P function to calculate variance based on entire population.
- Excel VARPA function returns #VALUE! error when you enter text value directly as the argument.