MS Excel: VarP Function

In Excel, the VarP function returns the variance of a population based on an entire population of numbers.

The syntax for the VarP function is:

VarP( number1, number2, ... number_n )

number1, number2, ... number_n are the population numbers. There can be up to 30 numbers entered.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

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

=VarP(D2, D3, D4) would return 61.19468889

=VarP(34.5, 2, 8.9, -4) would return 215.2425