egin{tabular}{|l|r|r|r|} hline Ship & Overall & egin{tabular}{c} Shore \ Excursions end{tabular} & Food/Dining \ hline Seabourn Odyssey & 94,4 & 90,9 & 97,8 \ hline Seabourn Pride & 93,0 & 84,2 & 96,7 \ hline National Geographic Endeavor & 92,9 & 100,0 & 88,5 \ hline Seabourn Sojourn & 91,3 & 94,8 & 97,1 \ hline Paul Gauguin & 90,5 & 87,9 & 91,2 \ hline Seabourn Legend & 90,3 & 82,1 & 98,8 \ hline Seabourne Spirit & 90,2 & 86,3 & 92,0 \ hline Silver Explorer & 89,9 & 92,6 & 88,9 \ hline Silver Spirit & 89,4 & 85,9 & 90,8 \ hline Seven Seas Navigator & 89,2 & 83,3 & 90,5 \ hline Silver Whisperer & 89,2 & 82,0 & 88,6 \ hline Natinal Geographic Explorer & 89,1 & 93,1 & 89,7 \ hline Silver Cloud & 88,7 & 78,3 & 91,3 \ hline Celebrity Xpedition & 87,2 & 91,7 & 73,6 \ hline Silver Shadow & 87,2 & 75,0 & 89,7 \ hline Silver Wind & 86,6 & 78,1 & 91,6 \ hline SeaDream II & 86,2 & 77,4 & 90,9 \ hline Wind Star & 86,1 & 76,5 & 91,5 \ hline Wind Surf & 86,1 & 72,3 & 89,3 \ hline Wind Spirit & 85,2 & 77,4 & 91,9 \ hline & & & \ hline Scoring Cruise Ships. The Cond Nast Traveler Gold List provides ratings for the \ hline top 20 small cruise ships. The data shown above are the scores each ship received \ hline based upon the results from Cond Nast Traveler's annual Readers' Choice Survey. \ hline Each score represents the percentage of respondents who rated a ship as excellent or \ hline end{tabular} 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. a. Determine an estimated regression equation that can be used to predict the overall score given the score for Shore Excursions. 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. c. Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining Score of 90. d. Use the ( mathrm{F} ) test to determine the overall significance of the relationship. What is your conclusion at the .05 level of significance? e. Use the ( t ) test to determine the significance of each independent variable. What is your conclusion at the .05 level of significance?

Shore Ship Overall Food/Dining Excursions 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 Seabourne 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,61 Natinal 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 Scoring Cruise Ships. The Cond Nast Traveler Gold List provides ratings for the top 20 small cruise ships. The data shown above 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. a. Determine an estimated regression equation that can be used to predict the overall score given the score for Shore Excursions. 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. c. Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining Score of 90. d. Use the F test to determine the overall significance of the relationship. What is your conclusion at the .05 level of significance? e. Use the t test to determine the significance of each independent variable. What is your conclusion at the .05 level of significance?