VAR Function in Excel – Calculate Sample Variance in Excel

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

Sample Variance is calculated using formula

VAR Function in Excel 1


  • X takes each value in the set;
  • X̄ is the average of the set of values;
  • N is the number of values.


Syntax of VAR Function in Excel:

VAR (number1, [number2], … )

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


Example of VAR Function in Excel

VAR Function in Excel 2

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

= VAR (A2:A13)

Which results in value 178.697

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