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 |