Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
' H I) I) I: U - 1 Smaller Ships Larger Ships Interval Estimation for the Difference Between Formulas 2 94.5 80.9 Two Population MearlsI Sigma Known Case 3 84.11 85.67 4 87.48 83.52 Sample 1 Size 5 83.06 8879 Sample 2 Size 6 91.9 79.2 7 72.96 82.81 Sample 1 Mean 8 77.41 80.93 Sample 2 Mean 9 85.78 74.96 Point Estimate for Mean Difference [2 decimals) 10 80.77 91.72 11 89.9 79.5 Population 1 Standard Deviation 5.663925 12 85.45 82.73 Population 2 Standard Deviation 5.099805 I 86.53 81.63 14 80.84 89.23 Population 1 Variance 15 8814 77.82 Population 2 Variance 16 86.2 90.5 n m 85.\" Madam : 18 89.38 83.74 19 7557 7682 wical (2 decimals) :: 20 76.55 7663 21 7533 81-2 Marsinoferrorwecimalsl :: 22 85.61 82.33 23 90.97 74.93 C.l. Lower Limit [2 decimals) 24 89.18 78.63 C.l. Upper Limit [2 decimals) 25 88.05 74.91 26 93.81 83.08 27 83.33 74.95 28 89.84 81.86 29 81.78 81.36 30 86.21 87.81 31 91.4 85.18 32 72.74 86.88 33 90.37 74.85 34 76.99 75.21 35 79.67 81.72 36 84.61 82.75 37 84.8 86.59 a 85.92 75.24 : I' b Shea" l m 13 86.53 81.63 #N/A 14 80.84 89.23 Population 1 Variance #N/A 15 88.14 77.82 Population 2 Variance 16 86.2 90.5 #N/A 17 83.37 85.14 Standard Error 18 89.38 83.74 #N/A 19 75.57 76.82 z-critical (2 decimals) 20 76.55 76.63 Margin of error (2 decimals) #N/A 21 75.33 81.2 22 85.61 82.33 90.97 74.93 C.I. Lower Limit (2 decimals) #N/A 23 #N/A 24 89.18 78.63 C.I. Upper Limit (2 decimals) 25 88.05 74.91 26 93.81 83.08 27 83.33 74.95 28 89.84 81.86 29 81.78 81.36 30 86.21 87.81 31 91.4 85.18 32 72.74 86.88 33 90.37 74.85 34 76.99 75.21 35 79.67 81.72 36 84.61 82.75 37 84.8 86.59 38 85.92 75.24 39 86.33 40 80.44 41 83.87 42 81.54 43 85.7 44 78.81 45 79.53 46 47 48 49Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started