what is the solution

In-House Dining d. How much of the variation in the sample values of weekly be the model in partic) explain! e. Green the results in partial and (c), what should your next step be? Explain 10 Ratings of Beachfront Boutique Hotels Resort & Spas, a magazine devoted to 1. What are the managerial implications of these results? upscale vacations and accommodations, published its Reader's Choice List of the top 20 independent beachfront boutique hotels in the world. The data show and the notes received by these hotels based on the results from Resort & Spas annual Ricardens Choice Survey. Each score represents the percentage of respondents who rated and as excellent or very good on one of three criteria (comfort, amenities, and in-house ing). An overall score was also reported and used to rank the hotels. The highest rank hotel, the Muri Beach Odyssey, has an overall score of 943, the highest component which is 97.7 for in-house dining. Hotel Overall Comfort Amenities 943 Muri Beach Odyssey 94,5 90.8 977 92.9 96.6 841 Pattaya Resort 95.6 Sojourner's Respite 928 99.9 100.0 85.4 912 Spa Catribe 88.5 947 97.0 Penang Resort and Spa 90.4 95.0 87.8 91.1 Mokihana Ho-kele 90.2 92.4 82.0 982 Theo's of Cape Town 90.1 95.9 86.2 919 Cap d'Agde Resort 89.8 92.5 92.5 Spirit of Mykonos 89.3 94.6 B5.8 90.2 Turismo del Mar 891 905 832 904 Hotel Iguana 89.1 90.8 81.9 855 Sidi Abdel Rahman Palace 89.0 93.0 89.6 Sainte-Maxime Quarters 386 92.5 782 91.2 Rotorua Inn B71 93.0 91.6 73,5 Club Lapu-lapu 871 90.9 74.9 99.6 Terracina Retreat B6 5 943 78.0 915 Hacienda Punta Barco 86.1 95.4 90.6 Rendezvous Kolocep 860 94.8 76.4 91.4 Cabo de Gata Vista 860 92.0 72.2 892 Sanya Deluxe 85.1 93,4 77.3 91.8 930 77.3 a. Determine the estimated multiple linear regression equation that can be used to pre dict the overall score given the scores for comfort, amenities, and in-house dinine h. Use the / test to determine the significance of each independent variabile. What is c. Renwe all independent variables that are not significant at the 0.01 level of signal regression equation? cance from the estimated regression equation. What is your recommended estimated d. Suppose Resort & Spas has decided to recommend cach of the independent best front boutiques in its data that achieves an estimated overall score Over Use the regression equation developed in part (e) to determine which of the independent beachfront boutiques will receive a recommendation from Resort & Spas