How to Use the VAR Function in Excel

This guide explains how to use VAR Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function performs an estimate of the latter based on a sample from a given set. Function arguments can be numbers, names or arrays, or references containing numbers.

Syntax : VAR (number 1, [number 2]. ) .

Inside:

- number 1 : The first numeric argument corresponding to the overall sample, is a required parameter.

- [number 2]. : Are numerical arguments from 2 -> 255 corresponding to a sample of the set, which is an optional parameter.

Attention:

- Because the VAR function assumes that the arguments are a sample of the population, if the data is a collection then use the VARP function to calculate variance.

- Function arguments can be numbers, names, arrays, or references that contain numbers.

- Where arguments are arrays or references of new values or references are counted while logical values, text, and blank values are ignored.

- Arguments that are text or error values that return an error value because they cannot be converted to numeric types.

- If you want to use logical values and present numeric text into a reference to calculate need to use additional VARPA function.

- Equation of the VAR function:

Inside:

- x is the sample mean AVERAGE (number 1, number 2. ).

- n is the sample size.

For example:

Calculate the value of the VAR function with the following parameters:

In the cell to calculate enter the formula: = VAR (D6, D7, D8, D9) .

Press Enter -> VAR result value is:

Where the parameter is a blank value or not a numeric form -> parameter is ignored:

Above is how to use and some notes when using the VAR function, hope to help you.

Good luck!