Contingency Tables and Odds in Excel

/in /by

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:

Get Your Custom Essay Written From Scratch

We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.

Get Answer Over WhatsApp Order Paper Now

Just from $13/Page

  • 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).

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now