Hotel Overall Comfort Amenities In-House Dining Muri Beach Odyssey 95.1 99.9 100.0 88.4 Pattaya Resort 92.6 96.6 84.1 96.6 Sojourner's Respite 92.4 88.5 94.7 97.0 Spa Carribe 92.3 93.0 93.0 89.6 Penang Resort and Spa 90.6 92.4 82.0 98.7 Mokihana Hkele 90.5 92.5 92.5 88.8 Theo's of Cape Town 90.0 94.5 90.8 97.7 Cap d'Agde Resort 89.9 95.9 86.2 91.9 Spirit of Mykonos 88.9 94.6 85.8 90.7 Turismo del Mar 88.8 95.0 87.8 91.1 Hotel Iguana 88.7 94.3 78.0 91.5 Sidi Abdel Rahman Palace 88.3 90.8 81.9 88.5 Sainte-Maxime Quarters 88.1 90.5 83.2 90.4 Rotorua Inn 88.0 93.4 77.3 91.8 Club Lapu-Lapu 87.5 93.0 91.6 73.5 Terracina Retreat 86.8 90.9 74.9 89.6 Hacienda Punta Barco 86.3 95.4 77.3 90.8 Rendezvous Kolocep 86.0 94.8 76.4 91.4 Cabo de Gata Vista 85.7 92.5 78.2 91.2 Sanya Deluxe 84.1 92.0 72.2 89.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 x1 represent Comfort. Let x2 represent Amenities. Let x3 represent In-House Dining. = + X1 + X2 + X3 (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 b1 is - - Select your answer than the level of significance, we conclude that there Select your answer - 0.01 level of significance when controlling for - Because this p-value is Select your answer - the hypothesis that 1 = 0. We a relationship between the score on comfort and the overall score at the Select your answer - The p-value associated with the estimated regression parameter b2 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 amenities and the overall score at the 0.01 level of significance when controlling for Select your answer - - Select your answer - the hypothesis that 2 = 0. We Because this p-value is - Select your answer than the level of significance, we - Select your answer The p-value associated with the estimated regression parameter b3 is - Select your answer the hypothesis that 3 = 0. We - a relationship between the score on in-house dining and the overall score conclude that there at the 0.01 level of significance when controlling for - Select your answer - (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. = + X1 + X2 + X3