Answers
a) Dependent variable: Hotal Bill (HB)
Following are the independent variables
No. of people in hotel: AA,
No. of rooms in hotel: AB
Hotel age: AC,
No. of beds in a hotel room:AD,
Internet connection: AE
Availablility of washroom in a room: AF
Distance from hotel to airport: AG
Traveller type: AH
b) Hotel bill is to be predicted by the traveller hence it is a dependent variable.
The other variables are the predictor variables or the independent variables that will help determine the Hotel Bill.
c) This may not be a case study to the complete extent since it misses the final report of the analysis.
d) Availability of washroom in a room: AF is the only variable which is significant at 1% level.
e) From the correlation table, Number of people in hotel (AA) had the weakest correlation with HB.
f) The model has a R2 value of 38, which means the independent variables explain only 38% of the variance, which does not seem to be very good.
g) Adjusted R2 is 31.4 and R2 is 38. The not so high difference in the 2 values imply that most of the independent variables are significant in the model .
.