Excel Function : VAR

Download now!

Excel Function : VAR

Category

Compatibility

Description

Estimates variance based on a sample

Microsoft Excel Reference Page

https://support.office.com/en-us/article/VAR-function-1f2b7ab2-954d-4e17-ba2c-9e58b15a7da2

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".