Question: Using data from existing La Quinta hotels, I have built a regression model to predict the operating margin of a given hotel. My independent variables

Using data from existing La Quinta hotels, I have

Using data from existing La Quinta hotels, I have

Using data from existing La Quinta hotels, I have built a regression model to predict the operating margin of a given hotel. My independent variables are as follows: College (# of students enrolled in nearby college(s), Hosp1 (# of hospital beds within 1 mile of hotel), Access (Accessibility on a scale of 0-10, with 10 being the best), Artery (0/1 variable with 1= major traffic artery, 0= not a major traffic artery), Rate (avg room rate of competitive hotels), and Nearest (distance, in miles, to nearest La Quinta Inn). The summary statistics from my regression are as follows: Regression Statistics Multiple R 0.77216 R Square 0.59623 Adjusted R Square 0.54576 Standard Error 20.3511 Observations 55 ANOVA df F 11.81342 Significance F 4.29876E-08 6 MS 4892.71 414.165 Regression Residual Total SS 29356.25 19879.94 49236.19 48 54 nts Intercept COLLEGE HOSP1 ACCESS ARTERY RATE NEAREST Coefficie Standard Error t Stat 10.1189 18.36256 0.55106 0.00097 0.000554 1.75521 0.08393 0.017068 4.91754 2.90629 1.030611 2.81997 - 16.9878 5.824052 -2.91683 0.07158 0.374667 0.19106 -0.35521 0.088545 -4.01167 P-value 0.584146 0.085604 1.07E-05 0.006961 0.005364 0.849284 0.00021 Upper Lower Upper Lower 95% 95% 95.0% 95.0% -26.80145638 47.0393 -26.8015 47.03933 -0.000141536 0.00209 -0.00014 0.002087 0.049615033 0.11825 0.049615 0.11825 0.834110207 4.97847 0.83411 4.978474 -28.69783111 -5.27775 -28.6978 -5.27775 -0.681734055 0.8249 -0.68173 0.824902 -0.533244009 -0.17718 -0.53324 -0.17718 Which of the predictor variables (independent variables) are statistically significant? (Choose all that apply) College Hosp1 Access Artery Rate Nearest None are statistically significant QUESTION 3 What percentage of variation in operating margin is attributable to variation beyond what our independent variables can predict? 5% 22.8% 45.4% 54.5% 59.6% 77.2% 95%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!