Calculates the variance of a population based on the entire set of provided numbers.
구문
VAR.P(number1, [number2], ...)인수
number1필수
The first number or range of numbers corresponding to a population.
number2선택
Additional numbers or ranges up to 254 arguments.
The VAR.P function measures how far a set of numbers are spread out from their average value. It assumes that the provided arguments represent the entire population of data. Unlike sample variance, it uses the n method rather than n-1.
=VAR.P(10, 12, 23, 23, 16, 23, 21, 16)→21.6875Calculates the population variance for the given set of eight numbers.
Select the cell
Click on the cell where you want to display the variance result.
Enter the function
Type =VAR.P( followed by the range of your data and close with a parenthesis.
Calculate
Press Enter to see the calculated population variance.
VAR.P calculates variance for an entire population, while VAR.S calculates variance for a sample of the population.