Statistics questions

adebola

Main

Home >Homework Answsers >Science homework help

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

1. Answer the following questions:

a. What is the average rating for all CBC movies? How about ABN movies and BBS movies

b. Include a table that shows the average and the other descriptive statistics ( using the data analysis toolpack in excel) for the ratings of the three networks (one column for each network). Explain what you learn from each of the metrics in the table.

c. Comment on which network is doing best.