Forecast the ratings of upcoming months

Question

Create a line graph (please include graph in excel format) 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, 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. How accurate can you expect this forecast to be?

Please provide (email) excel sheet to include graphs and tables.

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	14	1	1
28	ABN	3	7	19.5	1	1
29	ABN	3	2	14.7	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	11.5	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	11.2	0	0
38	ABN	4	2	10.9	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	12.3	0	1
44	ABN	5	2	13.3	1	0
45	ABN	9	7	15.4	0	1
46	ABN	9	2	10.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	10	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	0	1
60	CBC	1	1	11.3	1	0
61	CBC	2	1	13.6	0	0
62	CBC	2	7	12.9	1	0
63	CBC	3	1	13.2	1	0
64	CBC	3	7	16	1	0
65	CBC	4	1	14.6	1	1
66	CBC	4	7	16.6	0	1
67	CBC	5	1	17.5	1	0
68	CBC	5	7	11.6	0	0
69	CBC	5	7	8.9	0	0
70	CBC	6	1	15.6	0	0
71	CBC	6	7	9.2	0	1
72	CBC	6	1	11.8	0	0
73	CBC	7	7	11	0	0
74	CBC	7	1	9.5	1	0
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	0
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	12.8	0	0
85	CBC	11	7	12.8	0	0
86	CBC	12	1	15.1	0	0
87	CBC	12	1	11.4	0	1
88	CBC	12	1	19.1	1	0