Please answer the following questions with the excel sheets provided

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 fromResorts & 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 is in the attached Excel file.

Part 1: The regression result of using all three independent variablescomfort, amenities, and in-house dining can be found inworksheet "regression with 3 indep. vars" of the attached Excel file.

Q1: Please use the regression output to 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 below:

Q2: Explain the coefficients for the three independent variables.

Q3: What is the conclusion for the significance of each independent variable at the 0.01 level of significance? (You can refer to the p values)

Part 2: The regression result of using two independent variables, amenities and in-house dining can be found inworksheet "regression with 2 indep. vars" of the attached Excel file.

Q4: Please use the regression output to determine the estimated multiple linear regression equation that can be used to predict the overall score given the scores for amenities and in-house dining below:

Q5: SupposeResorts & Spashas decided to recommend each of the independent beachfront boutiques in its data that achieves an estimated overall score over 90. Use the regression equation developed inQ4to determine which of the independent beachfront boutiques will receive a recommendation fromResorts & Spas. (you can use the predicted values in the output worksheet or the template given in worksheet "Estimates" and copy your work below).