Determine the estimated multiple linear regression equation

Assignment Help Business Management

Reference no: EM133394965

Case Study: 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 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 variables comfort, amenities, and in-house dining can be found in worksheet "regression with 3 indep. vars" of the attached Excel file.

Questions:

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 in worksheet "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: Suppose Resorts & Spas has 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 in Q4 to determine which of the independent beachfront boutiques will receive a recommendation from Resorts & Spas. (you can use the predicted values in the output worksheet or the template given in worksheet "Estimates" and copy your work below).

Reference no: EM133394965

Questions Cloud

Briefly describe the needs of the person : Briefly describe the needs of the person, family, or carers during the palliative approach to health care in terms of a holistic assessment.

How has tom done on providing service to stu : How has Tom done on providing service to Stu? Explain. Could Tom have done anything differently?

How do you respond - about receiving the hpv vaccine : After the age of 20, the HPV vaccine is not recommended . You should not receive the vaccination while you are pregnant

What is the rationale for anemia seen throughout gestation : What is the rationale for anemia seen throughout gestation? Iron stores are depleted by the fetus It is difficult for the mother to consume as much iron

Determine the estimated multiple linear regression equation : 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

Explain how you would perform a manual assessment of blood : Explain how you would perform a manual assessment of blood pressure

What deming ring looks like on quality : What a Deming ring looks like on quality, with an example of a company that a Deming ring has influenced and hopefully added references

Explain exactly why contrast dye is harmful to kidneys : Explain exactly why contrast dye is harmful to kidneys and why kidney function test are obtained before CTA. Include references.

Explain what medications and treatment would be prescribe : Explain what medications and treatment would be prescribe and used for a patient with diabetes, hypertension and stage 2 kidney disease. And how to maintain

User Account

All Pages