Excel: VarPA Function

In Excel, the VarPA function returns the variance of a population based on an entire population of numbers, text, and logical values (ie: TRUE or FALSE).

The syntax for the VarPA function is:

VarPA( value1, value2, ... value_n )

value1, value2, ... value_n are the population values. They can be numbers, text, and logical values. Values that are TRUE are evaluated as 1. Values that are FALSE or text values are evaluated as 0. There can be up to 30 values entered.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=VarPA(C2, C3, C4, C5) would return 2.71335

=VarPA(D2, D3, D4) would return 81.69468889

=VarPA(34.5, 2, 8.9, -4, FALSE) would return 189.3336