Assignment: Contingency Tables and Odds in Excel

/in /by

Assignment: Contingency Tables and Odds in Excel

To prepare for this assignment

  • Review the sections in the Osborne text that present a template for constructing an Excel worksheet.
  • Review the video in the Learning Resources, in which Dr. Matt Jones explains how to harness the power of Excel using contingency tables.
  • Think about the types of variables that are useful for crosstab tables.

Using one of the datasets 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

Be sure to apply the template from the Osborne text. Note that page 42 has a completed example that should help you determine these values. Be sure to 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.

Once you have created the tool, write a 1- to 2-paragraph summary in APA format interpreting your results. Submit both your Excel file and your summary to complete this assignment.