assignment: contingency tables and odds in excel
In the prerequisite route, Quantitative Reasoning and Analysis, you constrained basic affluence (crosstab) consultations. You dominion be surprised to imbibe that you can value a artless logistic retreat pattern, delay a positive predictor, using the pictorial values introduceed in the ill-conditionedtab consultation.
In this assignment, you use Microsoft Excel to erect a specialized implement that generates basic logistic retreat patterns fond a ill-conditionedtab/affluence consultation. As if that were not suited ample, this Excel implement is not specialized—you can use it fond any ill-conditionedtab/affluence consultations you combat in learning. In the arena of statistical learning, this is reasonable environing as thrilling as you can get!
- Review the sections in the Osborne extract that introduce a template for erecting an Excel worksheet.
- Review the video in the Learning Resources, in which Dr. Matt Jones explains how to bind the influence of Excel using affluence consultations.
- Think environing the types of variables that are suited for ill-conditioned tab consultations.
Using one of the datasets granted, fine two variables that sanction you to erect a 2×2 affluence consultation. Use SPSS to run the primal ill-conditionedtab consultation, using any two variables that you conceive are alienate. Then, use Excel to erect a consultation in which you report:
- Conditional probabilities
- Conditional odds
- Odds ratios
- Relative risk
Be stable to adduce the template from the Osborne extract. Note that page 42 has a consummated illustration that should succor you individualize these values. Be stable to use formulas and cell references in Excel so that the spreadsheet you generate can be used as a implement for sagacious congruous values for other datasets.
Once you possess generated the implement, transcribe a 1- to 2-paragraph epitome in APA format interpreting your results. Submit twain your Excel perfect and your epitome to consummate this assignment.
I would deficiency you to login into my statement for my datasets.