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
Answer #1
Not the answer you're looking for?
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...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 12 minutes ago
asked 22 minutes ago
asked 22 minutes ago
asked 27 minutes ago
asked 31 minutes ago
asked 33 minutes ago
asked 51 minutes ago
asked 54 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago