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 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 Shore Excursions and Food/Dining. An overall score was also reported and used to rank the ships. The highest ranked ship, the Seabourn Odyssey, has an overall score of 94.4, the highest component of which is 97.8 for Food/Dining.

Ship	Overall	Shore Excursions	Food/Dining
Seabourn Odyssey	94.4	90.9	97.8
Seabourn Pride	93.0	84.2	96.7
National Geographic Endeavor	92.9	100.0	88.5
Seabourn Sojourn	91.3	94.8	97.1
Paul Gauguin	90.5	87.9	91.2
Seabourn Legend	90.3	82.1	98.8
Seabourn Spirit	90.2	86.3	92.0
Silver Explorer	89.9	92.6	88.9
Silver Spirit	89.4	85.9	90.8
Seven Seas Navigator	89.2	83.3	90.5
Silver Whisperer	89.2	82.0	88.6
National Geographic Explorer	89.1	93.1	89.7
Silver Cloud	88.7	78.3	91.3
Celebrity Xpedition	87.2	91.7	73.6
Silver Shadow	87.2	75.0	89.7
Silver Wind	86.6	78.1	91.6
SeaDream II	86.2	77.4	90.9
Wind Star	86.1	76.5	91.5
Wind Surf	86.1	72.3	89.3
Wind Spirit	85.2	77.4	91.9

A) Predict the overall score for a cruise ship with a Shore Excursions score of 81 and a Food/Dining Score of 92. (Round your answer to one decimal place.)

B) Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining Score of 92. (Round your answer to one decimal place.)

Answer 1

using minitab>stat>Regression>fit regression model

we have

Regression Analysis: Overall versus Shore, Food/Dining

Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 2 90.95 45.477 24.00 0.000
Shore 1 69.05 69.053 36.44 0.000
Food/Dining 1 30.75 30.752 16.23 0.001
Error 17 32.21 1.895
Total 19 123.17

Model Summary

S R-sq R-sq(adj) R-sq(pred)
1.37650 73.85% 70.77% 62.81%

Coefficients

Term Coef SE Coef T-Value P-Value VIF
Constant 45.18 6.95 6.50 0.000
Shore 0.2529 0.0419 6.04 0.000 1.01
Food/Dining 0.2482 0.0616 4.03 0.001 1.01

Regression Equation

Overall = 45.18 + 0.2529 Shore + 0.2482 Food/Dining

Ans a ) Shore Excursions score = 81 and a Food/Dining Score = 92

Overall = 45.18 + 0.2529*81 + 0.2482*92=43.8

Ans b )

Shore Excursions score = 80 and a Food/Dining Score = 92

Overall = 45.18 + 0.2529*80 + 0.2482*92=43.5