Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Looking for step by step excel input instructions: Include a table that shows the descriptive statistics using the data analysis tool pack in Excel for
Looking for step by step excel input instructions:
- Include a table that shows the descriptive statistics using the data analysis tool pack in Excel for the ratings of the three networks (one column for each network). Show steps of how to get the table
- The executives wish to know if they should hire stars for their programs. To answer this question, run a hypothesis test to see if the ratings of shows with stars are higher compared to those without stars. Use the data for CBC movies only. Use 95% confidence. Your answer should include the following:
- The null and alternative hypotheses (state in full sentences).
- The test results: Run the test using Excel and include the output table. Use a t-test assuming equal variances.
- What is your recommendation to the executives? Justify your answer referring to the relevant figures.
For Q2 I need step by step of how I can do this on excel
| Observation | Network | Month | Day | Rating | Fact | Stars |
| 1 | BBS | 1 | 1 | 15.6 | 0 | 1 |
| 2 | BBS | 1 | 7 | 10.8 | 1 | 0 |
| 3 | BBS | 1 | 7 | 14.1 | 0 | 1 |
| 4 | BBS | 1 | 1 | 16.8 | 1 | 1 |
| 5 | BBS | 2 | 1 | 14.3 | 1 | 1 |
| 6 | BBS | 2 | 1 | 17.1 | 1 | 1 |
| 7 | BBS | 3 | 1 | 15.8 | 0 | 0 |
| 8 | BBS | 3 | 7 | 16.2 | 1 | 0 |
| 9 | BBS | 4 | 7 | 12.6 | 0 | 1 |
| 10 | BBS | 5 | 1 | 13.5 | 0 | 1 |
| 11 | BBS | 5 | 7 | 15.6 | 0 | 0 |
| 12 | BBS | 5 | 1 | 12.1 | 0 | 1 |
| 13 | BBS | 5 | 1 | 15.8 | 1 | 0 |
| 14 | BBS | 9 | 7 | 15 | 1 | 0 |
| 15 | BBS | 9 | 7 | 16.3 | 0 | 0 |
| 16 | BBS | 9 | 7 | 13.3 | 0 | 1 |
| 17 | BBS | 10 | 7 | 10.8 | 0 | 1 |
| 18 | BBS | 10 | 7 | 14.4 | 1 | 0 |
| 19 | BBS | 11 | 7 | 14.4 | 1 | 1 |
| 20 | BBS | 11 | 7 | 13.6 | 1 | 0 |
| 21 | ABN | 1 | 7 | 14.6 | 0 | 0 |
| 22 | ABN | 1 | 2 | 9.8 | 0 | 1 |
| 23 | ABN | 1 | 7 | 16.2 | 0 | 0 |
| 24 | ABN | 1 | 2 | 12.8 | 0 | 0 |
| 25 | ABN | 1 | 7 | 16 | 0 | 1 |
| 26 | ABN | 2 | 7 | 18.9 | 0 | 1 |
| 27 | ABN | 2 | 2 | 17.6 | 1 | 1 |
| 28 | ABN | 3 | 7 | 19.5 | 1 | 1 |
| 29 | ABN | 3 | 2 | 16.9 | 1 | 0 |
| 30 | ABN | 3 | 7 | 16.3 | 0 | 1 |
| 31 | ABN | 3 | 7 | 15.8 | 1 | 0 |
| 32 | ABN | 3 | 7 | 17.1 | 0 | 1 |
| 33 | ABN | 3 | 2 | 15.8 | 0 | 0 |
| 34 | ABN | 3 | 7 | 16 | 1 | 0 |
| 35 | ABN | 3 | 2 | 27.4 | 0 | 1 |
| 36 | ABN | 4 | 2 | 14.2 | 0 | 0 |
| 37 | ABN | 4 | 7 | 18.1 | 0 | 0 |
| 38 | ABN | 4 | 2 | 15.2 | 0 | 0 |
| 39 | ABN | 4 | 7 | 19.8 | 0 | 1 |
| 40 | ABN | 4 | 7 | 15.5 | 1 | 0 |
| 41 | ABN | 4 | 2 | 16.6 | 1 | 0 |
| 42 | ABN | 5 | 7 | 16.3 | 1 | 0 |
| 43 | ABN | 5 | 7 | 23.8 | 0 | 1 |
| 44 | ABN | 5 | 2 | 16.8 | 1 | 0 |
| 45 | ABN | 9 | 7 | 15.4 | 0 | 1 |
| 46 | ABN | 9 | 2 | 14.7 | 0 | 0 |
| 47 | ABN | 9 | 7 | 15.5 | 0 | 0 |
| 48 | ABN | 9 | 2 | 14.7 | 1 | 0 |
| 49 | ABN | 10 | 7 | 15.9 | 1 | 0 |
| 50 | ABN | 10 | 7 | 13.8 | 1 | 0 |
| 51 | ABN | 10 | 2 | 14.9 | 0 | 1 |
| 52 | ABN | 11 | 7 | 12.9 | 0 | 1 |
| 53 | ABN | 11 | 2 | 15.4 | 1 | 0 |
| 54 | ABN | 11 | 7 | 14.5 | 0 | 2 |
| 55 | ABN | 12 | 7 | 12.6 | 0 | 2 |
| 56 | ABN | 12 | 2 | 11.8 | 0 | 0 |
| 57 | ABN | 12 | 2 | 12.8 | 0 | 0 |
| 58 | ABN | 12 | 7 | 16.8 | 0 | 1 |
| 59 | CBC | 1 | 7 | 14.7 | 0 | 1 |
| 60 | CBC | 1 | 1 | 11.3 | 1 | 0 |
| 61 | CBC | 2 | 1 | 13.5 | 0 | 1 |
| 62 | CBC | 2 | 7 | 12.9 | 1 | 0 |
| 63 | CBC | 3 | 1 | 13.2 | 1 | 0 |
| 64 | CBC | 3 | 7 | 12.8 | 1 | 0 |
| 65 | CBC | 4 | 1 | 13.2 | 1 | 1 |
| 66 | CBC | 4 | 7 | 13.5 | 0 | 1 |
| 67 | CBC | 5 | 1 | 17.5 | 1 | 0 |
| 68 | CBC | 5 | 7 | 11.6 | 0 | 0 |
| 69 | CBC | 5 | 7 | 12.1 | 0 | 0 |
| 70 | CBC | 6 | 1 | 15.6 | 1 | 0 |
| 71 | CBC | 6 | 7 | 12.6 | 0 | 1 |
| 72 | CBC | 6 | 1 | 11.8 | 0 | 0 |
| 73 | CBC | 7 | 7 | 12.3 | 0 | 0 |
| 74 | CBC | 7 | 1 | 14.2 | 1 | 1 |
| 75 | CBC | 8 | 7 | 11.6 | 0 | 0 |
| 76 | CBC | 8 | 1 | 13.3 | 1 | 0 |
| 77 | CBC | 8 | 1 | 13.6 | 1 | 0 |
| 78 | CBC | 9 | 1 | 12.4 | 0 | 1 |
| 79 | CBC | 9 | 1 | 13.8 | 1 | 0 |
| 80 | CBC | 9 | 7 | 11.9 | 0 | 0 |
| 81 | CBC | 10 | 1 | 14.6 | 0 | 0 |
| 82 | CBC | 10 | 1 | 15.8 | 1 | 1 |
| 83 | CBC | 10 | 1 | 15.4 | 1 | 1 |
| 84 | CBC | 11 | 1 | 13.1 | 0 | 1 |
| 85 | CBC | 11 | 7 | 12.8 | 0 | 0 |
| 86 | CBC | 12 | 1 | 15.1 | 0 | 0 |
| 87 | CBC | 12 | 1 | 12.4 | 0 | 1 |
| 88 | CBC | 12 | 1 | 19.1 | 1 | 0 |
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
Understanding Analysis
Authors: Stephen Abbott
2nd Edition
1493927124, 9781493927128
