Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All ships are rated on a 100-point scale, with higher values indicating better service. A sample of ships that carry fewer than 500 passengers and a sample of ships that carry 500 or more passengers is provided in the Microsoft Excel Online file below (Condé Nast ebruary 2008). tound your all answers to two decimal places. Open spreadsheet a. What is the point estimate of the difference between the population mean rating for ships that carry fewer than 500 passengers and the population mean rating for ships that carry 500 or more passengers? b. At 95% confidence, what is the margin of error? c. What is a 95% confidence interval estimate of the difference between the population mean ratings for the two sizes of ships?
Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All ships are rated on a 100-point scale, with higher values indicating better service. A sample of ships that carry fewer than 500 passengers and a sample of ships that carry 500 or more passengers is provided in the Microsoft Excel Online file below (Condé Nast ebruary 2008). tound your all answers to two decimal places. Open spreadsheet a. What is the point estimate of the difference between the population mean rating for ships that carry fewer than 500 passengers and the population mean rating for ships that carry 500 or more passengers? b. At 95% confidence, what is the margin of error? c. What is a 95% confidence interval estimate of the difference between the population mean ratings for the two sizes of ships?
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.2: Representing Data
Problem 22PFA
Related questions
Question
100%
Transcribed Image Text:A
B
1 Smaller Ships Larger Ships
93.4
81.4
84.11
85.67
87.48
83.52
88.79
79.5
82.81
80.93
74.96
91.72
2
34567 ES
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
83.06
91.3
72.96
77.41
85.78
80.77
89.5
85.45
86.53
80.84
88.14
87.3
83.37
89.38
75.57
76.55
75.33
85.61
90.97
89.18
88.05
93.81
83.33
89.84
81.78
86.21
91.4
72.74
90.37
76.99
79.67
84.61
84.8
85.92
79.9
82.73
81.63
89.23
77.82
90.6
85.14
83.74
76.82
76.63
81.2
82.33
74.93
78.63
74.91
83.08
74.95
81.86
81.36
87.81
85.18
86.88
74.85
75.21
81.72
82.75
86.59
75.24
86.33
80.44
83.87
81.54
85.7
78.81
79.53
C
D
Interval Estimation for the Difference Between
Two Population Means, Sigma Known Case
Sample 1 Size
Sample 2 Size
Sample 1 Mean
Sample 2 Mean
Point Estimate for Mean Difference (2 decimals)
Population 1 Standard Deviation
Population 2 Standard Deviation
Population 1 Variance
Population 2 Variance
Standard Error
z-critical (2 decimals)
Margin of error (2 decimals)
C.I. Lower Limit (2 decimals)
C.I. Upper Limit (2 decimals)
E
5.595924
5.019413
F
G
Formulas
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
H
Transcribed Image Text:Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All ships are rated on a 100-point scale, with higher values indicating better service. A sample of ships that carry fewer than 500 passengers and a sample of ships that carry 500 or more passengers is provided in the Microsoft Excel Online file below (Condé Nast Traveler,
February 2008).
Round your all answers to two decimal places.
Open spreadsheet
a. What is the point estimate of the difference between the population mean rating for ships that carry fewer than 500 passengers and the population mean rating for ships that carry 500 or more passengers?
b. At 95% confidence, what is the margin of error?
c. What is a 95% confidence interval estimate of the difference between the population mean ratings for the two sizes of ships?
to
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Step 1: Given Information:
VIEWStep 2: Find the point estimate of the difference between the population mean ratings for two ships:
VIEWStep 3: At 95% confidence, find the margin of error:
VIEWStep 4: Find the 95% confidence interval estimate of the difference between means of two ships:
VIEWSolution
VIEW
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 10 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL