After you create the graph fit a linear trend line

Reference no: EM13638716

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

Reference no: EM13638716

Questions Cloud

Using the properties of water for the drink determine the : during a picnic on a hot summer day all the cold drinks disappeared quickly and the only available drinks were those at

A curve of radius 139 m is banked at an angle of 9deg an : a curve of radius 139 m is banked at an angle of 9deg. an 758-kg car negotiates the curve at 77 kmh without skidding.

Two aqueous solutions of sucrose are mixed one solution is : two aqueous solutions of sucrose are mixed. one solution is 0.1488 and has 1.018 the other is 11.50 by mass and has

A medical inspector wants to estimate the overall average : a medical inspector wants to estimate the overall average monthly occupancy rates of the cancer wards in 80 different

After you create the graph fit a linear trend line : create a line graph please include graph in excel format of the monthly average ratings for cbc for the year. note that

The frequency of note a is 4400 hz the frequency of note c : the lowest note on a piano is a four octaves below the a given in the table. the highest note on a piano is c four

Which would you expect to be more soluable in water mtbe : which would you expect to be more soluable in water mtbe methyl tert-butyl ether or other components of gasoline such

If the atmospheric pressure is po find the pressure a0 at : a liquid of density r is filled in a beaker of cross-area s to a height h and then a cylinder of mass m and

What chemical reaction could you perform to promote the : what chemical reaction could you perform to promote the aqueous solubility of hexyl amine? write an equation why is the

User Account

All Pages