# Answer key · 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.

## The figures behind the check

- **1. Supported.** Over all arrivals, 40.6% of City Hotel bookings and 27.0% of Resort Hotel bookings were canceled. Split by arrival year, the City Hotel share was higher by 18.1, 13.0 and 11.7 percentage points in 2015, 2016 and 2017.
- **2. Not supported.** 2017 covers arrivals only from January to August, and 2015 only from July to December. These edge years miss different seasons, so a smaller gap there is not like-for-like with the full year 2016.
- **3. Not supported.** The hotels differ in location, guest mix and booking channels, and none of that is held constant here. The table describes recorded bookings; it does not explain them.

- Arrival coverage: July 2015 to August 2017; only 2016 has all twelve months.
- Canceled share over all arrivals: City Hotel 40.6%, Resort Hotel 27.0%.
- Gap by arrival year, City Hotel minus Resort Hotel: 2015 18.1, 2016 13.0, 2017 11.7 percentage points.

Quote the direction with its arrival coverage, July 2015 to August 2017, and label 2015 and 2017 as partial years whenever yearly gaps are compared.

## Limits

Booking records from two properties only. They do not represent Portuguese hotel guests or the industry as a whole.

## 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)
