Education SOCI332 WEEK 7 ASSIGNMENT

Hide Assignment Information

Instructions

Assignment Directions:

1. Conduct a chi-square test from Chapter 11 in Excel with an example dataset; include table of observed vs expected. ( https://openstax.org/details/books/introductory-statistics-2e )

Excel Directions: 

1. Chi-Square: 

a. Build observed counts table. 

b. Calculate expected counts: = (row_total * col_total) / grand_total. 

c. Compute (Observed – Expected)² / Expected in each cell and sum => chi-square statistic. 

d. Use =CHISQ.DIST.RT(chi_square_stat, df) to compute p-value. 

Submission Instructions:

[Enter the expectations for the student's submissions. Samples are below]

· A Word Document

· Must include a title page, abstract, and references. These are not counted in the page count/slide count. 

Be sure to review the following prior to submitting your assignment:

· Academic Integrity Guidelines [content page]

· Assignment Rubric

· If you do not see the rubric, in the blue horizontal navigation bar select Course Tools, then Assignments. Select the appropriate assignment, and the rubric will be located near the bottom of the page.

This assignment aligns with the following:

· Course Objectives 4, 5 & 6 [content page]

· Learning Objectives 1.1 & 2.3 [content page]

Resources & Supports

· Office 365 [wepbage]: You have free access as an APUS student. Sign in with your MyCampus Email credentials.

· Submitting and Confirming a Submission [video]: Watch this 3-minute video if you need guidance on submitting your assignment.