Assignment: Contingency Tables and Odds in Excel

  In the prerequisite succession, Quantitative Reasoning and Analysis, you pretended basic affluence (crosstab) consultations. You capacity be surprised to acquire that you can respect a primal logistic retirement pattern, after a while a peremptory predictor, using the illustrative values confer-uponed in the perversetab consultation. In this assignment, you use Microsoft Excel to form a specialized machine that begets basic logistic retirement patterns ardent a perversetab/affluence consultation. As if that were not beneficial ample, this Excel machine is not specialized—you can use it ardent any perversetab/affluence consultations you assault in exploration. In the province of statistical exploration, this is upright encircling as interesting as you can get! To prepare Review the sections in the Osborne quotation that confer-upon a template for forming an Excel worksheet. Review the video in the Learning Resources, in which Dr. Matt Jones explains how to hamper the jurisdiction of Excel using affluence consultations. Think encircling the types of variables that are beneficial for perverse tab consultations.   Using one of the datasets granted, fine two variables that assign you to form a 2×2 affluence consultation. Use SPSS to run the primal perversetab consultation, using any two variables that you ponder are alienate. Then, use Excel to form a consultation in which you report: Conditional probabilities Conditional odds Logits Odds ratios Relative risk Slope Be enduring to adduce the template from the Osborne quotation. Note that page 42 has a adequated issue that should succor you indicate these values. Be enduring to use formulas and cell references in Excel so that the spreadsheet you beget can be used as a machine for sagacious correspondent values for other datasets. Once you enjoy begetd the machine, transcribe a 1- to 2-paragraph analysis in APA format interpreting your results. Submit twain your Excel finish and your analysis to adequate this assignment.