Struggling with my homework... Would appreciate any help I can get!

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 94.8, the highest component of which is 100.0 for amenities. If required, round your answers to three decimal places. Click on the datafile logo to reference the data. DATA file Overall Comfort 94.8 99.9 88.5 Amenities 100.0 94.7 90.8 93.0 In-House Dining 88.4 97.0 97.7 94.7 92.9 91.6 89.6 Hotel Muri Beach Odyssey Pattaya Resort Sojourner's Respite Spa Carribe Penang Resort and Spa Mokihana Hokele Theo's of Cape Town Cap d'Agde Resort Spirit of Mykonos Turismo del Mar 94.5 93.0 95.9 92.5 91.9 90.3 90.3 95.0 86.2 92.5 87.8 85.8 78.2 82.0 88.8 91.1 90.7 90.0 89.6 89.1 88.9 88.5 94.6 92.5 92.4 91.2 98.7 90.6 91.5 95.4 77.3 Hotel Iguana Sidi Abdel Rahman Palace 88.4 94.3 78.0 Overall Comfort Hotel Amenities In-House Dining 88.4 94.8 100.0 99.9 94.7 88.5 94.7 97.0 92.9 94.5 90.8 97.7 91.6 93.0 93.0 89.6 90.3 Muri Beach Odyssey Pattaya Resort Sojourner's Respite Spa Carribe Penang Resort and Spa Mokihana Hkele Theo's of Cape Town Cap d'Agde Resort Spirit of Mykonos 95.9 86.2 91.9 90.3 92.5 92.5 88.8 90.0 95.0 91.1 87.8 89.6 94.6 85.8 90.7 91.2 89.1 92.5 78.2 Turismo del Mar 88.9 92.4 98.7 82.0 88.5 95.4 77.3 90.8 88.4 94.3 78.0 91.5 88.3 96.6 84.1 96.6 87.7 90.5 83.2 90.4 87.4 Hotel Iguana Sidi Abdel Rahman Palace Sainte-Maxime Quarters Rotorua Inn Club Lapu-Lapu Terracina Retreat Hacienda Punta Barco Rendezvous Kolocep Cabo de Gata Vista 90.8 81.9 88.5 87.2 90.9 74.9 89.6 86.2 93.4 77.3 91.8 86.1 94.8 91.4 76.4 84.7 93.0 91.6 73.5 84.1 92.0 72.2 89.2 Sanya Deluxe Sanya Deluxe X2 + () 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 xi represent Comfort Let 2 represent Amenities Let X3 represent In-House Dining - X1 + (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 bis Because this p-value is Select your answer than the level of significance, we - Select your answer the hypothesis that B1 -0. We conclude that there - Select your answer a relationship between the score on comfort and the overall score at the 0.01 level of significance when controlling for - Select your answer The p value associated with the estimated regression parameter bz is Because this p-value is - Select your answer than the level of significance, we - Select your answer the hypothesis that B2 -0. 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 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 - Select your answer the hypothesis that 8 -0. 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 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 + xy