Which function in excel is used to perform a test of independence? a. t. test b. chisq. test c. norm. s.dist d. z. test

b. CHISQ.TEST

Step-by-step explanation:

Notation and previous concepts

A chi-square test is "used to test if the variance of a population is equal to a specified value. This test can be either a two-sided test or a one-sided test. The two-sided version tests against the alternative that the true variance is either less than or greater than the specified value"

The statistic is given by:

In order to calculate the p value we need to have in count the degrees of freedom , on this case . And we can calculate the p value would be given by:

But the correct comand is given by:

b. CHISQ.TEST(Actual range, Expected range)

We just need to put in one column the Observed values and in other the expectec values.