Contingency Tables and Odds in Excel

/in /by

Contingency Tables and Odds in Excel

Using one of the datasets (will be provided), select two variables that allow you to construct a 2×2 contingency table. Use SPSS to run the initial crosstab table, using any two variables that you think are appropriate. Then, use Excel to construct a table in which you report:

  • Conditional probabilities
  • Conditional odds
  • Logits
  • Odds ratios
  • Relative risk
  • Slope

Additional Directions: Be sure to apply the template (attached) and, use formulas and cell references in Excel so that the spreadsheet you create can be used as a tool for calculating similar values for other datasets. I have also attached an Excel file example here that will help you—feel free to use this and fill out based on your analyses so you don’t have to recreate the formulas etc.

Once you have created the tool, fill out all sections of the stats assignment template (attached).