Skip to content
Open navigation
OpenOpen workspace

Guide

What is cross tabulation?

Cross tabulation groups observations by two categorical variables and counts how many fall into each combination. The result is a crosstab, also called a contingency table. One variable supplies the rows and the other supplies the columns.
Published by crosstabs.com · Last updated ·
How results are checkedNamed 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.

Number of venues by listed price and cuisine tag (n = 95)
Listed priceFast-food tagOther cuisine tagsTotal
Low price23234
Medium or high price65561
Total88795

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?

Explore the restaurant price data and its limitations.

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.