Order
Toll-free 24/7:
+1 725-224-8795
Order

Assignment: contingency tables and odds in excel

Author:
March 13th, 2020

[ad_1]

 

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.

https://class.waldenu.edu/bbcswebdav/institution/USW1/201850_27/XX_RSCH/RSCH_8260_WC/artifacts/USW1_RSCH_8260_statsAnxietyAdvQuant.sav

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
management diversity
thank you so much it looks amazing
Customer 462327, April 19th, 2023
Psychology
The paper was beautifully written and exceeded my expectations. John was really helpful in ensuring that the files were attached to the order when I had issues attaching them. Thank you to the tutor and John. I was really excited that I received my paper ahead of time!
Customer 452455, March 28th, 2023
Medicine
Good work
Customer 453187, May 25th, 2022
community health
Thank you!!!
Customer 463301, September 1st, 2022
Military
Good work.
Customer 456821, June 20th, 2022
accounting
Good work.
Customer 459155, May 22nd, 2022
Criminal Justice
this is an excellent paper
Customer 454221, April 3rd, 2020
Nursing
Good well done!!!
Customer 453939, April 2nd, 2020
IT
Excellent.
Customer 452441, April 6th, 2022
MBA
Good work.
Customer 462257, April 8th, 2022
English 101
Order was late
Customer 462805, April 4th, 2022
Nursing
Thanks so much, excellent work as always.
Customer 453939, May 23rd, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat