Question

# 3. Should the CBC hire stars for their movies? To answer this question, run a hypothesis...

3. 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 versus movies without stars. Use the data for CBC movies only. Use 95% confidence. Answer the following: a. What are the null and alternative hypotheses (state in full sentences)? b. Run the test using Excel and include the output table. Use a t-test assuming equal variances. c. What is your recommendation to the executives? Justify your answer 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 17.6 1 1 28 ABN 3 7 19.5 1 1 29 ABN 3 2 16.9 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 15.8 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 18.1 0 0 38 ABN 4 2 15.2 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 16.5 0 1 44 ABN 5 2 16.8 1 0 45 ABN 9 7 15.4 0 1 46 ABN 9 2 14.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 14.9 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 12.4 0 1 62 CBC 2 7 12.9 1 0 63 CBC 3 1 13.2 1 0 64 CBC 3 7 12.8 1 0 65 CBC 4 1 12.4 1 1 66 CBC 4 7 13.2 0 1 67 CBC 5 1 17.5 1 0 68 CBC 5 7 11.6 0 0 69 CBC 5 7 12.1 0 0 70 CBC 6 1 15.6 0 0 71 CBC 6 7 12.1 0 1 72 CBC 6 1 11.8 0 0 73 CBC 7 7 12.3 0 0 74 CBC 7 1 14.2 1 1 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 1 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 1 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

#### Earn Coins

Coins can be redeemed for fabulous gifts.