|
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.
