Excel Function : VAR

Download now!

Excel Function : VAR




Estimates variance based on a sample

Microsoft Excel Reference Page


Syntax and Description of the VAR Excel Function

The syntax for the VAR function in Microsoft Excel is: VAR(value1, [value2], ...) The VAR function takes one or more arguments. These arguments can be numbers, cells that contain numbers, or ranges of cells that contain numbers.

About VAR Excel Function

VAR(number1,number2,...) The VAR function calculates the variance of a population based on the entire population by default, or based on a sample of the population if you specify the optional parameter "B1:B100".