Which of the following functions is best suited to calculate the variance of a population including logical values and text?
A)VAR.P
B)VARA
C)VARPA
D)VAR.S

Question

Quizplus · Accepted Answer

The VARPA function is best suited to calculate the variance of a population including logical and text values. This function includes all values in the population, including logical and text values, in the calculation of the variance. The VAR.P function excludes text values and the VAR.S function excludes logical values, while VARA includes all types of values but calculates the sample variance instead of the population variance.

Which of the Following Functions Is Best Suited to Calculate