Question

Data for Question 2 Regression Analysis R2 0.867 Adjusted R2 0.855 R 0.931 Std. Error 24.394 n 36 k 3 Dep. Var. Occupancy ANOVA table F 69.74 Source SS Regression 124.502. 1993 Residual 19.042.1063 Total 143,544.3056 MS 41,500.7331 595.0658 p-value 3.97E-14 df 3 32 35 confidence interval 95% lower std. error t(df=32) p-value 95% upper Regression output variables Intercept Airport Arrivals Number of Advance Bookings Promo By Competitor coefficients -96.1243 0.1364 0.4082 -9.7830 0.0127 0.0998 11.0444 10.697 4.090 -0.886 0.1104 0.2049 -32.2798 0.1623 0.6115 12.7137 2. A hotel manager wants to be able to predict her property's occupancy. So, she gathered data over a three-year period about how many people arrived at the local airport ("Airport Arrivals"); how many advance bookings her hotel received ("Number of Advance Bookings"), and whether or not a major competitor ran a promo during a particular month (“Promo By Competitor”). Promo By Competitor has a value of “l” if the competitor ran a promo during the period, and a value of “0” otherwise. She runs a regression using these data, and the results appear in the table above. Use the regression output above to answer the questions below: (12 points total; 4 points each) (A) Is there a statistically significant relationship between Occupancy, and Daily Arrivals, Number of Advance Bookings, and Promo By Competitor? Yes No (B) Does Daily Arrivals have a statistically significantly relationship with Occupancy? Yes ONO (C) Does Promo By Competitor have a statistically significantly relationship with Occupancy?? Yes ON

ONLY CHOOSE YES OR NO. DON'T SHOW THE WORK PROGRESS. THANKS

Answer 1

Given:

A hotel manager wants to be able to predict her property's occupancy. So, she gathered data over a
three-year period about how many people arrived at the local airport.

(A) Is there a statistically significant relationship between Occupancy, and Daily Arrivals, Number of Advance Bookings, and Promo By Competitor?

Answer - Yes

(B) Does Daily Arrivals have a statistically significantly relationship with Occupancy?

Answer - Yes

C) Does Promo By Competitor have a statistically significantly relationship with Occupancy?

Answer - No