The Keener Hotel in Tampa, Florida, is a luxury hotel that has 414 rooms. The hotels controller

Question:

The Keener Hotel in Tampa, Florida, is a luxury hotel that has 414 rooms. The hotel’s controller imported its monthly occupancy data from the past several years into Excel. The data includes month, year, room nights sold, average monthly high outdoor temperature, and monthly occupancy costs. Management would like to be able to predict monthly occupancy costs.

The following is an example of the records in that Excel file. Access the full data set online in the MyLab Accounting exercise.


Requirements
1. Perform a simple linear regression using Room nights sold as the independent variable and Occupancy costs as the dependent variable.
2. Perform a multiple regression using Room nights sold and Average monthly high temperature as the independent variables and Occupancy costs as the dependent variable.
3. Assume that management expects to sell 10,500 room nights in a month when the average daily high outdoor temperature is expected to be 78 degrees. Predict the hotel’s occupancy costs for the month using the output for the multiple regression that you created in Requirement 2.
4. Between the simple linear regression and the multiple regression that you created for Requirements 1 and 2, which regression model is a better predictor of monthly occupancy costs? How do you know?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: