Guide
What is cross tabulation?
How results are checked
Named statistical review pending. Selected automated reference cases are published on the validation page.Cross tabulation example: restaurant prices by cuisine tag
Were restaurants tagged as fast food more likely to list low prices? In this Mexican restaurant study, each venue counts once. Read across the first row to see how many low-price venues fell into each group.
| Listed price | Fast-food tag | Other cuisine tags | Total |
|---|---|---|---|
| Low price | 2 | 32 | 34 |
| Medium or high price | 6 | 55 | 61 |
| Total | 8 | 87 | 95 |
Compare prices within each cuisine group using column percentages. Among fast-food-tagged venues, 2 of 8 (25%) listed low prices, compared with 32 of 87 (36.8%) among venues with other tags. Low prices were less common in the fast-food group in this sample, which had just 8 tagged venues.
Read the same cell as a row percentage. Of the 34 low-price venues, 2 carried the fast-food tag (2 ÷ 34 × 100 ≈ 5.9%). This answers a different question: among the low-price venues, how common was the tag?
Make your own cross tabulation
Have one row per respondent or observation? Open the crosstab maker or drop your file below. If you already have cell counts, enter them in the contingency table calculator.
Open a data file
CSV, Excel, SPSS, Stata, SAS or JSON. Build a crosstab with counts, percentages, and statistics.
Supported files and requirements
- CSV .csv .tsv .txt
- Excel .xlsx .xlsm .xls .xlsb
- SPSS .sav .zsav .por
- Stata .dta
- SAS .sas7bdat .xpt
- R .rds .rdata .rda
- Parquet .parquet
- JSON .json .jsonl .ndjson
- Triple-S .sss .xml .asc .dat
- OpenDocument .ods .fods
- Arrow/Feather .arrow .feather .ipc
- SQLite .sqlite .sqlite3 .db
Optional: a matching Qualtrics .qsf file adds question wording.
Triple-S: select the metadata file (.sss or .xml) and its data file (.asc, .dat or .csv) together.
Use one row per respondent's answers.
SPSS, Stata, CSV and Parquet files over 50 MB (up to 2 GB) open after you choose which columns to load.
Or try a realistic sample
Anatomy of a crosstab
Row variable
The variable displayed along the left-hand side. Conventionally the dependent variable (outcome) or the one you're profiling by.
Column variable (banner)
The variable displayed across the top — usually the independent variable or grouping factor (e.g., age group, region, segment).
Cell count
The number of respondents in that row-column combination. The raw count is the foundation of all other values.
Column percentage
Cell count divided by the column total. When each column is a group, this tells you what proportion of that group gave a particular answer.
Row percentage
Cell count divided by the row total. Useful when the row variable is the grouping factor, or when you want to show how a total breaks down by column.
Total (marginal)
Row totals and column totals show the distribution of each variable independently, without regard to the other variable.
Row vs column percentages — which to use?
The most common mistake in crosstab analysis is reading the wrong percentage. The rule of thumb: percentages should run in the direction of the grouping variable. If age is the column variable (your groups), use column percentages. That way you compare “among 18–24 year-olds, 45% prefer X” versus “among 55+ year-olds, 22% prefer X.”
Row percentages make sense when the row is the grouping variable, or when you want to describe the composition of a total. Never present both without making it crystal clear which you're showing — and never compare row percentages against column percentages in the same sentence.
The statistics in a crosstab
Chi-square (χ²)
Tests whether the distribution of responses differs significantly across groups. Gives a p-value. Doesn't tell you where the difference is or how large it is.
Chi-square calculator →Fisher's exact test
The preferred test when cell counts are small (expected count < 5). Gives an exact p-value directly from the hypergeometric distribution.
Fisher's exact test calculator →Cramér's V
Effect size — how strong is the association? Ranges 0 to 1. Always report alongside the p-value so readers know if a significant result is also meaningful.
Cramér's V calculator →Odds ratio
For 2×2 tables, the odds ratio with its 95% confidence interval quantifies the direction and magnitude of the association between exposure and outcome.
Odds ratio calculator →Adjusted standardised residuals
The chi-square test tells you the overall table is significant, but not which cells are driving the result. Adjusted standardised residuals (ASRs) answer that question. Each cell gets a residual that roughly follows a standard normal distribution: values beyond ±1.96 indicate that the cell is significantly over- or under-represented at α = 0.05.
Crosstabs highlights significant cells automatically. A positive ASR means more people fell into that cell than you'd expect by chance; a negative ASR means fewer. This is the fastest way to identify where in the table the story lives.
Key formulas at a glance
- Column %
- cell count / column total × 100
- Expected frequency
- E = (row total × column total) / grand total
- Chi-square
- χ² = ∑ (O − E)² / E
- Cramér's V
- V = √( χ² / (n × (min(r,c) − 1)) )
Questions
Frequently asked questions
How do you read a crosstab?
Read a crosstab by comparing percentages across the variable you treat as the predictor. Use row percentages to compare the column variable across rows, and column percentages to compare the row variable across columns; the cell counts show how many cases fall in each combination.
What is the difference between a row percentage and a column percentage?
A row percentage divides each cell by its row total (how the column variable is distributed within that row); a column percentage divides each cell by its column total (how the row variable is distributed within that column). Choose whichever matches the comparison you care about.
What is an adjusted residual in a crosstab?
An adjusted (standardized) residual measures how far a cell's observed count is from its expected count under independence. An absolute value greater than 1.96 flags a cell that departs significantly from independence at the 0.05 level.
Sources and next steps
References & further reading
- [1]Agresti, A. Categorical Data Analysis.
- [2]Contingency table — Wikipediaen.wikipedia.org