Resort & Spa, 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 Resort & Spas annual Readers' Choice Survey. Each score represents the percentage of moondents 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 Murt Beach Odyssey, has an overall score of 94.0, the highest component of which is 100.0 for amenities. If required, round your answers to three decimal places. Click on the datafle logo to reference the data DATA file Hotel Murl Beach Odyssey Pattaya Resort- Sejourner's Respite Sipa Carribe Penang Resort and Spa Mokihana Hokele Theo's of Cape Town Cap d'Agde Resort Spirit of Mykonos Teisma del Mar Hotel Iguana Sidi Abdel Rahman Palace Sainte Haxime Quarters Rotorua ins Club Lapu-Lapu Terracina Retreat Hacienda Punta Barce Rendervous Kolocep Cabo de Gata Vieta Sanya Deluss Overall 94.8 94,7 92.0 914 00.3 90,3 90.0 89.6 09.1 86.9 M.S. BA 08.3 87.7 87/4 8/2 86.2 86.1 143 Comfort 99.9 06.5 94.5 $1.0 95.0 92.5 95.0 1.6 92.5 92.4 95.4 13 96.6 90.5 90.8 90.9 $0.4 94,8 93.0 92.0 Amenities 100.0 94.7 90.8 03.0 06.2 92.3 37.5 85.8 78.2 82.0 773 75.0 14.1 03.2 $1.9 74.9 713 76.4 914 72.2 In House Dining 97.0 97.2 89.0 91.9 *** 911 90.7 91.2 98.7 900 915 96.6 90.4 08.3 49.4 918 914 735 #9.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 x, represent Comfort Let x represent Amenities. Let xy represent In-House Dining 9- (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 The p-value associated with the estimated regression parameter Dis Because this p-value is Select your answer than the level of significance, we conclude that there Select your answera relationship between the score on comfort and the overall score at the 0.01 level of significance when controling for Because this p-value is Select your answer than the level of significance, we a relationship between the score on amenities and the overall score at the 0.01 level of significance when controlling for The p-value associated with the estimated regression parameter by is Because this p-value is Select your answer- than the level of significance, we conclude that there Select your answer a relationship between the score on in-house dining and the overall score at the 0.01 level of significance when controlling for Select your answer- (c) Remove all independent vartables 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 The p-value associated with the estimated regression parameter by is condude that there-Select your answer Select your answer the hypothesis that 5-0. We - + Select your answer the hypothesis that -0. We Select your answer Select your answer the hypothesis that yo, we Select your answer Resort & Spa, 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 Resort & Spas annual Readers' Choice Survey. Each score represents the percentage of moondents 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 Murt Beach Odyssey, has an overall score of 94.0, the highest component of which is 100.0 for amenities. If required, round your answers to three decimal places. Click on the datafle logo to reference the data DATA file Hotel Murl Beach Odyssey Pattaya Resort- Sejourner's Respite Sipa Carribe Penang Resort and Spa Mokihana Hokele Theo's of Cape Town Cap d'Agde Resort Spirit of Mykonos Teisma del Mar Hotel Iguana Sidi Abdel Rahman Palace Sainte Haxime Quarters Rotorua ins Club Lapu-Lapu Terracina Retreat Hacienda Punta Barce Rendervous Kolocep Cabo de Gata Vieta Sanya Deluss Overall 94.8 94,7 92.0 914 00.3 90,3 90.0 89.6 09.1 86.9 M.S. BA 08.3 87.7 87/4 8/2 86.2 86.1 143 Comfort 99.9 06.5 94.5 $1.0 95.0 92.5 95.0 1.6 92.5 92.4 95.4 13 96.6 90.5 90.8 90.9 $0.4 94,8 93.0 92.0 Amenities 100.0 94.7 90.8 03.0 06.2 92.3 37.5 85.8 78.2 82.0 773 75.0 14.1 03.2 $1.9 74.9 713 76.4 914 72.2 In House Dining 97.0 97.2 89.0 91.9 *** 911 90.7 91.2 98.7 900 915 96.6 90.4 08.3 49.4 918 914 735 #9.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 x, represent Comfort Let x represent Amenities. Let xy represent In-House Dining 9- (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 The p-value associated with the estimated regression parameter Dis Because this p-value is Select your answer than the level of significance, we conclude that there Select your answera relationship between the score on comfort and the overall score at the 0.01 level of significance when controling for Because this p-value is Select your answer than the level of significance, we a relationship between the score on amenities and the overall score at the 0.01 level of significance when controlling for The p-value associated with the estimated regression parameter by is Because this p-value is Select your answer- than the level of significance, we conclude that there Select your answer a relationship between the score on in-house dining and the overall score at the 0.01 level of significance when controlling for Select your answer- (c) Remove all independent vartables 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 The p-value associated with the estimated regression parameter by is condude that there-Select your answer Select your answer the hypothesis that 5-0. We - + Select your answer the hypothesis that -0. We Select your answer Select your answer the hypothesis that yo, we Select your