Good day tutor, could you kindly assist in answering the questions(7-10 only)below. Please take note of the instructions, sets of questions (1-6) for reference only and data set showns below. Start from question 7, thank you

Thesecond data set contains data for the favorite sport freshmen at Big Ten Universities best like to watch. The following are instructions for two different hypothesis tests: the first (#s 1-6) is about the difference in population means (1 2 ); the second (#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.

7. State the hypotheses for this test.

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

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

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.