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.
You have to add all the common terms together.
Answer:
a) 26. b) 13
Step-by-step explanation:
steps are in picture.
Note:If you have any question about it you can ask.
Answer:
18
Step-by-step explanation: