Please help. See below data for problem

Ship Overall Shore Excursions Food/Dining Seabourn Odyssey 94.4 90.9 97.8 Seabourn Pride 93 84.2 96.7 National Geographic Endeavor 92.9 100 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 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 88.6 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 89.7 Silver Wind 86.6 78.1 91.6 SeaDream II 86.2 77.4 90.9 W

DATAfile: Ships A statistical program is recommended. Ship The Conde 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 Conde 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 B C D Shore Ship Overall Excursions Food/Dining 1 Ship Overall Excursions Seabourn Odyssey Food/Dining 94.4 90.9 97.8 2 Seabourn Odyssey 94.4 90.9 Seabourn Pride 93.0 97.8 84.2 96.7 Seabourn Pride National Geographic Endeavor 93 92.9 100.0 38.5 84.2 96.7 Seabourn Sojourn 4 National Geographic Endeavor 91.3 34.8 92.9 97.1 100 88.5 Paul Gauguin 90.5 87.9 5 91.2 Seabourn Sojourn 91.3 94.8 97.1 Seabourn Legend 90.3 82.1 98.8 6 Paul Gauguin 90.5 87.9 91.2 Seabourn Spirit 90.2 86.3 92.0 7 Seabourn Legend 90.3 82.1 98.8 Silver Explorer 89.9 92.6 BB.9 8 Seabourne Spirit 90.2 86.3 92 Silver Spirit 89.4 85.9 90.8 9 Silver Explorer 89.9 92.6 88.9 Seven Seas Navigator 89.2 83.3 90.5 10 Silver Spirit 89.4 85.9 Silver Whispere 90.8 89.2 82. 38.6 11 Seven Seas Navigator 89.2 83.3 National Geographic Explorer 89.1 93.1 89.7 90.51 Silver Cloud 12 Silver Whisperer 88.7 78.3 91.3 89.2 82 88.6 Celebrity Xpedition 87.2 91.7 73. 13 Natinal Geographic Explorer 89.1 93.1 89.7! Silver Shadow 87.2 75.0 89.7 14 Silver Cloud 88.7 78.3 91.3 Silver Wind 86.6 78.1 91.6 15 Celebrity Xpedition 87.2 91.7 73.6 SeaDream II 86.2 77.4 30.9 16 Silver Shadow 87.2 75 89.7 Wind Star 86.1 76.5 91.5 17 Silver Wind 86.6 78.1 91.6! Wind Surf 86.1 72.3 89.3 18 SeaDream II 86.2 Wind Spirit 77.4 90.9 85.2 77.4 91.9 19 Wind Star 86.1 76.5 91.5 score.) (a) Determine an estimated regression equation that can be used to predict the overall score given the score for Shore Excursions. (Round your numerical values to two decimal places. Let x, represent the Shore Excursions score and y represent the overall 20 Wind Surf 86.1 72.3 89.31 21 Wind Spirit 85.2 77.4 91.9 22 (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. (Round your numerical values to two decimal places. Let x, represent the Shore Excursions score, x, represent the Food/Dining score, and y represent the overall score.) 23 24 25 (c) Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining Score of 94. (Round your answer to one decimal place.) 26 27