GB 513 Course Great Wisdom / tutorialrank.com GB 513 Course Great Wisdom / tutorialrank.com | Page 19

2. Charting:
Create a line graph of the monthly average ratings for CBC for
the year. Note that there are multiple ratings data for the
months; you will need to calculate an average for each
month and then plot the averages. After you create the
graph, fit a linear trend line, displaying the formula and the rsquared. Explain to the executives if you can use this time
series data to forecast the ratings of upcoming months. How
accurate can you expect this forecast to be?
3. Hypothesistesting:
Should the CBC hire stars for their movies? To answer this
question, run a hypothesis test to see if there is a significant
difference between the ratings of movies with stars vs.
movies without stars. Use the data for CBC movies only. Use
95% confidence. Explain your answer- do not simply say yes
or no without referring to the relevant figures.
4. Regression:
CBC Management has several questions: Which has more
impact on a movie’s rating: that it is fact based or that it has
one star? How much does each of these factors change the
ratings? Do you expect a fact based movie that does not have
any stars to get better ratings than a fiction movie with one
star? Run a multiple regression where the dependent
variable is ratings and the independent variables are star and