a. Create a line graph of the monthly average ratings for CBC for the year. Note that there are multiple ratings data for the months; calculate an average for each month first (show how in excel), and then plot the averages (show how in excel). b. Create the graph, fit a linear trend line and a 2nd order polynomial trend line, displaying the formula and the r-squared. c. Explain if executives can use this time series data to forecast the ratings of upcoming months.

d. Explain which forecasting method is better?

e. Explain how accurate can they expect this forecast to be?

Observation	Network	Month	Day	Rating
1	CBC	1	7	14.7
2	CBC	1	1	11.3
3	CBC	2	1	13.5
4	CBC	2	7	12.9
5	CBC	3	1	13.2
6	CBC	3	7	12.8
7	CBC	4	1	13.2
8	CBC	4	7	13.5
9	CBC	5	1	17.5
10	CBC	5	7	11.6
11	CBC	5	7	12.1
12	CBC	6	1	15.6
13	CBC	6	7	12.6
14	CBC	6	1	11.8
15	CBC	7	7	12.3
16	CBC	7	1	14.2
17	CBC	8	7	11.6
18	CBC	8	1	13.3
19	CBC	8	1	13.6
20	CBC	9	1	12.4
21	CBC	9	1	13.8
22	CBC	9	7	11.9
23	CBC	10	1	14.6
24	CBC	10	1	15.8
25	CBC	10	1	15.4
26	CBC	11	1	13.1
27	CBC	11	7	12.8
28	CBC	12	1	15.1
29	CBC	12	1	12.4
30	CBC	12	1	19.1