Question

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

Answer 1

Answer:

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:

$\chi^2 = \sum_{i=1}^n \frac{(O_i-E_i)^2}{E_i}$

In order to calculate the p value we need to have in count the degrees of freedom , on this case $df=(rows-1)(#cols-1)$. And we can calculate the p value would be given by:

$p_v =P(\chi^2 >\chi^2_{calc})$

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.