What function returns the variance of a population?
A)VARA
B)VAR.P
C)VAR.S
D)VARPA

Question

Quizplus · Accepted Answer

VAR.P is the function that returns the variance of a population. VARA and VARPA are functions that return the variance of a sample, while VAR.S returns the variance of a sample, but using the n-1 method instead of the n method, which is not usually necessary for large datasets. Therefore, B is the best choice for returning the variance of a population.

What Function Returns the Variance of a Population