You will be analyzing the "Colonial Broadcasting" case in the course pack that you bought at the beginning of the course

Subject:BusinessPrice:4.89 Bought20

Share With

You will be analyzing the "Colonial Broadcasting" case in 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 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 and provides sufficient explanation.

1.    Answer the following questions:

 

a.   What is the average rating for all CBC movies? How about ABN movies and BBS movies?

b.   Include a table that shows the average and the other descriptive statistics (using the data analysis tool pack in Excel) for the ratings of the three networks (one column for each network). Explain what you learn from each of the metrics in the table.

c.    Comment how the networks are performing, using the metrics in the table. Your analysis should extend beyond simply comparing the average ratings for each network.