The Condé Nast Traveler Gold List provides ratings for the top 20 small cruise s

Question

The Condé Nast Traveler Gold List provides ratings for the top 20 small cruise ships. The data shown below are the scores each ship received based upon results. The highest ranked ship,, the Seabourn Odgssey, has an overall score of 94.3, the highest component of which is 97.7 for Food/Dining.
A. Determine an estimated regression equation that can be used to predict the overall score given the score for Shore Exursions(3 decimals).
B. Consider the addition of the independent variable Food/Dining. Develop the estimated regression equation that can be used to predict the overall score given the scores for Shore Excursions and Food/Dining(3 decimals).
C. Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining of 90(2 decimals).


Overall 94.3 92.8 92.8 91.1 90.7 90.4 90.3 90.1 89.6 89.2 89.1 89.2 88.7 87.3 87.4 86.7 86.4 86.1 86.2 85.0 Ship Excursions Food/Dining 90.7 84.4 99.9 94.8 88.0 82.0 86.3 92.6 86.0 83.1 81.8 92.9 78.4 91.9 75.1 78.0 97.7 96.7 88.5 97.0 91.3 98.7 92.0 88.9 91.0 90.6 88.7 89.7 91.2 73.4 89.5 91.7 90.9 91.7 89.3 91.8 Seabourn Odyssey Seabourn Pride National Geographic Endeavor Seabourn Sojourn Paul Gauguin Seabourn Legend Seabourn Spirit Silver Explorer Silver Spirit Seven Seas Navigator Silver Whisperer National Geographic Explorer Silver Cloud Celebrity Xpedition Silver Shadow Silver Wind SeaDream II 76.6 72.1 77.5 Wind Star Wind Surf Wind Spirit

Explanation / Answer

A. Determine an estimated regression equation that can be used to predict the overall score given the score for Shore Exursions

SOl: In Excel Using the data analysis------->Regression

The regression equation is

Y^=69.661+0.230(Excursion)

B. Consider the addition of the independent variable Food/Dining. Develop the estimated regression equation that can be used to predict the overall score given the scores for Shore Excursions and Food/Dining

Sol:In Excel Using the data analysis------->Regression

The regression equation is Y^=46.348+0.249(Excursion)+0.238(Food/Dining)

C. Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining of 90

Sol:The regression equation is Y^=46.348+0.249(Excursion)+0.238(Food/Dining)

            Y^=46.348+0.249(80)+0.238(90)

               =46.348+19.92+21.42

               =87.68

SUMMARY OUTPUT Regression Statistics Multiple R 0.700300749 R Square 0.49042114 Adjusted R Square 0.462111203 Standard Error 1.834232672 Observations 20 ANOVA df SS MS F Significance F Regression 1 58.28262909 58.28263 17.32329 0.000585478 Residual 18 60.55937091 3.364409 Total 19 118.842 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 69.66130548 4.705105943 14.80547 1.6E-11 59.77624472 79.54636624 59.77624472 79.54636624 X Variable 1 0.230981465 0.055496039 4.162125 0.000585 0.114388613 0.347574317 0.114388613 0.347574317

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.