assignment: contingency tables and odds in excel


Report Issue

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!

To prepare

  • 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
  • Logits
  • Odds ratios
  • Relative risk
  • Slope

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.