can someone please assist with the development of a chi square sample and interpretation of results

Chi Square

Go to the Data and Story Library and click in the Search by Statistical Method box, then click Chi Square Tests. Find a datafile you are interested in that contains information appropriate for a chi square test of independence (two categorical variables) and download the .TXT file and save to your computer. The Unit 8 Discussion video will show you how to import data from a text file and how to create a pivot table in Excel to analyze your data using chi square analysis.

Include the answers to the following questions for your datafile and attach your Excel spreadsheet to your post. Use the Excel chi square worksheet to calculate your test statistic and p-value (as long as you do not have more than 5 rows and 5 columns).

  1. What is the name of your datafile? What are the two categorical variables of interest? What is your research question? The question should be in the format of “Is there an association between ___ and ___?”
  2. What is the Ho and Ha?
  3. What is the name of the test you will run?
  4. Insert your Excel chi square output in your response using the snipping tool and Insert Image.
  5. What is your chi square test statistic?
  6. What is your p-value?
  7. Compare your p-value to alpha (assume alpha = 0.05) and state your decision.
  8. What is your conclusion in context?
  9. Do a segmented bar chart or double bar chart with your variables using Excel, insert the image using the snipping tool, and discuss the association or lack of association that you see from your graph. Be specific.

Remember that your goal for Discussion Assignments is to ensure:

  • Responses are on topic, original, and contribute to the quality of the Discussion.
  • Responses make frequent, informed references to unit material.
  • Responses are clearly written.
  • A minimum of two or more responses per thread to classmates that are thoughtful and advance the Discussion are required.

Due 12/10/19 by 8 pm central time