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."}}]}
HomeTemplatesCalculatorsVideosAcademySoftwareAboutContactLogin
Tables

Cross Tabulation Calculator

Summarise categorical data in a cross-tab with row, column and total percentages, or run a chi-square goodness-of-fit test against expected proportions — all client-side.

Was this useful?

Data entry

Paste raw observations (one per row)
Enter one category per line
Same number of values as the row column

Ready to tabulate

Paste your categorical data and press Calculate to build the cross-tab or run the goodness-of-fit test.

Simulation Lab

Cross-Tab & Goodness-of-Fit

You have two yes/no or category questions and want to know if they move together. Enter the lab to build the cross-tab and test whether the categories are related.

How cross tabulation works

1

Paste your data

For a cross-tab, paste two columns of category labels where row 1 of each belongs to the same item. For goodness-of-fit, paste one column of counts and (optionally) the percentages you expect.

2

Counts and percentages

The calculator counts how often each category combo appears and figures out percentages (by row, by column, or overall). For goodness-of-fit, it also calculates how many you'd expect in each category if your specified pattern were true.

3

Chi-square and p-value

It compares what you actually got to what was expected, and turns the size of that gap into a p-value — telling you whether your data genuinely differs from the expected pattern, or is close enough to be normal variation.

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.

Next steps

Turn insight into action

A cross-tab shows where the differences lie; a goodness-of-fit test confirms they are real. Structured training shows you how to act on what the categories reveal.

Explore Lean Six Sigma Training
Learn categorical analysis, chi-square testing, and project leadership with structured training.
Get the DMAIC Assistant
Step-by-step project guidance for improvement teams.
FreeTemplates & Toolkits
Free Lean and Six Sigma templates, checklists, and tools.

Want to test relationships between categorical variables inside a structured improvement project? The Black Belt course covers advanced statistics, hypothesis testing, and the full analytical toolkit.

View Black Belt →