The Excel function CHISQ.TEST()will return the ________.
A)probability associated with a t-Test Statistic and the appropriate degrees of freedom
B)probability associated with the degree of linearity observed within the groups
C)test for independence: the value from the chi-square distribution for the statistic and the appropriate degrees of freedom
D)left-tailed probability of the chi-square distribution

Question

Quizplus · Accepted Answer

The CHISQ.TEST() function in Excel is used to test for independence in contingency tables. It returns the value from the chi-square distribution for the test statistic and the appropriate degrees of freedom. Therefore, option C is the correct answer. Options A, B, and D are all incorrect as they do not relate to the use of the CHISQ.TEST() function.

The Excel Function CHISQ.TEST()will Return the ________