MS Excel: Var Function

In Excel, the Var function returns the variance of a population based on a sample of numbers.

The syntax for the Var function is:

Var( number1, number2, ... number_n )

number1, number2, ... number_n are the sample 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:

=Var(C2, C3, C4, C5) would return 3.6178

=Var(D2, D3, D4) would return 91.79203333

=Var(34.5, 2, 8.9, -4) would return 286.99