Final project for business analytics Colonial Broadcasting case 1. Answer the fo
ID: 3398037 • Letter: F
Question
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 01. 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.
Explanation / Answer
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
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.