VARP Function in Excel – Calculate the Population variance in Excel

VARP function in Excel calculates the population variance of a supplied set of values. Variance, measures the deviation of number from the average value.

Population Variance is calculated using formulaVARP function in Excel 1

Where,

  • x takes each value in the set;
  • µ is the average of the set of values;
  • N is the number of values.

 

Syntax of VARP Function in Excel:

VARP (number1, [number2], … )

Where the number arguments are numeric values for which you want to calculate the population variance.

 

Example of VARP Function in Excel

VARP function in Excel 2

The Above example calculates the population variance of subject scores with formula

= VARP (A2:A13)

Which results in value 163.8056

previous-small VARP Function in Excel                                                                                                                next_small VARP Function in Excel