In: Statistics and Probability
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 37 ships that carry fewer than 500 passengers resulted in an average rating of 85.36, and a sample of 44 ships that carry 500 or more passengers provided an average rating of 81.4. Assume that the population standard deviation is 4.55 for ships that carry fewer than 500 passengers and 3.97 for ships that carry 500 or more passengers. Round your all answers to two decimal places.
*Please show using excel*
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?