You will be analyzing the “Colonial Broadcasting” case included with the course pack that you bought at the beginning of the course . Begin by reading the description in the case. Then, answer the questions listed below, NOT the questions listed in the case. Ignore everything in the case document after the end of page 4.
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.
Remember that your audience is the management of CBC. Therefore, make sure your presentation is professional. Once you present your results, you need to justify and explain your findings with properly stated conclusions.
1) Answer the following questions:
a) What is the average rating for all CBC movies? How about ABN movies and BBS movies? Provide a bar chart that compares these averages.
b) Include a table that shows the descriptive statistics using the data analysis tool pack in Excel for the ratings of the three networks .
c) Comment on how the networks are performing, by comparing and interpreting the metrics in the descriptive statistics table. Your analysis must extend beyond simply comparing the average ratings for each network.
2) 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 first, and then plot the averages. After you create the graph, fit a linear trend line and a 2nd order polynomial 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. Which forecasting method is better? How accurate can you expect this forecast to be?