Data Backgroutd: Hotel bookings This data set compares various booking information between two hotels: a city hotel and a resort hotel. The records are from 1at July 201 5 to 31at August 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 the Hotel Booking Demand Data-sets. a) Exhibit 1 below shows a pivot table for hotel bookings from Julyr 2015 to August 201 7. 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 119390 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 75166(i). Is it correct to compare the total number of cancellations across the hotels (city and resorts)? Explain your answer. (ii). Will it be correct to conclude that the percentage of individuals who cancelled city hotels is higher than those who did not cancel resort hotels? Explain your answer. b) Exhibit 2 below shows a pivot table for hotel bookings which were not cancelled from July 2015 to August 2017, presented on a monthly basis(i). Based on the fact that the data recorded was from July 2015 until August 2017, explain why we have the largest numbers in the months of July and August? (ii). Do you agree that the issue in part i above does not cause any sort of biasness? Give explanation to your answer. What would you do to correct this problem?Hotel 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 Hotel(i). What is the type of chart in Exhibit 3? (ii). From the chart in Exhibit 3, apart from July and August, which are the two busiest months in the year for hotel bookings? Give the percentage approximations for the E and the Resort hotels for either of the two months