All worked examplesWorked-example collection
Hospitality: hotel booking questions
One Algarve resort hotel and one Lisbon city hotel, Portugal.
2 questions · 1 source dataset · 10 languages
Questions in this collection
Hospitality
One Algarve resort hotel and one Lisbon city hotel, Portugal.
- Were bookings canceled more often at the city hotel or the resort?
3 × 2 table · N = 119,390
- What share of each hotel’s reservations carried the repeat-guest flag?
2 × 2 table · N = 119,390
Methods for these tables
Every question opens in the calculator with its exact counts. These methods fit the tables in this collection:
- Chi-square test of independence · fits 2 questions
- Cramér’s V · fits 2 questions
- Odds ratio (two-by-two tables) · fits 1 question
Teach or cite
A ready exercise: ask learners to choose the reading the first table supports, then compare the sibling question from the same dataset.
- Decision check
- Does the cancellation gap between the two hotels hold in each arrival year?Were bookings canceled more often at the city hotel or the resort?
- Cite this example
Nuno Antonio, Ana de Almeida and Luís Nunes (2019). Hotel booking demand datasets. Combined CSV distributed by Jesse Mostipak on Kaggle. Analysis: “Were bookings canceled more often at the city hotel or the resort?”. Crosstabs. https://www.crosstabs.com/examples/ht01-how-did-the-mix-of-canceled-no-show-and-checked-out-bookings-differ-between-the-two-hotels
How to cite Crosstabs
Sources and coverage
- Scope
- One Algarve resort hotel and one Lisbon city hotel, Portugal.
- Period
- Scheduled arrivals 1 July 2015 – 31 August 2017
- One record is
- one reservation, including canceled bookings
Data: Nuno Antonio, Ana de Almeida and Luís Nunes (2019). Hotel booking demand datasets. Combined CSV distributed by Jesse Mostipak on Kaggle.. Licensed under CC BY 4.0. Crosstabs selected, recoded and aggregated the records into this table.
Limits
Booking records from two properties only. They do not represent Portuguese hotel guests or the industry as a whole.