Answer :
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:
[tex]\chi^2 = \sum_{i=1}^n \frac{(O_i-E_i)^2}{E_i}[/tex]
In order to calculate the p value we need to have in count the degrees of freedom , on this case [tex]df=(rows-1)(#cols-1)[/tex]. And we can calculate the p value would be given by:
[tex]p_v =P(\chi^2 >\chi^2_{calc})[/tex]
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.