VAR.P Function in Excel

VAR.P 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 formula

VAR.P Function in Excel 1


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


Syntax of VAR.P Function in Excel:

VAR.P (number1, [number2], … )

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


Example of VAR.P Function in Excel

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

= VAR.P (A2:A13)

Which results in value 163.8055556

previous-small VAR.P Function in Excel                                                                                                                next_small VAR.P Function in Excel