Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This data set compares various booking information between two hotels: a city hotel and a resort hotel. The records are from 1 st July 2015
This data set compares various booking information between two hotels: a city hotel and a resort hotel. The records are from 1stJuly 2015 to 31stAugust 2017.
This database includes information such as when the booking was made, length of stay, the number of adults, children, and/or babies, and the number of available parking spaces, among other things. It is extracted from theHotel Booking Demand Datasets.
Exhibit 2. arrival date year (All) Cancelled No Count of hotel hotel arrival date month City Hotel Resort Hotel Grand Total January 2254 1868 4122 February 3064 2308 5372 March 4072 2573 6645 April 4015 2550 6565 May 4579 2535 7114 June 4366 2038 6404 July 4782 3137 7919 August 5381 3257 8638 September 4290 2102 6392 October 4337 2577 6914 November 2696 1976 4672 December 2392 2017 4409 Grand Total 46228 28938 75166Hotel Bookings (Monthly) 12% 11% 10% 9% 8% 7% 6% Percentage 5% 4% 3% 2% 1% 0% April May June July er January February March August October Septembe November Decemb Months City Hotel Resort HotelExhibit 11 Hotel Bookings 4000 3500 3000 2500 Number of bookings 2000 1500 1000 500 0 15 15 Aug-2015 Oct-2015 2016 2016 17 Sep-2015 Nov-2015 Jan-2016 Ju Dec- Feb-201 Apr-2016 y-201 Jun-2016 Sep-2016 Oct-2016 Jov-201 Feb-201 Apr-2017 20 lul- Mar-2017 Jun-2017 1-2017 Aug-2017 M May Aug- Dec Jan- May-. Ju Time Cancelled: No Cancelled: YesExhibit 12 SUMMARY OUTPUT Regression Statistics Multiple R 0.96386 R Square 0.92902 Adjusted R Square 0.86349 Standard Error 7.26288 Observations 26 ANOVA df SS MS F Significance F Regression 12 8974.90221 747.90852 14.17850 1.51317E-05 Residual 13 685.74305 52.74947 Total 25 9660.64527 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 64.935032 5.677657 11.436942 3.711E-08 52.669200 77.200863 Time (t) 1.780028 0.201747 8.823083 7.535E-07 1.344181 2.215876 Jan -6.953394 7.265684 -0.957018 0.356018 -22.649950 8.743163 Feb -3.902397 7.274082 -0.536480 0.600688 -19.617096 11.812303 March -1.573309 7.288057 -0.215875 0.832435 -17.318200 14.171582 April 18.531973 7.307578 2.535994 0.024842 2.744911 34.319035 May 25.007160 7.332599 3.410409 0.004648 9.166043 40.848277 June 20.825921 7.363065 2.828431 0.014233 4.918985 36.732856 July 16.343946 6.633143 2.463982 0.028455 2.013911 30.673981 August 23.878592 6.642341 3.594906 0.003264 9.528686 38.228497 September 31.017773 7.288057 4.255973 0.000937 15.272882 46.762664 October 18.573424 7.274082 2.553370 0.024039 2.858725 34.288123 November -1.566347 7.265684 -0.215582 0.832660 -17.262904 14.130209Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started