Using Excel and showing formulas, solve the below: A travel magazine is studying the difference in perceived quality of Middle Eastern and US airlines. A sample of 17 passengers who had flown Emirates and 20 passengers who had flown Delta, were asked to rate their overall satisfaction on a 7-point scale. The average quality ratings obtained were 5.353 for Emirates and 3.882 for Delta. The sample variance for quality ratings was found to be 2.743 for Emirates and 2.985 for Delta. Construct a 96% confidence interval for the difference in average satisfaction rating between all passengers who have flown Emirates and all passengers who have flown Delta. Based on this confidence interval, and a 4% significance level, can you conclude that there is a difference in the average quality ratings for Emirates and Delta airlines?
Using Excel and showing formulas, solve the below:
A travel magazine is studying the difference in perceived quality of Middle Eastern and US airlines. A sample of 17 passengers who had flown Emirates and 20 passengers who had flown Delta, were asked to rate their overall satisfaction on a 7-point scale. The average quality ratings obtained were 5.353 for Emirates and 3.882 for Delta. The sample variance for quality ratings was found to be 2.743 for Emirates and 2.985 for Delta. Construct a 96% confidence interval for the difference in average satisfaction rating between all passengers who have flown Emirates and all passengers who have flown Delta. Based on this confidence interval, and a 4% significance level, can you conclude that there is a difference in the average quality ratings for Emirates and Delta airlines?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
