Skip to content
Open navigation
OpenOpen workspace

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 by property. Percentages use each property’s reservations as the base.
Repeat-guest flag \ PropertyResort HotelCity HotelTotal
Repeat-guest flag1,7784.4%2,0322.6%3,810
No repeat-guest flag38,28295.6%77,29897.4%115,580
Total40,06079,330119,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

  1. 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.

  2. 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.

    Download these counts: CSVJSON

  3. 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.

Keep exploring