# Teaching worksheet · HT01

## Were bookings canceled more often at the city hotel or the resort?

Revenue managers set overbooking and deposit rules per property. Cancellations and no-shows cost a hotel in different ways, so the final booking status has to be split into all three outcomes before the properties are compared.

- One record is — one reservation, including canceled bookings
- Period — Scheduled arrivals 1 July 2015 – 31 August 2017
- Scope — One Algarve resort hotel and one Lisbon city hotel, Portugal.

## The table

Canceled / Total

| Period | Resort Hotel | City Hotel |
| --- | ---: | ---: |
| 2015 · July–December | 2,069 / 8,314 | 5,882 / 13,682 |
| 2016 · January–December | 4,817 / 18,567 | 14,852 / 38,140 |
| 2017 · January–August | 3,945 / 13,179 | 11,452 / 27,508 |

## Does the cancellation gap between the two hotels hold in each arrival year?

1. Yes. The City Hotel share was higher in every arrival year.
2. The smaller gap in 2017 shows the two hotels converging.
3. The table shows that a city location causes more cancellations.

Choose one statement. Show the counts and denominators that justify it, then describe one limit of the comparison.

## Source

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](https://creativecommons.org/licenses/by/4.0/). Crosstabs selected, recoded and aggregated the records into this table.

- [Nuno Antonio, Ana de Almeida and Luís Nunes (2019). Hotel booking demand datasets. Combined CSV distributed by Jesse Mostipak on Kaggle.](https://doi.org/10.1016/j.dib.2018.11.126)
- [Reproduce it · HT01](https://www.crosstabs.com/examples/ht01-how-did-the-mix-of-canceled-no-show-and-checked-out-bookings-differ-between-the-two-hotels)
- [CSV](https://www.crosstabs.com/examples/ht01-how-did-the-mix-of-canceled-no-show-and-checked-out-bookings-differ-between-the-two-hotels/download/csv) · [JSON](https://www.crosstabs.com/examples/ht01-how-did-the-mix-of-canceled-no-show-and-checked-out-bookings-differ-between-the-two-hotels/download/json)
