Good day tutor, could you kindly assist in answering the questions(11-13 only)below.

I have answered question 7-10, please also take note of the instructions and use the data set below for reference. Thank you

Instructions

TheData set contains data for the favorite sport freshmen at Big Ten Universities best like to watch. (#s 7-12) is a Chi-Square Goodness of Fit test.

For Problems 7 - 13: The Favorite Sport worksheet contains data forthe sport that a sample of randomly selected freshmen at Big Ten Universities reported liking best to watch. A past study found the following percentages for the sports that freshmen at Big Ten Schools like to watch best: 35% football, 32% basketball, 18% volleyball, 8% wrestling, and 7% baseball/softball. Test whether the new data provide evidence to support that the distribution of favorite sports for freshmen at Big Ten Universities is as claimed by the past study. Use = 0.05.

-----------------------------------Completed answer below----------------------------------------

7. State the hypotheses for this test.

H₀: p₁= 0.35, p₂= 0.32, p₃= 0.18, p₄= 0.08, p₅ = 0.07

H₁:At least one proportion differs from the given distribution

8. Copy and paste the PivotTable (Cells C2:D8)

Freshmen's Favorite Sport	Frequency
Football	433
Basketball	385
Volleyball	241
Wrestling	72
Baseball/Softball	74
Grand Total	1205

9. In Cells G2:K2 type the hypothesized (claimed) proportions for each sport category. Copy and paste Cells F1:K3

Football	Basketball	Volleyball	Wrestling	Baseball/Softball
Hypothesized proportions	0.35	0.32	0.18	0.08
Expected Counts	1205 * 0.35	1205 * 0.32	1205 * 0.18	1205 * 0.08
Components for 2
2 Statistic (CHI-SQUARE TEST STATISTIC)
Degrees of freedom
p-value

Football	Basketball	Volleyball	Wrestling	Baseball/Softball
Hypothesized proportions	0.35	0.32	0.18	0.08
Expected Counts	421.75	385.6	216.9	96.4
Components for 2
2 Statistic (CHI-SQUARE TEST STATISTIC)
Degrees of freedom
p-value

10. In Cells G5:K5 use Excel to compute the components for the 2 test statistic, () 2 , for each sport category. In Cell G7, sum the components (Cells G5:K5) to obtain the test statistic.state the name of the test statistic and its value, rounded to 2 decimals.

Football	Basketball	Volleyball	Wrestling	Baseball/Softball
Hypothesized proportions	0.35	0.32	0.18	0.08
Expected Counts	421.75	385.6	216.9	96.4
Components for 2	(433 - 421.75)2 / 421.75	(385 - 385.6)2 / 385.6	(241 - 216.9)2 / 216.9	(72 - 96.4)2 / 96.4
2 Statistic (CHI-SQUARE TEST STATISTIC)	10.42
Degrees of freedom	4
p-value	0.0339

Since 0.0339 (p-value) < 0.05 (), therefore there is enough statistical evidence to reject the null hypothesis H₀ and we can conclude at 5% significance level that at least one proportion differs from the given distribution.

-------- START HERE -------

11. In Cell G9, enter the degrees of freedom for the distribution of this test statistic. In Cell G11, use Excel to find this test's p-value. Type the p-value, to 6 decimals.

12. Use the Chi-Square table to find the critical value(s) for the rejection region for this test; type the value(s)

13. Compare the p-value to , or the test statistic to the critical value(s); type the conclusion

------------ END ------------------

Data sets given to solve the above questions/overview: