1. Answer the following questions:
   1. What is the average rating for all CBC movies? How about ABN movies and BBS movies? Provide a bar chart that compares these averages.
   2. Include a table that shows the descriptive statistics using the data analysis tool pack in Excel for the ratings of the three networks (one column for each network).
   3. 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. a scatter 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?
3. The executives wish to know if they should hire stars for their programs. To answer this question, run a hypothesis test to see if the ratings of shows with stars are higher compared to those without stars. Use the data for CBC movies only. Use 95% confidence.
4. Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact. Use data from CBC only. CBC Management has several questions:
   1. Executives wish to know how much being fact-based or having one star contributes to a movies rating. What can you tell them about this?
   2. Are either, both, or neither of the independent variables significantly related to the ratings at 95% confidence? Justify your answers referring to the relevant figures.
   3. How well does this regression analysis explain the ratings? Should the executives count on the results from this analysis? Justify your answers referring to the relevant figures.

A B C D E F G H 1 Observation Network Month Day Rating Fact Stars 1 BBS 1 15.6 W 2 BBS 10.8 3 BBS 18.4 4 BBS 16.8 5 BBS 14.3 6 BBS 17.1 7 BBS 22.6 8 BBS 16.2 10 9 BBS 17.5 11 10 BBS 13.5 11 BBS 18.7 13 12 BBS 9.6 14 13 BBS 15.8 15 14 BBS 15 16 15 BBS 16.3 17 16 BBS 13.3 18 17 BBS 10 19.3 19 18 BBS 10 14.4 20 19 BBS 11 18.1 O O O H O O H O H O P P P P O O P O O P O P P O O O P O P P O O P P P P OP O O O O H O O P O P P P O O O O O O P P P O O O P P O O O O PO PP PO PO 21 20 BBS 11 19.8 22 21 ABN 1 14.6 23 22 ABN 1 9.8 24 23 ABN 1 16.2 25 24 ABN 12.8 26 25 ABN 16 27 26 ABN 18.9 28 27 ABN 17.6 29 28 ABN 19.5 30 29 ABN 16.9 31 30 ABN 16.3 32 31 ABN 15.8 33 32 ABN 17.1 34 33 ABN 15.8 35 34 ABN 16 36 35 ABN 27.4 37 36 ABN 14.2 38 37 ABN 18.1 38 ABN 4 15.239 38 ABN 4 15.2 40 39 ABN 19.8 41 40 ABN 15.5 42 41 ABN 16.6 43 42 ABN 16.3 44 43 ABN 23.8 45 44 ABN 16.8 46 45 ABN 15.4 47 46 ABN 14.7 48 47 ABN 15.5 49 48 ABN 14.7 50 49 ABN 10 15.9 51 50 ABN 10 13.8 52 51 ABN 10 14.9 53 52 ABN 11 12.9 54 53 ABN 11 15.4 55 54 ABN 11 14.5 56 55 ABN 12 12.6 57 56 ABN 12 11.8 HOO HOO O O P P O O O P O P P O O N N O P P O O O O O PO PO O O KO H OOOH OOH O P P P P O P O O O O O O P O O P P P O O O P O P P P O O 58 57 ABN 12 12.8 59 58 ABN 12 16.8 60 59 CBC 1 14.7 61 60 CBC 11.3 62 61 CBC 13.5 63 62 CBC 12.9 64 63 CBC 13.2 65 64 CBC 12.8 66 65 CBC 13.2 67 66 CBC 13.5 68 67 CBC 17.5 69 68 CBC 11.6 70 69 CBC 12.1 71 70 CBC 15.6 72 71 CBC 12.6 73 72 CBC 11.8 74 73 CBC 12.3 75 74 CBC 7 14.2\f