Calculates the variance based on a sample of data.
Cú pháp
VAR(number1, [number2], …)Đối số
number1bắt buộc
The first number or range of numbers corresponding to a sample of a population.
number2tùy chọn
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.