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

b. CHISQ.TEST

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 ((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.