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:
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.
1. You would divide the 33/3 first to get 11
2. Then you would add 1 to that answer to get 12
3. Then you would subtract 2^2 from that to get 8
Your answer would be 8.