What is the average rating for all CBC, ABN and BBS movies? Explain how to get the averages for each rating. Provide a bar chart that compares these averages.

1. 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). Explain how to get to the answer.
2. Comment on how the networks are performing, by comparing and interpreting the metrics in the descriptive statistics table. The analysis must extend beyond simply comparing the average ratings for each network.

Tables:

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

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

Observation	Network	Month	Day	Rating	Fact	Stars
1	ABN	1	7	14.6	0	0
2	ABN	1	2	10.8	0	1
3	ABN	1	7	16.2	0	0
4	ABN	1	2	12.8	0	0
5	ABN	1	7	16	0	1
6	ABN	2	7	18.9	0	1
7	ABN	2	2	17.6	1	1
8	ABN	3	7	19.5	1	1
9	ABN	3	2	16.9	1	0
10	ABN	3	7	16.3	0	1
11	ABN	3	7	15.8	1	0
12	ABN	3	7	17.1	0	1
13	ABN	3	2	15.8	0	0
14	ABN	3	7	16	1	0
15	ABN	3	2	11.7	0	1
16	ABN	4	2	14.2	0	0
17	ABN	4	7	18.1	0	0
18	ABN	4	2	15.2	0	0
19	ABN	4	7	13.3	0	1
20	ABN	4	7	15.5	1	0
21	ABN	4	2	16.6	1	0
22	ABN	5	7	16.3	1	0
23	ABN	5	7	16.5	0	1
24	ABN	5	2	16.8	1	0
25	ABN	9	7	15.4	0	1
26	ABN	9	2	14.7	0	0
27	ABN	9	7	15.5	0	0
28	ABN	9	2	14.7	1	0
29	ABN	10	7	15.9	1	0
30	ABN	10	7	13.8	1	0
31	ABN	10	2	14.9	0	1
32	ABN	11	7	12.9	0	1
33	ABN	11	2	15.4	1	0
34	ABN	11	7	14.5	0	2
35	ABN	12	7	12.6	0	2
36	ABN	12	2	11.8	0	0
37	ABN	12	2	12.8	0	0
38	ABN	12	7	16.8	0	1