Quantitative Methods homework.
Thank you for your help!
Please see the Data in the Excel file answer the following questions. The data set lists the scores received by a number of hotels for three criteria (comfort, amenities, in- house dining). An overall score was also reported in the data. a. Using a confidence level of 95%, develop a multiple regression equation for these data to predict the overall score given the scores for comfort, amenities, in-house dining. (0.5 points) b. Predict (or forecast) the overall rating for a hotel that has a comfort rating of 87, amenities rating of 93, and in-house dining rating of 88. (0.25 points) c. Is your regression model statistically significant? Provide the necessary values (p- values, alpha) to support your answer. Answers without the necessary values will not receive any credit. (0.35 points) d. Which variables are statistically significant? Provide the necessary values (p-values, alpha) to support your answer. Answers without the necessary values will not receive any credit. (0.75 points) e. Determine the strength of the linear relationship by using the correlation coefficient for each predictor and response variable pair. (0.6 points) f. How much of the variability in overall hotel rating can be explained by your regression model? (0.1 points) g. What are the values of r (0.1 points) and r2 (0.1 points) for this model? Hotel Overall Comfort Amenities In-House Dining Muri Beach Odyssey 78.3 75.2 75.2 76.1 77.1 83.8 77.1 79.3 80.3 81.3 82.3 78.1 93.7 69.1 69.1 80.0 80.9 83.3 84.3 85.3 81.9 72.5 86.3 75.2 76.1 77.1 78.1 76.1 80.0 89.0 81.9 72.5 80.7 84.8 85.7 95.4 76.7 77.5 86.2 79.2 91.5 Pattaya Resort Sojourner's Respite Spa Carribe Penang Resort and Spa Mokihana Hkele Theo's of Cape Town Cap d'Agde Resort 1 Spirit of Mykonos e Turismo del Mar 3 Hotel Iguana 4 Sidi Abdel Rahman Palace 5 Sainte-Maxime Quarters 6 Rotorua Inn 7 Club Lapu-Lapu 8 Terracina Retreat 9 Hacienda Punta Barco O Rendezvous Kolocep 1 Cabo de Gata Vista 22 Sanya Deluxe 96.0 97.1 81.9 87.0 73.3 84.8 94.3 73.3 87.3 84.8 85.7 86.7 76.7 86.7 84.4 77.5 88.3 89.3 90.3 91.3 92.3 93.3 94.3 95.3 96.3 78.4 79.2 93.1 86.2 95.1 91.5 80.9 89.9 91.5 80.9 89.0 89.9 81.7 97.3 Please see the Data in the Excel file answer the following questions. The data set lists the scores received by a number of hotels for three criteria (comfort, amenities, in- house dining). An overall score was also reported in the data. a. Using a confidence level of 95%, develop a multiple regression equation for these data to predict the overall score given the scores for comfort, amenities, in-house dining. (0.5 points) b. Predict (or forecast) the overall rating for a hotel that has a comfort rating of 87, amenities rating of 93, and in-house dining rating of 88. (0.25 points) c. Is your regression model statistically significant? Provide the necessary values (p- values, alpha) to support your answer. Answers without the necessary values will not receive any credit. (0.35 points) d. Which variables are statistically significant? Provide the necessary values (p-values, alpha) to support your answer. Answers without the necessary values will not receive any credit. (0.75 points) e. Determine the strength of the linear relationship by using the correlation coefficient for each predictor and response variable pair. (0.6 points) f. How much of the variability in overall hotel rating can be explained by your regression model? (0.1 points) g. What are the values of r (0.1 points) and r2 (0.1 points) for this model? Hotel Overall Comfort Amenities In-House Dining Muri Beach Odyssey 78.3 75.2 75.2 76.1 77.1 83.8 77.1 79.3 80.3 81.3 82.3 78.1 93.7 69.1 69.1 80.0 80.9 83.3 84.3 85.3 81.9 72.5 86.3 75.2 76.1 77.1 78.1 76.1 80.0 89.0 81.9 72.5 80.7 84.8 85.7 95.4 76.7 77.5 86.2 79.2 91.5 Pattaya Resort Sojourner's Respite Spa Carribe Penang Resort and Spa Mokihana Hkele Theo's of Cape Town Cap d'Agde Resort 1 Spirit of Mykonos e Turismo del Mar 3 Hotel Iguana 4 Sidi Abdel Rahman Palace 5 Sainte-Maxime Quarters 6 Rotorua Inn 7 Club Lapu-Lapu 8 Terracina Retreat 9 Hacienda Punta Barco O Rendezvous Kolocep 1 Cabo de Gata Vista 22 Sanya Deluxe 96.0 97.1 81.9 87.0 73.3 84.8 94.3 73.3 87.3 84.8 85.7 86.7 76.7 86.7 84.4 77.5 88.3 89.3 90.3 91.3 92.3 93.3 94.3 95.3 96.3 78.4 79.2 93.1 86.2 95.1 91.5 80.9 89.9 91.5 80.9 89.0 89.9 81.7 97.3