Question: lead time # at days that elapsed between the date of the booking and the date of arrival, integer value between [0, 504] Quarter of

lead time # at days that elapsed between the datelead time # at days that elapsed between the datelead time # at days that elapsed between the datelead time # at days that elapsed between the date
lead time # at days that elapsed between the date of the booking and the date of arrival, integer value between [0, 504] Quarter of the arrival date, four categories: Q1, Q2, Q3, and Q4. rarival art of month Part of the month of the arrival date, three categories: Early (1111 to 10'\"), Mid (11th to 20'"), Late (21th to the end] stays in weekend nights # at weekend nights (Saturday or Sunday) the customer stayed or booked to stay at the hotel, three values: 0, 1,2 stays in week nights it at weeknights (Monday to Friday] the customer stayed or booked to stay at the hotel, six values: 0, 1, 2, 3, 4, 5 w it at children, four values: 0, 1, 2, 3 distribution channel The customer booked the hotel through which channel. There are four different channels: a Corporate through corporate, such as business travel; a Direct by the customer self; - GDS - through the hotel Global Distribution System. (305 is a worldwide conduit between travel bookers and suppliers; TA/TO TA is short for \"'l'ravel Agents\" and TO isshort for \"Tour Operators\" total of special reguests # 91: special requests made by the customer (e.g. twin bed, ocean View room or garden View room), six values:0, 1, 2, 3, 4, 5 is canceled If the booking was canceled (1) or not (0) (a) Describe the business objective and data mining objective of the given business problem. Appraise whether the Association Rule Mining method is appropriate to study this problem. (10 marks) is repeated guest If the booking was from a repeated guest (1) or not (0) booking changes # 9i cha nges/amendments made to the booking from the moment the booking was made until the moment of check-in or cancellation, six values: 0, 1, 2, 3, 4, 5 Indicates if the customer made a deposit to guarantee the booking. There are three categories: 0 No Deposit no deposit was made; 0 Non Refund a deposit was made in the value of the total stay cost; - Refundable a deposit was made with a value under the total cost of the stay. customer type The type of booking. There are four categories: 0 Contract when the booking has an allotment or other type of contract associated with it; 0 Group when the booking is associated with a group; Transient when the booking is not part of a group or contract and is not associated with other transient bookings; - Transient-party when the booking is transient butis associated with at least other transient bookings reguired car parking spaces # 9:! car parking spaces required by the customer Question 1 A research study reported that one in ve hotel bookings are canceled before the guest arrives at the hotel. A last-minute cancellation or no-show means the room would be left unoccupied, which results in a loss of revenue for the day. Even if the hotel manages to sell the room again, it would probably be at a much lower rate because it is too near to the check-in date. For a hotel, a high cancellation ratio not only impacts the revenue but also leads to poor marketing and low market share. To improve business, the marketing manager of hotel H would like to learn more about the booking cancellation issue. As a data analyst in the marketing department, you are given a relevant dataset Hotel_Booking_Cancellation.csv, which contains a total of 2,417 hotel booking records. Your job is to help the hotel understand the possible factors that would affect the booking cancellation and assist your manager in evaluating the usefulness of the constructed models for the given problem. The details of the dataset are as following

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!