VAR function - The function of estimating variance based on a sample in Excel

The following article shows in detail how to use the VAR function, the function of estimating variance based on a sample.

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 :

VAR function - The function of estimating variance based on a sample in Excel Picture 1

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:

VAR function - The function of estimating variance based on a sample in Excel Picture 2

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

VAR function - The function of estimating variance based on a sample in Excel Picture 3

Press Enter -> VAR result value is:

VAR function - The function of estimating variance based on a sample in Excel Picture 4

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

VAR function - The function of estimating variance based on a sample in Excel Picture 5

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

Good luck!