Statistics add-in software for statistical analysis in Excel
  • Tutorials

Association in 2-way contingency tables tutorial

Learn how to test for association between two categorical variables, and reorganize the categories to emphasize the pattern of association.

Snee collected data on the hair color and eye color of 592 students on a statistics course. The question is how to understand the association between the two variables. For more information see Story: Patterns of Association.

In this tutorial you will perform the following tasks:

  1. Cross tabulation of the data
    Create a contingency table and test the hypothesis of independence.
  2. Displaying patterns of association
    Add a mosaic plot to display the pattern of association.
  3. Reordering data
    Reorder the categories to emphasize the pattern and uncover the relationship.

  •  Tutorials
  •  Distribution tutorial
  •  Correlation / PCA tutorial
  •  Compare groups means tutorial
  •  Association in 2-way contingency tables tutorial
  •  Cross tabulation of the data
  •  Displaying patterns of association
  •  Reordering data
  •  Simple linear regression tutorial
  •  Bland-Altman method comparison tutorial
  •  Estimating the precision of a measurement procedure (CLSI EP05-A3)
  •  Evaluating the linearity of a measurement procedure (CLSI EP06-A)
  •  Verifying the precision of a measurement procedure against a performance claim and estimating the bias (CLSI EP15-A3)
  •  Pareto charts tutorial
  •  Process control charts tutorial
  •  Process capability tutorial



Version 6.15
Published 18-Apr-2023
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.