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. You will create a PowerPoint presentation to answer the questions below. Remember that your audience is the management of CBC. Therefore, make sure your presentation is professional and provides sufficient explanation. 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 toolpack 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 on which network is doing best. Observatio n 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Networ k BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS BBS ABN ABN ABN ABN ABN Month 1 1 1 1 2 2 3 3 4 5 5 5 5 9 9 9 10 10 11 11 1 1 1 1 1 Day 1 7 7 1 1 1 1 7 7 1 7 1 1 7 7 7 7 7 7 7 7 2 7 2 7 Rating 15.6 10.8 14.1 16.8 14.3 17.1 15.8 16.2 12.6 13.5 15.6 12.1 15.8 15 16.3 13.3 10.8 14.4 14.4 13.6 14.6 10.8 16.2 12.8 16 Fact Stars 0 1 0 1 1 1 0 1 0 0 0 0 1 1 0 0 0 1 1 1 0 0 0 0 0 1 0 1 1 1 1 0 0 1 1 0 1 0 0 0 1 1 0 1 0 0 1 0 0 1 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN ABN CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC 2 2 3 3 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 9 9 9 9 10 10 10 11 11 11 12 12 12 12 1 1 2 2 3 3 4 4 5 5 7 2 7 2 7 7 7 2 7 2 2 7 2 7 7 2 7 7 2 7 2 7 2 7 7 2 7 2 7 7 2 2 7 7 1 1 7 1 7 1 7 1 7 18.9 14 19.5 14.7 16.3 15.8 17.1 11.5 16 11.7 14.2 11.2 10.9 13.3 15.5 16.6 16.3 12.3 13.3 15.4 10.7 15.5 14.7 15.9 13.8 10 12.9 15.4 14.5 12.6 11.8 12.8 16.8 14 11.3 13.6 12.9 13.2 12.8 12.4 13.2 17.5 11.6 0 1 1 1 0 1 0 0 1 0 0 0 0 0 1 1 1 0 1 0 0 0 1 1 1 0 0 1 0 0 0 0 0 0 1 0 1 1 1 1 0 1 0 1 1 1 0 1 0 1 0 0 1 0 0 0 1 0 0 0 1 0 1 0 0 0 0 0 1 1 0 2 2 0 0 1 1 0 0 0 0 0 1 1 0 0 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC CBC 5 6 6 6 7 7 8 8 8 9 9 9 10 10 10 11 11 12 12 12 7 1 7 1 7 1 7 1 1 1 1 7 1 1 1 1 7 1 1 1 12.1 15.6 13.4 11.8 12.3 14.2 11.6 13.3 13.6 12.4 13.8 11.9 14.6 15.8 15.4 12.8 12.8 15.1 11.4 19.1 0 0 0 0 0 1 0 1 1 0 1 1 0 1 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 0