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

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1 20.8 1 20.4 1 25.1 1 27.4 1 15.4 1 15.3 1 13.9 2 16.3...
1 20.8 1 20.4 1 25.1 1 27.4 1 15.4 1 15.3 1 13.9 2 16.3 2 14.5 2 10.4 2 12.2 2 12.5 2 9.5 2 15.3 3 16.8 3 20.9 3 28.4 3 22.5 3 17.5 3 14.9 3 22.4 3 17.5 3 25.4 3 22.4 4 16.7 4 14.5 4 13.7 4 15.4 4 12.4 4 16 4 7.5 4 12.9 4 18.3 10. What was the margin of error for the confidence interval for gasoline mileage...
Dep Delay Arr Delay q1 -13 -9 q3 1 3 IQR 14 12 stdev 9.211846 9.660933...
Dep Delay Arr Delay q1 -13 -9 q3 1 3 IQR 14 12 stdev 9.211846 9.660933 negative 291 zero 39 positive 170 total (should be 500) 500 all data is for arrival data. please help me explain these can someone help me answer these questions and tell me how to put them in excel.thanx in advance 1.    Define a random variable (X) so that your chosen data set represents values of X. 2.    Is your chosen random variable discrete or...
I need a breakdown to perform in excel for numbers 7,8,9. I am unsure of how...
I need a breakdown to perform in excel for numbers 7,8,9. I am unsure of how I calculate the times. heres the data set and the questions. Calculate the probability that a flight will depart early or on time. Calculate the probability that a flight will arrive late. Calculate the probability that a flight departs late or arrives early. DEP_Delay ARR_Delay -4 0 -3 -3 0 -5 -7 -1 8 3 -1 -5 3 8 11 6 -6 0 -5...
Test the hypothesis that most cereals have nine or less grams of SUGAR per serving. Use...
Test the hypothesis that most cereals have nine or less grams of SUGAR per serving. Use the attached cereal sample and a significance level of .05 Sugars 6 8 5 0 8 10 14 8 6 5 12 1 9 7 13 3 2 12 13 7 0 3 10 5 13 11 7 10 12 11 10 6 9 3 13 7 10 14 0 0
A professional golfer wondered if she should switch to a new line of golf clubs that...
A professional golfer wondered if she should switch to a new line of golf clubs that are supposed to put a spin on the golf ball that reduces the variance in the ball's flight. She obtained a new set of the clubs and paired off each new club with one of her old clubs. Then she hit golf balls with the pairs of clubs in 30 situations that would be appropriate to the type of club and measured how far...
Find variance of the following stocks A,B and C: Stock A B C 1 3 19...
Find variance of the following stocks A,B and C: Stock A B C 1 3 19 -2 2 5 17 4 3 7 15 0 4 9 13 8 5 11 11 12 6 13 9 14 8 15 7 -8 9 17 5 16 10 19 3 20
Exhibit 5-3 Use the following information about demand and supply schedules to answer the question. Price...
Exhibit 5-3 Use the following information about demand and supply schedules to answer the question. Price D1 D2 S1 S2 $12 5 9 19 14 $10 8 12 17 12 $ 8 11 15 15 10 $ 6 13 18 13 8 $ 4 16 21 11 6 $ 2 18 24 9 4 Refer to Exhibit 5-3. If D 2 and S 1 represent the demand and supply schedules in a particular market, the equilibrium price and quantity are...
Using the methods in Section 11.1, test the hypothesis (α = 0.05) that the population proportions...
Using the methods in Section 11.1, test the hypothesis (α = 0.05) that the population proportions of red and brown are equal (pred = pbrown). You are testing if their proportions are equal to one another. NOTE: These are NOT independent samples, but we will use this approach anyway to practice the method. This also means that n1 and n2 will both be the total number of candies in all the bags. The “x” values for red and brown are...
# of text messages sent yesterday 3 8 3 18 2 1 8 1 6 13...
# of text messages sent yesterday 3 8 3 18 2 1 8 1 6 13 15 14 13 9 20 12 5 9 18 18 13 2 7 6 0 0 11 12 4 13 1 19 4 12 4 11 8 18 1 15 12 6 6 12 19 12 20 12 8 12 Test the following claim: 70% of individuals that send text messages send less than 10 messages per day, α = 0.01
The table below presents three samples of data. If we conduct a hypothesis test for the...
The table below presents three samples of data. If we conduct a hypothesis test for the equality of all three means with the statistical confidence of 90%, what would the value of the Mean Squares Between Groups be? Sample 1 Sample 2 Sample 3 7 11 6 5 8 5 7 11 4 6 7 5 6 13 14 6 13 5 6 12 5 6 11 6 8 8 8 9 7 6 7 6 14 9 7 4...