Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Statistical Reference Guide
  • Contingency tables
  • Inferences about independence

Testing independence

Test if two categorical variables are independent in a bivariate population represented by the sample.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Compare Groups, and then click the hypothesis test.
    The analysis task pane opens.
  3. In the X and Y drop-down lists, select the categorical variables.
  4. In the Hypotheses drop-down list, select the independence null and alternative hypotheses (the 2nd in the list).
  5. Optional: To compare the p-value against a predefined significance level, in the Significance level edit box, type the maximum probability of rejecting the null hypothesis when in fact it is true (typically 5% or 1%).
  6. Click Calculate.
Related concepts
Independence hypothesis test
Related reference
Dataset layout
Tests for independence
Available in Analyse-it Editions
Standard edition
Method Validation edition
Quality Control & Improvement edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Compare pairs
  •  Contingency tables
  •  Contingency table
  •  Creating a contingency table
  •  Creating a contingency table (related data)
  •  Grouped frequency plot
  •  Effect size
  •  Estimators
  •  Estimating the odds ratio
  •  Estimating the odds ratio (related data)
  •  Relative risk
  •  Inferences about equality of proportions
  •  Inferences about independence
  •  Independence hypothesis test
  •  Continuity correction
  •  Tests for independence
  •  Testing independence
  •  Mosaic plot
  •  Creating a mosaic plot
  •  Study design
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Reference interval
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Process capability
  •  Pareto analysis
  •  Study Designs
  •  Bibliography



Version 6.15
Published 18-Apr-2023
Products
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Support
  • Documentation
  • Tutorials
  • Download latest version
  • Release history
  • Contact support
Company
  • About us
  • Blog
  • Contact us
  • Privacy policy
Copyright 2026 Analyse-it Software, Ltd.
Statistical analysis and method validation software for Microsoft Excel.
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.