Problem 1: Cost Data Analysis A data set named Cost Data.xlsx is attached to this problem set. Download this dataset and use regression analysis to analyze the cost data contained in the data set. Estimate the following regression using the data analysis tool in Excel (or a similar statistical package): Cost = 0 + 1ChainSegmentNum + 2AvailableNights + 3Occupied +

Run separate regressions for each of 5 expense categories: Rooms Expense, Other Operating Expense, AandG Expense, Maintenance Expense, and Utility Expense. Save and label the output from these regressions in an Excel spreadsheet to be turned in with the assignment.

For each regression, interpret the output and give your assessment of whether the results make sense. If, for example, you find that higher chain segment hotels have higher costs of some type (or lower, perhaps), explain if that is reasonable to you and why or why not.