< Go Back

Excel VARPA Function

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.

  1. 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.
  2. 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.
  3. The text representations of numbers typed directly as an argument in Excel VARPA function argument are counted.
  4. To ignore logical and text values in references you must use VARP or VAR.P function to calculate variance based on entire population.
  5. Excel VARPA function returns #VALUE! error when you enter text value directly as the argument.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment