Worked exampleE-commerce and retail
Did sessions near a special shopping day end in a purchase more often?
Sessions with recorded revenue, by special-day proximity: Near a special day (score above zero): 77 of 1,251 (6.2%). Not near a special day (score zero): 1,831 of 11,079 (16.5%). The share was 10.4 percentage points lower for Near a special day (score above zero).
The table
| Purchase in session \ Special-day proximity | Near a special day (score above zero) | Not near a special day (score zero) | Total |
|---|---|---|---|
| Revenue recorded | 776.2% | 1,83116.5% | 1,908 |
| No revenue recorded | 1,17493.8% | 9,24883.5% | 10,422 |
| Total | 1,251 | 11,079 | 12,330 |
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.
Did sessions near a special shopping day end in a purchase more often? — Crosstabs. https://www.crosstabs.com/examples/rq26-purchasing-near-special-shopping-days
Source
- Scope
- E-commerce website; country unspecified
- Period
- One-year sampling period; dataset released 2018. Calendar dates unspecified.
- One record is
- one recorded website session
Data: C. Sakar, Yomi Kastro. Online Shoppers Purchasing Intention Dataset. UCI Machine Learning Repository.. 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
Marketing calendars are built around special days. If sessions close to them convert better, the run-up deserves more spend; if not, traffic may rise without a matching rise in purchases.
How to read it
The source gives a continuous proximity score; here any score above zero counts as near a special day. Only 1,251 sessions are in that column, against 11,079 with a score of zero, so the near column rests on far fewer records.
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
Sessions near a special day ended in a purchase less often, by a moderate margin. The proximity score is tied to particular times of year, so month and other calendar differences can sit behind the gap. It is an association in these sessions, not a sign that special days put shoppers off.
Cramér’s V = 0.087. 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 Near a special day (score above zero) and Not near a special day (score zero), and only Revenue recorded against every other row, Cramér’s V = 0.087. That number describes this one contrast, not the whole table.
Limits
These are selected sessions from one website over one year. A recorded purchase is only yes or no: the file gives no order amount and no experimental assignment, so nothing here says what a change to the site would do. Turning the proximity score into a yes/no flag is a choice made for this lesson.