Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Contingency tables
  • Inferences about equality of proportions

Testing equality of proportions (independent samples)

Test if there is a difference between the proportions of two or more independent samples.

  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 Y drop-down list, select the categorical response variable.
  4. In the X drop-down list, select the categorical factor variable that identifies the groups.
  5. If the data are in frequency form, in the Frequency drop-down list, select the frequency count variable.
  6. In the Hypotheses drop-down list, select the null and alternative hypothesis.
  7. 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%).
  8. Click Calculate.
Related concepts
Equality of proportions hypothesis test
Related tasks
Testing equality of proportions (related samples)
Related reference
Dataset layout
Tests for equality of proportions (independent samples)
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
  •  Equality of proportions hypothesis test
  •  Exact and asymptotic p-values
  •  Wald, Score, Likelihood ratio
  •  Tests for equality of proportions (independent samples)
  •  Testing equality of proportions (independent samples)
  •  Tests for equality of proportions (related samples)
  •  Testing equality of proportions (related samples)
  •  Inferences about 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
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.