Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Good day tutor, could you kindly assist in answering the questions (11-13 only) below. Instructions The Data set contains data for the favorite sport freshmen
Good day tutor, could you kindly assist in answering the questions(11-13 only)below.
Instructions
TheData set contains data for the favorite sport freshmen at Big Ten Universities best like to watch. (#s 11-13) is a Chi-Square Goodness of Fit test.
For Problems 11 - 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.
-------- 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:
| Freshmen's Favorite Sport | Frequency |
| Football | 433 |
| Basketball | 385 |
| Volleyball | 241 |
| Wrestling | 72 |
| Baseball/Softball | 74 |
| Grand Total | 1205 |
| 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 |
| Freshmen's Favorite Sport |
| Football |
| Wrestling |
| Basketball |
| Volleyball |
| Basketball |
| Basketball |
| Wrestling |
| Baseball/Softball |
| Volleyball |
| Football |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Wrestling |
| Basketball |
| Football |
| Football |
| Wrestling |
| Volleyball |
| Football |
| Football |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Football |
| Wrestling |
| Basketball |
| Volleyball |
| Basketball |
| Basketball |
| Wrestling |
| Wrestling |
| Basketball |
| Basketball |
| Baseball/Softball |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Wrestling |
| Football |
| Volleyball |
| Football |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Wrestling |
| Football |
| Basketball |
| Football |
| Football |
| Volleyball |
| Basketball |
| Baseball/Softball |
| Football |
| Basketball |
| Basketball |
| Football |
| Football |
| Football |
| Volleyball |
| Football |
| Baseball/Softball |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Volleyball |
| Football |
| Wrestling |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Football |
| Volleyball |
| Baseball/Softball |
| Basketball |
| Volleyball |
| Baseball/Softball |
| Wrestling |
| Volleyball |
| Volleyball |
| Basketball |
| Basketball |
| Wrestling |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Football |
| Football |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Volleyball |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Wrestling |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Wrestling |
| Football |
| Wrestling |
| Basketball |
| Football |
| Football |
| Basketball |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Wrestling |
| Football |
| Football |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Football |
| Volleyball |
| Basketball |
| Football |
| Football |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Volleyball |
| Football |
| Volleyball |
| Football |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Volleyball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Football |
| Wrestling |
| Basketball |
| Basketball |
| Football |
| Football |
| Volleyball |
| Football |
| Basketball |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Basketball |
| Basketball |
| Football |
| Football |
| Basketball |
| Wrestling |
| Volleyball |
| Football |
| Baseball/Softball |
| Football |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Wrestling |
| Basketball |
| Volleyball |
| Basketball |
| Basketball |
| Volleyball |
| Volleyball |
| Basketball |
| Volleyball |
| Football |
| Baseball/Softball |
| Football |
| Basketball |
| Football |
| Football |
| Baseball/Softball |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Football |
| Football |
| Football |
| Volleyball |
| Football |
| Wrestling |
| Basketball |
| Basketball |
| Wrestling |
| Wrestling |
| Volleyball |
| Football |
| Volleyball |
| Football |
| Football |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Football |
| Baseball/Softball |
| Volleyball |
| Football |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Volleyball |
| Football |
| Football |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Wrestling |
| Football |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Basketball |
| Wrestling |
| Basketball |
| Basketball |
| Volleyball |
| Basketball |
| Basketball |
| Volleyball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Football |
| Football |
| Basketball |
| Basketball |
| Football |
| Football |
| Basketball |
| Baseball/Softball |
| Volleyball |
| Football |
| Football |
| Basketball |
| Wrestling |
| Basketball |
| Volleyball |
| Football |
| Basketball |
| Volleyball |
| Football |
| Baseball/Softball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Baseball/Softball |
| Basketball |
| Volleyball |
| Basketball |
| Wrestling |
| Basketball |
| Football |
| Baseball/Softball |
| Football |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Volleyball |
| Basketball |
| Volleyball |
| Football |
| Basketball |
| Baseball/Softball |
| Football |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Football |
| Basketball |
| Volleyball |
| Wrestling |
| Volleyball |
| Basketball |
| Football |
| Football |
| Basketball |
| Baseball/Softball |
| Football |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Volleyball |
| Wrestling |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Volleyball |
| Wrestling |
| Basketball |
| Volleyball |
| Wrestling |
| Basketball |
| Baseball/Softball |
| Football |
| Baseball/Softball |
| Wrestling |
| Basketball |
| Basketball |
| Wrestling |
| Volleyball |
| Baseball/Softball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Volleyball |
| Football |
| Football |
| Football |
| Basketball |
| Football |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Football |
| Baseball/Softball |
| Football |
| Baseball/Softball |
| Football |
| Football |
| Football |
| Football |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Football |
| Football |
| Baseball/Softball |
| Football |
| Wrestling |
| Football |
| Basketball |
| Basketball |
| Baseball/Softball |
| Baseball/Softball |
| Football |
| Volleyball |
| Volleyball |
| Volleyball |
| Football |
| Basketball |
| Volleyball |
| Baseball/Softball |
| Volleyball |
| Volleyball |
| Football |
| Wrestling |
| Volleyball |
| Football |
| Volleyball |
| Basketball |
| Wrestling |
| Volleyball |
| Football |
| Football |
| Football |
| Basketball |
| Football |
| Football |
| Basketball |
| Football |
| Football |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Football |
| Football |
| Volleyball |
| Football |
| Baseball/Softball |
| Basketball |
| Football |
| Basketball |
| Football |
| Basketball |
| Wrestling |
| Baseball/Softball |
| Football |
| Baseball/Softball |
| Football |
| Football |
| Wrestling |
| Baseball/Softball |
| Baseball/Softball |
| Basketball |
| Wrestling |
| Basketball |
| Volleyball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Volleyball |
| Football |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Volleyball |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Basketball |
| Football |
| Football |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Football |
| Volleyball |
| Basketball |
| Football |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Football |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Volleyball |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Basketball |
| Volleyball |
| Volleyball |
| Football |
| Volleyball |
| Baseball/Softball |
| Basketball |
| Baseball/Softball |
| Basketball |
| Basketball |
| Basketball |
| Volleyball |
| Volleyball |
| Football |
| Football |
| Football |
| Basketball |
| Volleyball |
| Volleyball |
| Basketball |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Basketball |
| Football |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Baseball/Softball |
| Wrestling |
| Wrestling |
| Football |
| Football |
| Football |
| Basketball |
| Football |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Baseball/Softball |
| Baseball/Softball |
| Basketball |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Football |
| Wrestling |
| Volleyball |
| Football |
| Basketball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Football |
| Volleyball |
| Football |
| Football |
| Basketball |
| Baseball/Softball |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Volleyball |
| Football |
| Wrestling |
| Basketball |
| Football |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Basketball |
| Volleyball |
| Volleyball |
| Basketball |
| Basketball |
| Baseball/Softball |
| Basketball |
| Wrestling |
| Football |
| Baseball/Softball |
| Basketball |
| Volleyball |
| Football |
| Volleyball |
| Basketball |
| Baseball/Softball |
| Basketball |
| Football |
| Football |
| Volleyball |
| Basketball |
| Football |
| Football |
| Basketball |
| Football |
| Football |
| Baseball/Softball |
| Football |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Football |
| Football |
| Volleyball |
| Football |
| Baseball/Softball |
| Basketball |
| Volleyball |
| Basketball |
| Wrestling |
| Football |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Football |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Volleyball |
| Baseball/Softball |
| Basketball |
| Basketball |
| Baseball/Softball |
| Volleyball |
| Basketball |
| Baseball/Softball |
| Basketball |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Baseball/Softball |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Football |
| Volleyball |
| Volleyball |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Football |
| Volleyball |
| Volleyball |
| Wrestling |
| Football |
| Basketball |
| Volleyball |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Volleyball |
| Wrestling |
| Football |
| Football |
| Basketball |
| Volleyball |
| Football |
| Basketball |
| Basketball |
| Baseball/Softball |
| Volleyball |
| Volleyball |
| Basketball |
| Football |
| Wrestling |
| Basketball |
| Baseball/Softball |
| Basketball |
| Baseball/Softball |
| Football |
| Football |
| Football |
| Basketball |
| Baseball/Softball |
| Volleyball |
| Football |
| Football |
| Football |
| Football |
| Football |
| Football |
| Wrestling |
| Football |
| Football |
| Volleyball |
| Football |
| Basketball |
| Football |
| Volleyball |
| Basketball |
| Wrestling |
| Volleyball |
| Football |
| Football |
| Basketball |
| Football |
| Football |
| Baseball/Softball |
| Basketball |
| Basketball |
| Volleyball |
| Basketball |
| Basketball |
| Volleyball |
| Volleyball |
| Baseball/Softball |
| Baseball/Softball |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Basketball |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Football |
| Football |
| Basketball |
| Football |
| Volleyball |
| Football |
| Basketball |
| Football |
| Basketball |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Football |
| Basketball |
| Basketball |
| Volleyball |
| Football |
| Volleyball |
| Football |
| Baseball/Softball |
| Football |
| Football |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Football |
| Wrestling |
| Volleyball |
| Football |
| Basketball |
| Football |
| Football |
| Baseball/Softball |
| Volleyball |
| Baseball/Softball |
| Baseball/Softball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Football |
| Football |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Baseball/Softball |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Football |
| Football |
| Basketball |
| Football |
| Football |
| Football |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Volleyball |
| Football |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Volleyball |
| Football |
| Football |
| Basketball |
| Volleyball |
| Volleyball |
| Wrestling |
| Volleyball |
| Baseball/Softball |
| Football |
| Volleyball |
| Basketball |
| Wrestling |
| Football |
| Football |
| Volleyball |
| Baseball/Softball |
| Football |
| Basketball |
| Basketball |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Basketball |
| Wrestling |
| Volleyball |
| Basketball |
| Baseball/Softball |
| Football |
| Baseball/Softball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Wrestling |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Wrestling |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Baseball/Softball |
| Volleyball |
| Football |
| Volleyball |
| Volleyball |
| Baseball/Softball |
| Basketball |
| Volleyball |
| Wrestling |
| Football |
| Football |
| Volleyball |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Football |
| Volleyball |
| Basketball |
| Volleyball |
| Volleyball |
| Football |
| Football |
| Football |
| Football |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Volleyball |
| Volleyball |
| Football |
| Football |
| Football |
| Baseball/Softball |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Football |
| Football |
| Football |
| Basketball |
| Baseball/Softball |
| Wrestling |
| Football |
| Football |
| Football |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Wrestling |
| Football |
| Volleyball |
| Wrestling |
| Baseball/Softball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Basketball |
| Football |
| Football |
| Volleyball |
| Wrestling |
| Basketball |
| Wrestling |
| Volleyball |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Football |
| Basketball |
| Volleyball |
| Volleyball |
| Football |
| Basketball |
| Football |
| Football |
| Basketball |
| Football |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Football |
| Football |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Football |
| Football |
| Wrestling |
| Football |
| Football |
| Football |
| Basketball |
| Volleyball |
| Baseball/Softball |
| Baseball/Softball |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Wrestling |
| Wrestling |
| Wrestling |
| Volleyball |
| Football |
| Basketball |
| Baseball/Softball |
| Baseball/Softball |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Baseball/Softball |
| Basketball |
| Football |
| Basketball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Basketball |
| Wrestling |
| Volleyball |
| Basketball |
| Basketball |
| Football |
| Football |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Volleyball |
| Football |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Baseball/Softball |
| Wrestling |
| Football |
| Football |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Volleyball |
| Volleyball |
| Basketball |
| Volleyball |
| Volleyball |
| Football |
| Football |
| Basketball |
| Basketball |
| Wrestling |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Football |
| Football |
| Football |
| Volleyball |
| Volleyball |
| Basketball |
| Wrestling |
| Basketball |
| Volleyball |
| Volleyball |
| Football |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Football |
| Basketball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Volleyball |
| Wrestling |
| Basketball |
| Basketball |
| Football |
| Basketball |
| Football |
| Football |
| Football |
| Football |
| Football |
| Football |
| Football |
| Football |
| Basketball |
| Football |
| Basketball |
| Basketball |
| Football |
| Volleyball |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Volleyball |
| Wrestling |
| Basketball |
| Volleyball |
| Basketball |
| Football |
| Football |
| Wrestling |
| Basketball |
| Volleyball |
| Basketball |
| Basketball |
| Baseball/Softball |
| Volleyball |
| Football |
| Football |
| Football |
| Volleyball |
| Basketball |
| Basketball |
| Basketball |
| Football |
| Football |
| Basketball |
| Football |
| Volleyball |
| Volleyball |
| Baseball/Softball |
| Football |
| Volleyball |
| Volleyball |
| Volleyball |
| Football |
| Basketball |
| Football |
| Volleyball |
| Basketball |
| Football |
| Volleyball |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Cambridge IGCSE And O Level Additional Mathematics
Authors: Val Hanrahan, Jeanette Powell
1st Edition
1510421645, 978-1510421646
