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.