10.1 Excel Activity 1 - Confidence Interval for Difference of Two Means (Structured)
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?
fill in the blank 2
b. At 95% confidence, what is the margin of error?
fill in the blank 3
c. What is a 95% confidence interval estimate of the difference between the population mean ratings for the two sizes of ships?

ANSWER WILL BE SENT BY EMAIL.