How well does this regression analysis explain the ratings? Should the executives count on the results from this analysis?
- 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:
- 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?
- 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.
- 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.
Directions for Submitting your Assignment:
For this project, you will prepare a PowerPoint presentation to present your findings. The first slide after the title slide should be an “Executive Summary.” It should contain a very brief overview of all the answers. Your final slide should include “conclusions” and provide an overall assessment of the analysis.
Make sure you also submit the Excel file to show your work for Part 2. You will receive a 100-point reduction if you fail to include the Excel file showing your work.
Place all calculations for each of the questions on a separate worksheet. Then, using the results of your work from Excel, prepare PowerPoint slides to answer the questions in a presentation format. All relevant content should be on the slides; do not use the notes section or leave information in the Excel file. The executives reviewing the presentation should not need to switch to another document to see the required information.
The data you need is provided to you in the Excel file in Course Documents. Make sure to use that file. Do not type anything in manually or download anything from the Internet.
