Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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?

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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.9. Assume that the population standard deviation is 4.59 for ships that carry fewer than...

Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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. Smaller Ships Larger Ships 93.9 81.4 84.11 85.67...

Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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 36 ships that carry fewer than 500 passengers resulted in an average rating of 85.36, and a sample of 44ships that carry 500 or more passengers provided an average rating of 81.4 . Assume that the population standard deviation is for 4.52 ships that carry fewer than 500 passengers...

Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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.40. Assume that the population standard deviation is 4.55 for ships that carry fewer than 500...

Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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.40. Assume that the population standard deviation is 4.55 for ships that carry fewer than 500...

Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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.40. Assume that the population standard deviation is 4.55 for ships that carry fewer than 500...

Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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). Smaller Ships 94.8 84.11 87.48 83.06 92.1 72.96 77.41 85.78 80.77 89.7 85.45 86.53 80.84 88.14...

Condé Nast Traveler conducts an annual survey in which readers rate their favorite cruise ship. All...

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 36 ships that carry fewer than 500 passengers resulted in an average rating of 85.33 , and a sample of 43 ships that carry 500 or more passengers provided an average rating of 81.3. Assume that the population standard deviation is 4.55 for ships that carry fewer than...

A travel magazine conducts an annual survey where readers rate their favorite cruise ship. Ships are...

A travel magazine conducts an annual survey where readers rate their favorite cruise ship. Ships are rated on a 10 point scale, with higher values indicating better service. A sample of 55 ships that carry fewer than 500 passengers resulted in a average rating of 6.36 with standard deviation 0.63. A sample of 25 ships that carry more than 500 passengers resulted in an average rating of 6.12 with standard deviation 0.78. Give a 95% confidence interval of the difference...

The Condé Nast Traveler Gold List for 2012 provided ratings for the top 20 small cruise...

The Condé Nast Traveler Gold List for 2012 provided ratings for the top 20 small cruise ships (Condé Nast Traveler website, March 1, 2012). The data shown below are the scores each ship received based upon the results from Condé Nast Traveler's annual Readers' Choice Survey. Each score represents the percentage of respondents who rated a ship as excellent or very good on several criteria, including Itineraries/Schedule, Shore Excursions, and Food/Dining. An overall score was also reported and used to...

Subjects