Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Contingency tables

Estimating the odds ratio (independent data)

Estimate the odds ratio.

  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 Odds Ratio.
    The analysis task pane opens.
  3. In the Y drop-down list, select the first categorical variable.
  4. In the X drop-down list, select the second categorical variable.
  5. If the data are in frequency form, in the Frequency drop-down list, select the frequency count variable.
  6. In the Ratio drop-down list, select the ratio of interest, and in the Event drop-down list, select the outcome of interest.
  7. In the Confidence interval edit box, type the confidence level as a percentage, or type - to suppress the confidence interval, and then in the drop-down list, select the confidence bounds.
  8. In the Method drop-down list, select the interval estimator.
  9. Click Calculate.
Related concepts
Effect size
Related tasks
Estimating the odds ratio (related data)
Related reference
Dataset layout
Estimators
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
  •  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.