Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please see my data below and show me how solve this questions on Excel only Polling is done to determine whether respondents are more interested
Please see my data below and show me how solve this questions on Excel only
Polling is done to determine whether respondents are more interested in the game or the commercials, and whether the answer to this differs by gender.
We wanted to determine if there is a difference in proportion between Females and Males who watch super bowl for commercial reason. Use alpha=0.05
a)State the null and alternate hypothesisb)
b) Conduct HT using =0.05. What's your decision?
c)Interpret the z-value and the p-value. What do these values mean in terms of evidence in favor or against the null hypothesis?
| Female | Male |
| Commercials | Commercials |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Game | Commercials |
| Game | Game |
| Commercials | Commercials |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Commercials |
| Game | Game |
| Commercials | Game |
| Game | Commercials |
| Commercials | Game |
| Commercials | Game |
| Commercials | Commercials |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Commercials |
| Commercials | Game |
| Commercials | Game |
| Game | Commercials |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Game | Game |
| Commercials | Commercials |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Game | Commercials |
| Game | Commercials |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Commercials |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Commercials |
| Commercials | Game |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Commercials |
| Game | Game |
| Game | Commercials |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Commercials |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Commercials |
| Game | Game |
| Commercials | Game |
| Commercials | Commercials |
| Game | Commercials |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Commercials |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Commercials |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Commercials |
| Game | Game |
| Commercials | Game |
| Game | Commercials |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Commercials |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Commercials |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Commercials | Game |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Commercials |
| Game | Commercials |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Commercials |
| Game | Commercials |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Commercials |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Commercials |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Commercials |
| Game | Game |
| Game | Game |
| Game | Game |
| Commercials | Commercials |
| Game | Commercials |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Game | Commercials |
| Game | Game |
| Commercials | Commercials |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Commercials | Game |
| Game | Commercials |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Commercials | Commercials |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Commercials |
| Game | Commercials |
| Commercials | Commercials |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Commercials |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Commercials | Commercials |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Commercials |
| Commercials | Game |
| Commercials | Commercials |
| Game | Game |
| Game | Commercials |
| Game | Game |
| Commercials | Game |
| Game | Commercials |
| Commercials | Game |
| Game | Game |
| Game | Game |
| Commercials | Commercials |
| Game | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Commercials | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Commercials | Game |
| Game | Game |
| Game | Commercials |
| Commercials | Game |
| Commercials | Commercials |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | Game |
| Game | |
| Game | |
| Game | |
| Game |
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
Statistical Inference
Authors: George Casella, Roger L. Berger
2nd edition
0534243126, 978-0534243128
