View the step-by-step solution to:

Question

# 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.

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.

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

my recommendation is that CBC should not hire stars... View the full answer

XI H .
Book1 - Microsoft Excel
-
X
ILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
La From Access
Connections
24
x Clear
Data Analysis
Ce From Web
Properties
19 Reapply
Group Ungroup...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents