This data set compares various booking information between two hotels: a city hotel and a resort hotel. The records are from 1^stJuly 2015 to 31^stAugust 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.

1. Exhibit 1 below shows a pivot table for hotel bookings from July 2015 to August 2017.

Exhibit 1. arrival date year (All) Count of hotel Cancelled hotel No Yes Grand Total City Hotel 46228 33102 79330 Resort Hotel 28938 11122 40060 Grand Total 75166 44224 119390Exhibit 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 4 Statistics City Hotel Resort Hotel Mean 3852.33 2411.50 Median 4181 2421.5 Standard Deviation 1006.34 448.82 Minimum 2254 1868 Maximum 5381 3257 Range 3127 1389 First Quartile 2788 2022.25 Third Quartile 4525.75 2576 Interquartile Range (IQR) 1737.75 553.75 Coefficient of Variation (CV) 26.12 18.61