Please help answer questions 1 and 2 along. Also to take note of removing outliers at 95% confidence level and all insignificant variables. Please show how to solve using excel format. Thank you.

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.3, the highest component of which is 97.7 for in- house dining. The data file is also attached as Beachfront Hotels. + Hotel Overall Comfort Amenities 94.5 90.8 96.6 99.9 94.3 92.9 92.8 91.2 90.4 90.2 90.1 89.8 89.3 89.1 88.5 95.0 92.4 95.9 92.5 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 Turismo del Mar 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 Sanya Deluxe 94.6 90.5 90.8 93.0 92.5 93.0 90.9 94.3 95.4 94.8 92.0 93.4 89.1 89.0 88.6 87.1 87.1 In-House Dining 97.7 96.6 88.4 97.0 91.1 98.7 91.9 88.8 90.7 90.4 88.5 89.6 91.2 73.5 89.6 91.5 90.8 91.4 89.2 91.8 84.1 100.0 94.7 87.8 82.0 86.2 92.5 85.8 83.2 81.9 93.0 78.2 91.6 74.9 78.0 77.3 76.4 72.2 77.3 86.5 86.1 86.0 86.0 85.1 1. 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. 2. Use the t test to determine the significance of each independent variable at the 0.05 level of significance. How will your conclusion change if the level of significance is changed to 0.01? Remove outliers at the 95% confidence level, and all the insignificant variables