Be on schedule.Score better.


Assignment: Contingency Tables And Odds In Excel

In the prerequisite course, Quantitative Reasoning and Analysis, you constructed basic contingency (crosstab) tables. You might be surprised to learn that you can estimate a simple logistic regression model, with a categorical predictor, using the descriptive values presented in the crosstab table.

In this assignment, you use Microsoft Excel to construct a specialized tool that creates basic logistic regression models given a crosstab/contingency table. As if that were not useful enough, this Excel tool is not specialized—you can use it given any crosstab/contingency tables you encounter in research. In the field of statistical research, this is just about as exciting as you can get!

To prepare

  • Review the sections in the Osborne text that present a template for constructing an Excel worksheet.
  • Review the video in the Learning Resources, in which Dr. Matt Jones explains how to harness the power of Excel using contingency tables.
  • Think about the types of variables that are useful for cross tab tables.

Using one of the datasets 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

Be sure to apply the template from the Osborne text. Note that page 42 has a completed example that should help you determine these values. Be sure to 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.

Once you have created the tool, write a 1- to 2-paragraph summary in APA format interpreting your results. Submit both your Excel file and your summary to complete this assignment.

I would need you to login into my account for my datasets.

  • USW1_RSCH_8260_Week04_Osbourne_Chapter1.pdf
  • USW1_RSCH_8260_Week04_Osbourne_Chapter2.pdf

Table of Contents


Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

Pitfalls to Ethical Decision Making

 Journal Prompt: Today in class, we examined the ways in which human beings, with the best intentions, often make poor ethical decisions. These dynamics actually

Paper topic #1: Who is a citizen?

What are the main implicit and explicit arguments theorizing citizenship in Plato’s Republic and Aristotle’s Politics? In the first two-thirds of the paper, offer a

New questions

Technology in business

1. What are the tradeoffs associated with assigning IT budgets to user departments? 2. Why does IT have a “slush fund”? Is there a better

macro economics

1 demonstrates your understanding of the chapter concepts 2 explains fully the relevant concepts 3 applies the chapter concepts accurately to the question 4 includes

Don't Let Questions or Concerns Hold You Back - Make a Free Inquiry Now!