f. What are 10. Ratings of Beachfront Boutique Hotels. 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 dis ing). 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. Hotel Overall Comfort Amenities In-House Dining Muri Beach Odyssey 94.3 94.5 90.8 97.7 Pattaya Resort 92.9 96.6 84.1 96.6 Sojourner's Respite 92.8 99.9 100.0 88.4 Spa Carribe 91.2 88.5 94.7 97.0 Penang Resort and Spa 90.4 95.0 87.8 91.1 Mokihana Ho-kele 90.2 92.4 82.0 98.7 Theo's of Cape Town 90.1 95.9 86.2 91.9 Cap d'Agde Resort 89.8 92.5 92.5 88.8 Spirit of Mykonos 89.3 94.6 85.8 90.7 Turismo del Mar 89.1 90.5 83.2 90.4 Hotel Iguana 89.1 90.8 81.9 88.5 Sidi Abdel Rahman Palace 89.0 93.0 93.0 89.6 Sainte-Maxime Quarters 88.6 92.5 78.2 91.2 Rotorua Inn 87.1 93.0 91.6 73.5 Club Lapu-Lapu 87.1 90.9 74.9 89.6 Terracina Retreat 86.5 94.3 78.0 91.5 Hacienda Punta Barco 86.1 95.4 77.3 90.8 Rendezvous Kolocep 86.0 94.8 76.4 91.4 Cabo de Gata Vista 86.0 92.0 72.2 89.2 Sanya Deluxe 85.1 93.4 77.3 91.8 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 dining b. Use the test to determine the significance of each independent variable. What is the conclusion for each test at the 0.01 level of significance? c. Remove all independent variables that are not significant at the 0.01 level of signifi- cance from the estimated regression equation. What is your recommended estimated regression equation? d. Suppose Resorts & Spas has decided to recommend each of the independent beach front boutiques in its data that achieves an estimated overall score over 90. Use de regression equation developed in part (c) to determine which of the independent beachfront boutiques will receive a recommendation from Resorts & Spas hance cost to be for a 3.5-year-old bus? 6. Studying and Grades. A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the file MktHrsPts. a. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? b. Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? c. Test whether each of the regression parameters Bo and B is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? d. How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? e. Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned. f. Mark Sweeney wants to receive a letter grade of A for this course, and he needs to earn at least 90 points to do so. Based on the regression equation developed in part (b), how many estimated hours should Mark study to receive a letter grade of A for this course? Dow Jones Industrial Averece