Question 3

You were recently hired by Corsica Worldwide Holdings (CWH) as general manager of The Capri, a five-star hotel owned by CWH. The senior management at CWH wants you to assess the hotel’s business and develop a business strategy to reduce cancellations or no-shows. You have been given a tight deadline to draft a business proposal.

As general manager, one of the things you set out to do is to analyze and interpret the hotel’s booking data. You want to gain insights into the booking behaviors of your customers, and hopefully, identify where the cancellations are taking place and how to reduce them. The data on The Capri’s bookings can be found in ANL321_TMA_hotel.csv.

Using the appropriate statistical tools, conduct an exploratory data analysis on The Capri’s booking data. Write a short report, not exceeding 1000 words excluding figures and tables,

with the heading “A Report on The Capri and Possible Business Strategies”. Your exploratory data analysis should provide the senior management an overview of the business at The Capri as well as insights on the hotel’s guests and booking attributes, such as what the busiest months are, which market segments do the guests come from, etc.

Your report should also provide insights on cancellations at The Capri. Within your report, craft a proposal to the senior management to explain your strategies on how a reduction on cancellations can be achieved. Regression analysis is not required for this report.

Your report will be assessed based on several factors: discussion of the hotel’s business, the quality of writing (e.g. structure, coherence, argumentation, etc.), exploratory data analysis and business recommendations.