Calculates the variance based on a sample of data.
Синтаксис
VAR(number1, [number2], …)Аргументы
number1обязательно
The first number or range of numbers corresponding to a sample of a population.
number2необязательно
Additional numbers or ranges up to 254 arguments.
The VAR function estimates variance based on a sample of a population. It ignores logical values and text contained in references, focusing only on numeric data points.
=VAR(10, 12, 23, 23, 16, 23, 21, 16)→28.57143Calculates the sample variance of the provided set of numbers.
Select the cell
Click on the cell where you want to display the variance result.
Enter the formula
Type =VAR( followed by your range of numbers or individual values, then close the parenthesis.
VAR calculates variance based on a sample, while VARP calculates variance based on the entire population.