andard deviation of differences, and the desired power (typically 80%). For a kaizen study where you expect a 10% improvement with moderate variability, 20–30 pairs typically gives adequate power. Use a sample size calculator to plan your study."}}]}
Complete guide
Cross Tabulation Guide
Cross tabulation is the standard way to summarise the relationship between two categorical variables. Add a chi-square goodness-of-fit test and you can also check whether a single set of category counts matches the proportions you expected — turning a simple table into a statistical conclusion.
What it is
What is cross tabulation?
A cross tabulation (or contingency table) counts how many observations fall into each combination of two categorical variables — for example shift (day/night) against outcome (pass/fail). Adding row, column or total percentages turns raw counts into comparable proportions, making patterns and associations easy to read at a glance.
Calculation logic
How the calculation works
The cross-tab simply tallies how many times each combination of labels occurs, then adds up row, column and grand totals and turns them into percentages so you can compare groups fairly. The goodness-of-fit test goes further: it compares the counts you observed against the counts you expected from a target split, and measures the gap as a chi-square statistic. A small p-value (below 0.05) means your observed counts do not match the expected pattern — something is different from what you assumed.
Worked example
Worked example: which team has the most rework?
A supervisor counts rework jobs for three assembly teams over a month. Team A: 12 rework out of 100. Team B: 25 out of 100. Team C: 8 out of 100. A Chi-Square test on the table gives p = 0.001.
Team B's rate is more than three times higher than Team C's — and the test confirms it's not chance.
What to do with this: Share Team C's best practices with Team B and track whether the rework rate drops over the next month.
Why it matters
Operational impact
Categorical data is everywhere — pass/fail, defect type, shift, supplier, region. Cross tabulation organises it so you can compare groups fairly, while goodness-of-fit tells you whether an observed mix departs from a target or historical pattern. Together they turn tallies into decisions about where to act.
Decision making
When to use it
Build a cross-tab whenever you want to compare the distribution of one category across the levels of another. Use goodness-of-fit when you have one categorical variable and a clear expectation — equal proportions, a published benchmark, or last year's mix — and want to test whether this period's counts still fit it.
Lean Six Sigma
Link to Six Sigma
Cross tabulation is a core Measure and Analyse tool for attribute data. It feeds Pareto analysis, stratification, and chi-square tests of independence, helping teams find which categories drive defects and whether differences between groups are real or just noise.
Industry examples
Where cross tabulation is used
ManufacturingCross-tab defect type against shift or line, or test whether the mix of defect categories matches the historical baseline.
HealthcareTabulate treatment against outcome, or check whether admissions by day of week fit an expected even spread.
Market researchCross-tab survey responses by demographic segment, with row or column percentages to compare groups fairly.
Service & operationsTest whether complaint categories or channel usage fit the expected proportions across a period.
Common mistakes
Common cross-tabulation mistakes
- Using percentages instead of raw counts in the table — always start with counts before converting to percentages.
- Calculating row percentages when you should use column percentages, or vice versa — think about which variable is the cause and which is the effect before deciding.
- Interpreting a pattern in the table as meaningful without running a significance test — what looks like a difference might just be chance variation.
- Combining categories that behave very differently just to get bigger numbers — this can hide the real pattern.
- Forgetting that a cross-tab only shows association, not causation — two things being related doesn't mean one causes the other.
What to do next
After you have the table
If the goodness-of-fit test is significant, identify which categories contribute most to χ² and target them for investigation. Combine cross-tabs with a Pareto chart to prioritise, and with a chi-square test of independence when you want to test the association between two variables rather than fit to fixed proportions. Document the table in your Analyse phase as evidence for the vital few causes.
Resources
Templates, videos and learning
Pair cross tabulation with chi-square tests, Pareto analysis, and a DMAIC project structure to find and prove the vital few causes.
Frequently asked questions
What is the difference between a cross tabulation and a chi-square test?
A cross tabulation (cross-tab) is a summary table that shows the counts of observations for every combination of two categorical variables, usually with row, column and total percentages. It is purely descriptive — it organises and displays the data. A chi-square test goes a step further and tests whether the pattern in the table is statistically significant, comparing observed counts to the counts expected under independence. You typically build the cross-tab first to see the picture, then run a chi-square test of independence to confirm whether an apparent association is real.
What is a goodness-of-fit test?
A chi-square goodness-of-fit test checks whether a single set of observed category counts matches a set of expected proportions. You supply the observed counts and the proportions you expect (for example equal proportions, or a historical mix), and the test computes χ² = Σ(O−E)²/E with degrees of freedom equal to the number of categories minus one. A low p-value means the observed counts depart significantly from the expected proportions — the data does not fit the expected pattern.
What is the difference between row and column percentages?
A row percentage expresses each cell as a proportion of its row total, so the percentages across each row add to 100% — useful for comparing the distribution of the column variable within each row. A column percentage expresses each cell as a proportion of its column total, so each column adds to 100% — useful for comparing rows within each column. A total (or overall) percentage expresses each cell as a proportion of the grand total. Choose the direction that matches the question you are asking.
What are expected counts and why do they matter?
In a goodness-of-fit test the expected count for a category is the total number of observations multiplied by its expected proportion. In a contingency-table chi-square test it is (row total × column total) / grand total. Expected counts matter because the chi-square approximation works well only when they are reasonably large — the common rule of thumb is that expected counts should be at least 5. If several expected counts fall below 5, combine categories, collect more data, or use an exact test instead.