Buzz
This article provides a detailed guide on how to use the VAR Function, which estimates sample variance based on a given set.
Description: This function performs sample variance estimation based on a provided set. Its arguments can be numbers, names, arrays, or references containing numbers.
Syntax: VAR(number1, [number2],...).
Where:
- number 1: The first numeric argument corresponding to the population, is a required parameter.
- [number 2],..: Are numeric arguments from 2 to 255 corresponding to samples of the set, optional parameters.
Note:
- The function VAR assumes that the arguments are a sample from a set. If the data is a population, then use the VARP function to calculate the variance.
- The arguments of the function can be numbers, names, arrays, or references containing numbers.
- In case the arguments are arrays or references, only numerical values are considered, while logical values, text, and blank values are ignored in the calculation.
- If the arguments are text or error values, the function returns an error value because it cannot convert those values to numerical types.
- To incorporate logical values and text-formatted numbers into a reference for calculations, use the VARPA function.
- The formula for the VAR function is as follows:
Where:
- x represents the sample mean AVERAGE (number 1, number 2, …).
- n represents the sample size.
Example:
Calculate the VAR function with the following parameters:
In the cell where you want to calculate, enter the formula: =VAR(D6,D7,D8,D9).
Press Enter -> the result of the VAR function is:
If the parameter is empty or not in numeric format -> the parameter is ignored:
Here is how to use and some considerations when using the VAR function, hoping to be helpful to you.
Wishing you success!
