Question
The executives at CBC have four main areas in which they are interested: They want to see how they are doing in ratings against the
The executives at CBC have four main areas in which they are interested: They want to see how they are doing in ratings against the other networks and how the ratings will continue to change in the upcoming months. They also want to know if hiring stars makes a difference and the impact of fact-based programming compared to hiring stars.
1. Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact. Use data from CBC only. CBC Management has several questions:
Provide Excel steps and explaination.
a. Executives wish to know how much being fact-based or having one star contributes to a movies rating. What can you tell them about this?
b, Are either, both, or neither of the independent variables significantly related to the ratings at 95% confidence? Justify your answers referring to the relevant figures.
c. How well does this regression analysis explain the ratings? Should the executives count on the results from this analysis? Justify your answers referring to the relevant figures.
| Movie Network | Month | Day | Movie Rating | Fact | Stars |
| BBS | 1 | 1 | 15.6 | 0 | 1 |
| BBS | 1 | 7 | 10.8 | 1 | 0 |
| BBS | 1 | 7 | 14.1 | 0 | 1 |
| BBS | 1 | 1 | 16.8 | 1 | 1 |
| BBS | 2 | 1 | 14.3 | 1 | 1 |
| BBS | 2 | 1 | 17.1 | 1 | 1 |
| BBS | 3 | 1 | 15.8 | 0 | 0 |
| BBS | 3 | 7 | 16.2 | 1 | 0 |
| BBS | 4 | 7 | 12.6 | 0 | 1 |
| BBS | 5 | 1 | 13.5 | 0 | 1 |
| BBS | 5 | 7 | 15.6 | 0 | 0 |
| BBS | 5 | 1 | 12.1 | 0 | 1 |
| BBS | 5 | 1 | 15.8 | 1 | 0 |
| BBS | 9 | 7 | 15 | 1 | 0 |
| BBS | 9 | 7 | 16.3 | 0 | 0 |
| BBS | 9 | 7 | 13.3 | 0 | 1 |
| BBS | 10 | 7 | 10.8 | 0 | 1 |
| BBS | 10 | 7 | 14.4 | 1 | 0 |
| BBS | 11 | 7 | 14.4 | 1 | 1 |
| BBS | 11 | 7 | 13.6 | 1 | 0 |
| ABN | 1 | 7 | 14.6 | 0 | 0 |
| ABN | 1 | 2 | 9.8 | 0 | 1 |
| ABN | 1 | 7 | 16.2 | 0 | 0 |
| ABN | 1 | 2 | 12.8 | 0 | 0 |
| ABN | 1 | 7 | 16 | 0 | 1 |
| ABN | 2 | 7 | 18.9 | 0 | 1 |
| ABN | 2 | 2 | 17.6 | 1 | 1 |
| ABN | 3 | 7 | 19.5 | 1 | 1 |
| ABN | 3 | 2 | 16.9 | 1 | 0 |
| ABN | 3 | 7 | 16.3 | 0 | 1 |
| ABN | 3 | 7 | 15.8 | 1 | 0 |
| ABN | 3 | 7 | 17.1 | 0 | 1 |
| ABN | 3 | 2 | 15.8 | 0 | 0 |
| ABN | 3 | 7 | 16 | 1 | 0 |
| ABN | 3 | 2 | 27.4 | 0 | 1 |
| ABN | 4 | 2 | 14.2 | 0 | 0 |
| ABN | 4 | 7 | 18.1 | 0 | 0 |
| ABN | 4 | 2 | 15.2 | 0 | 0 |
| ABN | 4 | 7 | 19.8 | 0 | 1 |
| ABN | 4 | 7 | 15.5 | 1 | 0 |
| ABN | 4 | 2 | 16.6 | 1 | 0 |
| ABN | 5 | 7 | 16.3 | 1 | 0 |
| ABN | 5 | 7 | 23.8 | 0 | 1 |
| ABN | 5 | 2 | 16.8 | 1 | 0 |
| ABN | 9 | 7 | 15.4 | 0 | 1 |
| ABN | 9 | 2 | 14.7 | 0 | 0 |
| ABN | 9 | 7 | 15.5 | 0 | 0 |
| ABN | 9 | 2 | 14.7 | 1 | 0 |
| ABN | 10 | 7 | 15.9 | 1 | 0 |
| ABN | 10 | 7 | 13.8 | 1 | 0 |
| ABN | 10 | 2 | 14.9 | 0 | 1 |
| ABN | 11 | 7 | 12.9 | 0 | 1 |
| ABN | 11 | 2 | 15.4 | 1 | 0 |
| ABN | 11 | 7 | 14.5 | 0 | 2 |
| ABN | 12 | 7 | 12.6 | 0 | 2 |
| ABN | 12 | 2 | 11.8 | 0 | 0 |
| ABN | 12 | 2 | 12.8 | 0 | 0 |
| ABN | 12 | 7 | 16.8 | 0 | 1 |
| CBC | 1 | 7 | 14.7 | 0 | 1 |
| CBC | 1 | 1 | 11.3 | 1 | 0 |
| CBC | 2 | 1 | 13.5 | 0 | 1 |
| CBC | 2 | 7 | 12.9 | 1 | 0 |
| CBC | 3 | 1 | 13.2 | 1 | 0 |
| CBC | 3 | 7 | 12.8 | 1 | 0 |
| CBC | 4 | 1 | 13.2 | 1 | 1 |
| CBC | 4 | 7 | 13.5 | 0 | 1 |
| CBC | 5 | 1 | 17.5 | 1 | 0 |
| CBC | 5 | 7 | 11.6 | 0 | 0 |
| CBC | 5 | 7 | 12.1 | 0 | 0 |
| CBC | 6 | 1 | 15.6 | 1 | 0 |
| CBC | 6 | 7 | 12.6 | 0 | 1 |
| CBC | 6 | 1 | 11.8 | 0 | 0 |
| CBC | 7 | 7 | 12.3 | 0 | 0 |
| CBC | 7 | 1 | 14.2 | 1 | 1 |
| CBC | 8 | 7 | 11.6 | 0 | 0 |
| CBC | 8 | 1 | 13.3 | 1 | 0 |
| CBC | 8 | 1 | 13.6 | 1 | 0 |
| CBC | 9 | 1 | 12.4 | 0 | 1 |
| CBC | 9 | 1 | 13.8 | 1 | 0 |
| CBC | 9 | 7 | 11.9 | 0 | 0 |
| CBC | 10 | 1 | 14.6 | 0 | 0 |
| CBC | 10 | 1 | 15.8 | 1 | 1 |
| CBC | 10 | 1 | 15.4 | 1 | 1 |
| CBC | 11 | 1 | 13.1 | 0 | 1 |
| CBC | 11 | 7 | 12.8 | 0 | 0 |
| CBC | 12 | 1 | 15.1 | 0 | 0 |
| CBC | 12 | 1 | 12.4 | 0 | 1 |
| 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
Probability and Random Processes With Applications to Signal Processing and Communications
Authors: Scott Miller, Donald Childers
2nd edition
123869811, 978-0121726515, 121726517, 978-0130200716, 978-0123869814
