Worked exampleHospitality
What share of each hotel’s reservations carried the repeat-guest flag?
Reservations flagged as a repeat guest, by property: Resort Hotel: 1,778 of 40,060 (4.4%). City Hotel: 2,032 of 79,330 (2.6%). The share was 1.9 percentage points higher for Resort Hotel.
The table
| Repeat-guest flag \ Property | Resort Hotel | City Hotel | Total |
|---|---|---|---|
| Repeat-guest flag | 1,7784.4% | 2,0322.6% | 3,810 |
| No repeat-guest flag | 38,28295.6% | 77,29897.4% | 115,580 |
| Total | 40,060 | 79,330 | 119,390 |
Count / Column %. Each column total is the base for that column’s percentages.
Shaded cells are the two shares the answer compares.
Use this result
Reproduce it
Open these exact counts in the chi-square calculator. It loads the same table, with the same category order, and computes the percentages, χ² and Cramér’s V in your browser. Change a cell to see how the result moves.
Cite it
Copy this reference. The data credit and licence below travel with it.
What share of each hotel’s reservations carried the repeat-guest flag? — Crosstabs. https://www.crosstabs.com/examples/ht02-what-share-of-reservations-were-flagged-as-repeat-guests-at-each-property
Source
- 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.
Run it on your file
Open a CSV, Excel or SPSS file to build the same kind of table. The file is read in this browser tab: nothing is uploaded and no account is needed.
Run a crosstab on your own data
Why ask this
Loyalty and CRM teams want to know how much of each property’s business comes back. The flag is the cheapest signal of returning business in a booking system, so it is worth knowing how often each hotel records it.
How to read it
Read down each column. The flagged row is thin at both hotels: 1,778 resort and 2,032 city-hotel reservations. The city hotel has about twice as many reservations in total (79,330 against 40,060), so compare shares, not counts.
Column percentages answer “within each column, how often does each row occur?”. Switch to row percentages and the question turns around: “of the records in this row, how were they split across the columns?”. Both are correct; they answer different questions, so say which one you used.
What it means
The resort had a slightly higher share of flagged reservations, a gap of 1.9 percentage points on small shares at both hotels. That describes the two booking systems’ records; it does not say one hotel earns more loyalty.
Cramér’s V = 0.050. It summarizes the whole table, all 2 × 2 categories, on a scale from 0 (no association) to 1. It does not say which cells differ, and it is not a measure of impact.
Comparing only Resort Hotel and City Hotel, and only Repeat-guest flag against every other row, Cramér’s V = 0.050. That number describes this one contrast, not the whole table.
Limits
The flag is a property of each reservation, not a count of people: one returning guest with several bookings is counted several times. Booking records from two properties only. They do not represent Portuguese hotel guests or the industry as a whole.