Resorts & Spas, a magazine devoted to upscale vacations and accommodations, published its Reader's Choice List of the top 20 independent beachfront boutique hotels in the world. The data shown are the scores received by these hotels based on the results from Resorts & Spas' annual Readers' Choice Survey. Each score represents the percentage of respondents who rated a hotel as excellent or very good on one of three criteria (comfort, amenities, and in-house dining). An overall score was also reported and used to rank the hotels, The highest ranked hotel, the Murl Beach Odyssey, has an overall score of 95.1, the highest component of which is 100.0 for in-house dining. If required, round your answers to three decimal places, Click on the datafile logo to reference the data, DATA file Hotel Overall Confort Amenities In-House Dining Muri Beach Odyssey 95.1 99.9 88.4 100.0 Pattaya Resort 92.6 96.6 96.6 84.1 Sojourner's Respite 92.4 88.5 97.0 94.7 Spa Carrie 92.3 93.0 89.6 93.0 Penang Resort and Spa 90,6 92.4 98.7 820 Mokihana Hokele 92.5 88.8 92.5 Theo's of Cape Town 90.0 977 90.8 Cap d'Agde Resort 89.9 95.9 91.9 862 Spirit of Mykonos 90.7 85.8 Turismo del Mar ,8 95.0 91.1 87.8 Hotel Iguana 88.7 943 Sidi Abdel Rahman Palace 88.3 88.5 Sainte-Maxime Quarters 90.5 90.4 Rotorua Inn 88.0 77.3 90.5 94.5 88.9 94.6 915 78.0 90.6 31.9 83.2 88.1 93.4 91.8 875 DEL UV Rotorua Inn 93.4 91.8 77.3 88.0 87.5 93.0 73.5 91.6 Club Lapu-Lapu Terracina Retreat 86.8 90.9 89.6 74.9 Hacienda Punta Barco 86.3 95.4 90.8 77.3 86.0 94.8 91.4 76.4 85.7 Rendezvous Kolocep Cabo de Gata Vista Sanya Deluxe 92.5 91.2 78.2 84.1 92.0 89.2 72.2 (a) Determine the estimated multiple linear regression equation that can be used to predict the overall score given the scores for comfort, amenities, and in-house dining Let Xy represent Comfort Let x2 represent Amenities Let x3 represent In-House Dining X1 + X (b) Use the t test to determine the significance of each independent variable. What is the conclusion for each test at the 0.01 level of significance? ir your answer is zero, enter"0" The p-value associated with the estimated regression parameter bis Because this p value is less than the level of significance, we reject the hypothesis that i-0. We conclude that there is a relationship between the score on comfort and the overall score at the 0.01 level of significance when controlling for comfort and in-house dining The p-value associated with the estimated regression parameter by is Because this p-value is greater than the level of significance, we reject the hypothesis that B -0. We conclude that there is va relationship between the score on amenities and the overall score at the 0.01 level of significance when controlling for comfort and in-house dining The p-value associated with the estimated regression parameter by Because this p value is less than the level of significance, we do not reject the hypothesis that B -0. We conclude that there is a relationship start endencia X3 than the level Y LO 20X1+ 1*2 + L Use the t test to determine the significance of each independent variable. What is the conclusion for each test at the 0.01 level of significance? If your answer is zero, enter "O", The p-value associated with the estimated regression parameter bis Because this p-value is less than the level of significance, we reject the hypothesis that 81 = 0. We conclude that there is va relationship between the score on comfort and the overall score at the 0.01 level of significance when controlling for comfort and in-house dining The p-value associated with the estimated regression parameter b2 is Because this p-value is greater of significance, we reject the hypothesis that B2 = 0. We conclude that there is a relationship between the score on amenities and the overall score at the 0.01 level of significance when controlling for comfort and in-house dining The p-value associated with the estimated regression parameter by is Because this p-value is less of significance, we do not reject the hypothesis that ) - 0. We conclude that there is a relationship between the score on in-house dining and the overall score at the 0.01 level of significance when controlling for comfort and in-house dining (c) Remove all independent variables that are not significant at the 0.01 level of significance from the estimated regression equation. What is your recommended estimated regression equation? Enter a coefficient of zero for any independent variable you chose to remove than the level