Contingency Tables and Odds in Excel

Anonymous
account_balance_wallet \$15

Question description

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

Difficulty concentrating or remembering Gender Male Female Total No Yes 523 1098 1621 Total 84 230 314 Conditional Conditional Probability Odds Logit Odds Ratio Slope 607 0.1383855 0.16061185 2.152752 0.766747 0.50576 1328 0.17319277 0.20947177 1935 1.3042111 Risk Ratio 0.799026

Prof Befly
School: Purdue University

There you go bro, Have a...

flag Report DMCA
Review

Anonymous
Outstanding Job!!!!

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors