Which of the following Excel functions is used for the chi-square test of independence?
A) CHIDIST
B) CHISQUARE
C) CHITEST
D) CHI

Question

Quizplus · Accepted Answer

The CHITEST function is used for the chi-square test of independence in Excel, calculating the probability that the observed correlation between two categorical variables could have occurred by chance. The other options, CHIDIST, CHISQUARE, and CHI, are also related to the chi-square distribution, but do not specifically apply to the independence test.

Which of the Following Excel Functions Is Used for the Chi-Square