question archive 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
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
Subject:StatisticsPrice: Bought3
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.
Observation Network Month Day Rating Fact Stars 1 BBS 1 1 15.6 0 1 2 BBS 1 7 10.8 1 0 3 BBS 1 7 14.1 0 1 4 BBS 1 1 16.8 1 1 5 BBS 2 1 14.3 1 1 6 BBS 2 1 17.1 1 1 7 BBS 3 1 15.8 0 0 8 BBS 3 7 16.2 1 0 9 BBS 4 7 12.6 0 1 10 BBS 5 1 13.5 0 1 11 BBS 5 7 15.6 0 0 12 BBS 5 1 12.1 0 1 13 BBS 5 1 15.8 1 0 14 BBS 9 7 15 1 0 15 BBS 9 7 16.3 0 0 16 BBS 9 7 13.3 0 1 17 BBS 10 7 10.8 0 1 18 BBS 10 7 14.4 1 0 19 BBS 11 7 14.4 1 1 20 BBS 11 7 13.6 1 0 21 ABN 1 7 14.6 0 0 22 ABN 1 2 10.8 0 1 23 ABN 1 7 16.2 0 0 24 ABN 1 2 12.8 0 0 25 ABN 1 7 16 0 1 26 ABN 2 7 18.9 0 1 27 ABN 2 2 17.6 1 1 28 ABN 3 7 19.5 1 1 29 ABN 3 2 16.9 1 0 30 ABN 3 7 16.3 0 1 31 ABN 3 7 15.8 1 0 32 ABN 3 7 17.1 0 1 33 ABN 3 2 15.8 0 0 34 ABN 3 7 16 1 0 35 ABN 3 2 11.7 0 1 36 ABN 4 2 14.2 0 0 37 ABN 4 7 18.1 0 0 38 ABN 4 2 15.2 0 0 39 ABN 4 7 13.3 0 1 40 ABN 4 7 15.5 1 0 41 ABN 4 2 16.6 1 0 42 ABN 5 7 16.3 1 0 43 ABN 5 7 16.5 0 1 44 ABN 5 2 16.8 1 0 45 ABN 9 7 15.4 0 1 46 ABN 9 2 14.7 0 0 47 ABN 9 7 15.5 0 0 48 ABN 9 2 14.7 1 0 49 ABN 10 7 15.9 1 0 50 ABN 10 7 13.8 1 0 51 ABN 10 2 14.9 0 1 52 ABN 11 7 12.9 0 1 53 ABN 11 2 15.4 1 0 54 ABN 11 7 14.5 0 2 55 ABN 12 7 12.6 0 2 56 ABN 12 2 11.8 0 0 57 ABN 12 2 12.8 0 0 58 ABN 12 7 16.8 0 1 59 CBC 1 7 14.7 0 1 60 CBC 1 1 11.3 1 0 61 CBC 2 1 13.5 0 1 62 CBC 2 7 12.9 1 0 63 CBC 3 1 13.2 1 0 64 CBC 3 7 12.8 1 0 65 CBC 4 1 13.2 1 1 66 CBC 4 7 13.5 0 1 67 CBC 5 1 17.5 1 0 68 CBC 5 7 11.6 0 0 69 CBC 5 7 12.1 0 0 70 CBC 6 1 15.6 0 0 71 CBC 6 7 12.6 0 1 72 CBC 6 1 11.8 0 0 73 CBC 7 7 12.3 0 0 74 CBC 7 1 14.2 1 1 75 CBC 8 7 11.6 0 0 76 CBC 8 1 13.3 1 0 77 CBC 8 1 13.6 1 0 78 CBC 9 1 12.4 0 1 79 CBC 9 1 13.8 1 0 80 CBC 9 7 11.9 1 0 81 CBC 10 1 14.6 0 0 82 CBC 10 1 15.8 1 1 83 CBC 10 1 15.4 0 1 84 CBC 11 1 13.1 0 1 85 CBC 11 7 12.8 0 0 86 CBC 12 1 15.1 0 0 87 CBC 12 1 12.4 0 1 88 CBC 12 1 19.1 1 0
