This data set compares various booking information between two…
Question Answered step-by-step This data set compares various booking information between two… This data set compares various booking information between two hotels: a city hotel and a resort hotel. The records are from 1st July 2015 to 31st 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 Datasets. Exhibit 1 below shows a pivot table for hotel bookings from July 2015 to August 2017.Image transcription textExhibit 1. arrival date year (All) Count ofhotel Cancelled hotel No Yes GrandTotal City Hotel 46228 33… Show more… Show more(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. 2. Exhibit 2 below shows a pivot table for hotel bookings which were not cancelled from July 2015 to August 2017, presented on a monthly basisImage transcription textExhibit 2. arrival date year (All)Cancelled No Count of hotel hotel arrivaldate month City Hotel Reso… Show more… Show more(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? 3. Exhibit 3 below shows a chart for hotel bookings which were not cancelled from July 2015 to August 2017.Image transcription textHotel Bookings (Monthly) 12% 11% 10%9% 8% 7% 6% Percentage 5% 4% 3%2% 1% 0% April May June… Show more… Show more(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 City and the Resort hotels for either of the two months. 4. In Exhibit 4 we outline some summary statistics of hotel bookings across the City and Resort hotelsImage transcription textExhibit 4 Statistics City Hotel ResortHotel Mean 3852.33 2411.50 Median4181 2421.5 Standard Dev… Show more… Show more(i). Describe the shape of the city and resort hotel variables. Give an explanation with values as evidence in your answer. (ii). Using two measures, discuss in context the central tendency of the Hotel booking for both City and Resort Hotels. (iii). To describing the variation of data, interpret the IQR and the Coefficient of Variation (CV) of the Resort hotel bookings. State with reasons which is best; IQR or CV measures is the best when comparing the variables of the City hotel and the Resort hotels. Math Statistics and Probability ETW 1001 Share QuestionEmailCopy link Comments (0)
