GB 513 RANK Imagine Your Future /gb513rank.com GB 513 RANK Imagine Your Future /gb513rank.com | Page 14

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 r-squared. 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 fact. Use data from all
networks, not just CBC movies. How well does this regression
analysis explain the ratings? Justify your answers based on the
results.
=============================================
==