Homework SourseFinal project for business analytics Colonial Broadcasting c
Final project for business analytics Colonial Broadcasting case
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.
| 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. |
Solution
Rating
Mean
13.9920
Standard Error
0.2417
Median
14.05
Mode
15.8
Standard Deviation
2.2673
Sample Variance
5.1405
Kurtosis
-0.3644
Skewness
-0.0158
Range
10.6
Minimum
8.9
Maximum
19.5
Sum
1231.3
Count
88
Average for all 88 movies =13.992
a. What is the average rating for all CBC movies? How about ABN movies and BBS
movies?
average rating for all CBC movies =13.3633
average rating for all ABN movies =14.2711
average rating for all BBS movies = 14.405
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.
BBS
ABN
CBC
Mean
14.405
14.27105
13.36333
Standard Error
0.4113
0.3742
0.4392
Median
14.4
14.55
13.25
Mode
15.6
12.8
13.6
Standard Deviation
1.8392
2.3070
2.4055
Sample Variance
3.3826
5.3221
5.7865
Kurtosis
-0.3829
-0.4950
0.0080
Skewness
-0.5595
0.0776
0.2329
Range
6.3
9.5
10.2
Minimum
10.8
10
8.9
Maximum
17.1
19.5
19.1
Sum
288.1
542.3
400.9
Count
20
38
30
There are 20 observations in BBS while 38 in ABN and 30 in CBC.
The average rating for CBC is low(mean =13.36) compared to others.
The median rating for CBC is low(median =13.25) compared to others.
Variation in BBS is small (SD=1.839) and in CBC is large(SD=2.4055).
c. Comment on which network is doing best.
BBS network is doing best because it’s rating for movies is 14.405 which is larger than others.
| Rating | |
| Mean | 13.9920 |
| Standard Error | 0.2417 |
| Median | 14.05 |
| Mode | 15.8 |
| Standard Deviation | 2.2673 |
| Sample Variance | 5.1405 |
| Kurtosis | -0.3644 |
| Skewness | -0.0158 |
| Range | 10.6 |
| Minimum | 8.9 |
| Maximum | 19.5 |
| Sum | 1231.3 |
| Count | 88 |
