Check My Work 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 Muri 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. Click on the datatile logo to reference the data. DATA file Hotel Overall Comfort Amenities In-House Dining Mun 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 Carribe 92.3 93.0 89.6 93.0 Penang Resort and Spa 90.6 92.4 98.7 82.0 Mokihana Hkele 90.5 92.5 88.8 92.5 Theo's of Cape Town 90.0 94.5 97.7 90.8 Cap d'Agde Resort 89.9 95.9 91.9 86.2 Spirit of Mykonos 88.9 94.6 90.7 85.8 Turismo del Mar. 88.8 95.0 91.1 87.8 88.7 Hotel Iguana 94.3 91.5 78.0 81.9 Sidi Abdel Rahman Palace 68.3 90.8 88.5 83.2 88.1 90.5 90.4 Sainte-Maxime Quarters 27.3 91.8 93.4 88.0 Rotorua Inni 87.5 91.6 93.0 73,5 Club Lapu-Lapu Terracina Retreat 89.6 24.9 90.9 86.8 90.0 77.3 86.3 95.4 76.4 91.4 94.8 86.0 Hacienda Punta Barco) Rendezvous Kolocep Cabo de Gata Vista, Sanya Deluxe 28.2 91.2 92.5 85,7 72.2 89.2 64.1 92.0 (a) Determine the estimated multiple linear regression equation that can be used to predict the overall score given the scores for comfort, amenbes, and m-house dong Let x represent Comfort. 2124 5/26/20 (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 x represent Comfort Let y represent Amenities Let ay represent In-House Dining. 9- KI+ X2 + XI (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? If your answer is zero enter "0" The p-value associated with the estimated regression parameter by is Because this p-value Select your answer Select your answer relationship between than the level of significance, we the score on comfort and the Select your answer the hypothesis that -0. We conclude that there overall score at the 0.01 level of significance when controlling for Select your answer Because this p-value Select your answer The p-value associated with the estimated regression parameter by is Select your answer than the level of significance, we the score on amenities and the the hypothesis that a 0. We conclude that there Select your answer a relationship between overall score at the 0.01 level of significance when controlling for Select your answer The p-value associated with the estimated regression parameter by as Because this p-value is Select your answer than the level of significance, we a relationship between the score on in-house dining and Select your answer the hypothesis that py-0. We conclude that there is not 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 yet recenmended estrated regression equation? Enter a coefficient of zero for any independent variable you chose to remove XL 42. M Check My Work 8 Icon Key Check My Work 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 Muri 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. Click on the datatile logo to reference the data. DATA file Hotel Overall Comfort Amenities In-House Dining Mun 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 Carribe 92.3 93.0 89.6 93.0 Penang Resort and Spa 90.6 92.4 98.7 82.0 Mokihana Hkele 90.5 92.5 88.8 92.5 Theo's of Cape Town 90.0 94.5 97.7 90.8 Cap d'Agde Resort 89.9 95.9 91.9 86.2 Spirit of Mykonos 88.9 94.6 90.7 85.8 Turismo del Mar. 88.8 95.0 91.1 87.8 88.7 Hotel Iguana 94.3 91.5 78.0 81.9 Sidi Abdel Rahman Palace 68.3 90.8 88.5 83.2 88.1 90.5 90.4 Sainte-Maxime Quarters 27.3 91.8 93.4 88.0 Rotorua Inni 87.5 91.6 93.0 73,5 Club Lapu-Lapu Terracina Retreat 89.6 24.9 90.9 86.8 90.0 77.3 86.3 95.4 76.4 91.4 94.8 86.0 Hacienda Punta Barco) Rendezvous Kolocep Cabo de Gata Vista, Sanya Deluxe 28.2 91.2 92.5 85,7 72.2 89.2 64.1 92.0 (a) Determine the estimated multiple linear regression equation that can be used to predict the overall score given the scores for comfort, amenbes, and m-house dong Let x represent Comfort. 2124 5/26/20 (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 x represent Comfort Let y represent Amenities Let ay represent In-House Dining. 9- KI+ X2 + XI (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? If your answer is zero enter "0" The p-value associated with the estimated regression parameter by is Because this p-value Select your answer Select your answer relationship between than the level of significance, we the score on comfort and the Select your answer the hypothesis that -0. We conclude that there overall score at the 0.01 level of significance when controlling for Select your answer Because this p-value Select your answer The p-value associated with the estimated regression parameter by is Select your answer than the level of significance, we the score on amenities and the the hypothesis that a 0. We conclude that there Select your answer a relationship between overall score at the 0.01 level of significance when controlling for Select your answer The p-value associated with the estimated regression parameter by as Because this p-value is Select your answer than the level of significance, we a relationship between the score on in-house dining and Select your answer the hypothesis that py-0. We conclude that there is not 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 yet recenmended estrated regression equation? Enter a coefficient of zero for any independent variable you chose to remove XL 42. M Check My Work 8 Icon Key