Homework SoursePlease use excel to answer the question The executives at CB
Please use excel to answer the question.
The executives at CBC want to see how they are doing in ratings against the other networks and how the ratings will continue to change in the upcoming months. They also want to know if hiring stars makes a difference and the impact of fact based programming compared to hiring stars. The audience is the management of CBC:
Hypothesis testing :
Should the CBC hire stars for their movies? To answer this question, run a hypothesis test to
see if there is a significant difference between the ratings of movies with stars vs. movies
without stars. Use the data for CBC movies only. Use 95% confidence. Explain your answer-
do not simply say yes or no without referring to the relevant figures.
| 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 |
Solution
Let group 1 = those with stars
group 2 = those without stars.
Formulating the null and alternative hypotheses,
Ho: u1 - u2 <= 0
Ha: u1 - u2 > 0
At level of significance = 0.05
As we can see, this is a right tailed test.
Calculating the means of each group,
X1 = 13.85714286
X2 = 13.21304348
Calculating the standard deviations of each group,
s1 = 2.645031281
s2 = 2.370328774
Thus, the standard error of their difference is, by using sD = sqrt(s1^2/n1 + s2^2/n2):
n1 = sample size of group 1 = 7
n2 = sample size of group 2 = 23
Thus, df = n1 + n2 - 2 = 28
Also, sD = 1.115229387
Thus, the t statistic will be
t = [X1 - X2 - uD]/sD = 0.577548786
where uD = hypothesized difference = 0
Now, the critical value for t is
tcrit = + 1.701130934
Thus, comparing t and tcrit, we decide to WE FAIL TO REJECT THE NULL HYPOTHESIS.
Also, using p values,
p = 0.284092229
Comparing this to the significance level, WE FAIL TO REJECT THE NULL HYPOTHESIS.
Thus, there is no significant evidence at 0.05 level that there is a difference between the ratings of the shows with stars and those without. [conclusion]
