Education SOCI332 WEEK 6 Assignment

Hide Assignment Information

Instructions

Assignment Directions:

1. From Chapter 9 & 10, ( https://openstax.org/details/books/introductory-statistics-2e) select ONE hypothesis testing problem (for example, a one-sample mean or proportion) and work them out in full. 

2. In Excel, conduct at least one t-test or z-test (depending on the chosen problem) and record the test statistic, p-value, and decision. 

3. Write a 200-word conclusion interpreting the result: what does rejecting or failing to reject the null mean in practical context? 

Excel Directions: 

1. State your null and alternative hypotheses in text. 

2. Use Data → Data Analysis → t-Test: Two-Sample Assuming Equal Variances (or appropriate variant) if Analysis ToolPak is enabled. Or use built-in functions: 

a. =T.TEST(range1, range2, tails, type) 

b. For one-sample: compute t = (mean – μ₀) / (stdev / SQRT(n)). 

3. Use =T.DIST.2T(|t|, df) or =T.DIST.RT(|t|, df) for p-value (two-tail or right-tail). 

4. Compare p-value to α. Make decision. 

5. Report test statistic, degrees of freedom, p-value in Excel, and interpretation in a write-up. 

6. Use cell references for all calculations. 

Submission Instructions:

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

· A 3–5-page 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 3, 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.