please help solving the following question
The Conde Nast Traveler Gold List for 2012 provided ratings for the top 20 small cruise ships (Conde Nast Traveler website, March 1, 2012). 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.
thank you
The Conde Nast Traveler Gold List for 2012 provided ratings for the top 20 small cruise ships (Cond Nast Traveler website, March 'I, 2012). 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. The data is shared with the name of Discussion 9\"Ships\" data file. Share Ship Overall Em Foodllllmlnq Smboum Odysuy 94.4 90.9 97.8 Smbourn Pn'de 93.0 84.2 96.7 NW Geographic Endeavor 92.9 100.0 38.5 Smbmu'n Sojnum 91.3 94.8 97 .1 PM Gaugubl 905 81.9 91.2 Seaman! Legend 90.3 32.1 98.8 Smbown Spirit 90.2 86.3 92.0 1. Determine an estimated regression equation that can be used to predict the overall score given the score for Shore Excursions. 2. Considerthe 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. Interpret the coefficients. 4. Does the model appear to explain a large amount of variability. 5. Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining Score of 90. Shore Ship Overall 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 Wind Star 86.1 76.5 91.5 Wind Surf 86.1 72.3 89.3 Wind Spirit 85.2 77.4 91.9