Answer:
The proportions differ from those reported in the survey.
Step-by-step explanation:
The Chi-square goodness of fit test would be used to determine whether the proportions differ from those reported in the survey.
The hypothesis for the test can be defined as follows:
H₀: The proportions does not differ from those reported in the survey.
Hₐ: The proportions differ from those reported in the survey.
Assume that the significance level of the test is, α = 0.01.
The Chi-square test statistic is given by:
[tex]\chi^{2}=\sum\limits^{n}_{i=1}{\frac{(O_{i}-E_{i})^{2}}{E_{i}}}[/tex]
Consider the Excel sheet provided.
The Chi-square test statistic value is 191.32.
The p-value of the test is:
[tex]p-value=P(\chi^{2}_{(n-1)}>191.32)\\\\=\text{CHISQ.DIST.RT}(191.32,2)\\\\=0.0000[/tex]
The p-value of the test is very small. The null hypothesis will be rejected at 1% level of significance.
Thus, concluding that the proportions differ from those reported in the survey.
