VAR Excel Formula

Author Zaheer    Category Formulas     Tags ,

The Excel has hundreds of functions and formulas wherein they are used mostly in calculating, evaluating, formatting, etc. One of this is the VAR function. The Variance is statistical evaluation that is usually used across sets of values, to recognize the total that the values differ from average value.

VAR Function Basics

Excel VAR functions returns the variation of sample set of value from the population.

VAR Function Syntax:

= VAR (number1, [numer2], …)

Wherein, number arguments offer the minimum of two numerical values of function. You can put more than 254 numbers of arguments to VAR function 2007 or in Excel 2010, though you can just enter more than thirty number arguments for Excel of 2003.


VAR function is being used if cunning the variance for sample of population, which is when the data set the record of the person’s height of sample UK males. When you are to calculate the variance for the whole population, you have to use Excel VARP or Excel VAR function.

Also, VAR function ignores the text values as well as the logical values when these values are full as a fraction of array. On the other hand, when they are supplied straight to the functions, text presentation of number and the logical values are being interpreted as number. Sample variance calculation which doesn’t ignore logical values and text are supplied as piece of the array in consideration with the VARA, if you like.

How to Use the VAR Functions in Excel?

Excel’s VAR functions estimate the variance of population by simply calculating the complex variance of samples. This function is the same to the VARA except that the VAR doesn’t accept logical values, errors, or text. Here are some steps that will show how you can make use of Excel’s VAR function.

  • Primarily, you have to learn syntax for this function, which is VAR (num_1, num_2…) wherein the number_1, number_2…are more than 30 values including the population sample. The VAR needs at least 1 number as argument. Use the VARP to calculate the variance when the values stand for the whole population.
  • Learn the suitable argument types for VAR function. These can be consists of names, arrays, numbers or references which contain the number. Basically, numbers in array or reference would be counted. Error values, empty cells, logical values or the content will be ignored.
  • Enter the text representation of the numbers and the logical values straight in the argument lists. Error values or the text that doesn’t stand for numbers would cause error. Make use of VARA function to take in logical values or the text representation of number in reference.
  • Compute the VAR as amount (value – AVERAGE (value one, value two…)) ^2/ (n-1) in which the value refers to every value of the population samples and size of population sample. For instance:

VAR(1345,1301,1368,1322,1310,1370,1318,1350,1303,1299) = 754.2666667.

  • Look at the ways used to detect the variance. Version of Excel before Excel 2003 completed this calculation in single pass. The accurateness was enhanced in Excel 2003 as well as the later version through using two pass procedures to minimize the round-off error.

Post comment