AB1 Smaller Ships Larger Ships93.481.484.1185.6787.4883.5288.7979.582.8180.9374.9691.72234567 ES89101112131415161718192021222324252627282930313233343536373839404142434445464783.0691.372.9677.4185.7880.7789.585.4586.5380.8488.1487.383.3789.3875.5776.5575.3385.6190.9789.1888.0593.8183.3389.8481.7886.2191.472.7490.3776.9979.6784.6184.885.9279.982.7381.6389.2377.8290.685.1483.7476.8276.6381.282.3374.9378.6374.9183.0874.9581.8681.3687.8185.1886.8874.8575.2181.7282.7586.5975.2486.3380.4483.8781.5485.778.8179.53CDInterval Estimation for the Difference BetweenTwo Population Means, Sigma Known CaseSample 1 SizeSample 2 SizeSample 1 MeanSample 2 MeanPoint Estimate for Mean Difference (2 decimals)Population 1 Standard DeviationPopulation 2 Standard DeviationPopulation 1 VariancePopulation 2 VarianceStandard Errorz-critical (2 decimals)Margin of error (2 decimals)C.I. Lower Limit (2 decimals)C.I. Upper Limit (2 decimals)E5.5959245.019413FGFormulas#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/AH 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 spreadsheeta. 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

Smaller shipsLarger ships93.481.484.1185.6787.4883.5283.0688.7991.379.572.9682.8177.4180.9385.7874.9680.7791.7289.579.985.4582.7386.5381.6380.8489.2388.1477.8287.390.683.3785.1489.3883.7475.5776.8276.5576.6375.3381.285.6182.3390.9774.9389.1878.6388.0574.9193.8183.0883.3374.9589.8481.8681.7881.3686.2187.8191.485.1872.7486.8890.3774.8576.9975.2179.6781.7284.6182.7584.886.5985.9275.2486.3380.4483.8781.5485.778.8179.53Population standard deviations are known:(a) The point estimate of the difference between two population means is the difference between two sample means. That is: .Sample mean is the sum of observations divided by the total number of observations. Use Excel function "AVERAGE()" to obtain the sample mean for each sample.Thus, the point estimate for the difference is:Confidence level is 95% i.e., 0.95.Significance level is Margin of error is given by the formula:Calculations:Thus, the margin of error for 95% confidence is:A confidence interval indicates a range of values within which the population parameter is expected to lie. It is computed as follows:Thus, the 95% confidence interval estimate of the difference between means of two ships is 0.45 to 5.12.a. The point estimate for 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 is 2.78.b. At 95% confidence, the margin of error is 2.33.c. The 95% confidence interval estimate of the difference between population mean ratings for the two sizes of ships is 0.45 to 5.12.