[Solved] Education SOCI332 WEEK 6 Assignment

Assignment Prompt & Instructions

**files (1)**

– ## SOCI332WEEK6Assignment.docx

**## SOCI332WEEK6Assignment.docx**

Week 6 Assignment: Hypothesis Testing (One Sample / Proportions)

Top of Form

| | |
| — | — |
| Hide Assignment Information |
| Instructions | |
| **Assignment Directions:**<br>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. <br>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. <br>3. Write a 200-word conclusion interpreting the result: what does rejecting or failing to reject the null mean in practical context? <br>**Excel Directions:**<br>1. State your null and alternative hypotheses in text. <br>2. Use <br>**Data → Data Analysis → t-Test: Two-Sample Assuming Equal Variances** (or appropriate variant) if Analysis ToolPak is enabled. Or use built-in functions: <br> <br>a. =T.TEST(range1, range2, tails, type) <br>b. For one-sample: compute t = (mean – μ₀) / (stdev / SQRT(n)). <br>3. Use =T.DIST.2T(|t|, df) or =T.DIST.RT(|t|, df) for p-value (two-tail or right-tail). <br>4. Compare p-value to α. Make decision. <br>5. Report test statistic, degrees of freedom, p-value in Excel, and interpretation in a write-up. <br>6. Use cell references for all calculations. <br>**Submission Instructions:**<br>[Enter the expectations for the student's submissions. Samples are below]<br>· A 3–5-page Word Document<br>· Must include a title page, abstract, and references. These are not counted in the page count/slide count. <br>**Be sure to review the following prior to submitting your assignment:**<br>· <br>[Academic Integrity Guidelines [content page]](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1538203&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-741797)<br>· Assignment Rubric<br>· If you do not see the rubric, in the blue horizontal navigation bar select <br>**Course Tools, then Assignments**. Select the appropriate assignment, and the rubric will be located near the bottom of the page.<br> <br>This assignment aligns with the following:<br>· Course Objectives <br>[3, 5 & 6 [content page]](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1538203&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>· Learning Objectives <br>[1.1 & 2.3 [content page]](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1538203&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>**Resources & Supports**<br>· <br>[Office 365 [wepbage]:](https://www.office.com/) You have free access as an APUS student. Sign in with your MyCampus Email credentials.<br> <br>· <br>[Submitting and Confirming a Submission ](https://youtu.be/HY0ogyh-IhQ): Watch this 3-minute video if you need guidance on submitting your assignment. |

Bottom of Form

**## SOCI332WEEK6Assignment.docx**

Week 6 Assignment: Hypothesis Testing (One Sample / Proportions)

Top of Form

| | |
| — | — |
| Hide Assignment Information |
| Instructions | |
| **Assignment Directions:**<br>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. <br>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. <br>3. Write a 200-word conclusion interpreting the result: what does rejecting or failing to reject the null mean in practical context? <br>**Excel Directions:**<br>1. State your null and alternative hypotheses in text. <br>2. Use <br>**Data → Data Analysis → t-Test: Two-Sample Assuming Equal Variances** (or appropriate variant) if Analysis ToolPak is enabled. Or use built-in functions: <br> <br>a. =T.TEST(range1, range2, tails, type) <br>b. For one-sample: compute t = (mean – μ₀) / (stdev / SQRT(n)). <br>3. Use =T.DIST.2T(|t|, df) or =T.DIST.RT(|t|, df) for p-value (two-tail or right-tail). <br>4. Compare p-value to α. Make decision. <br>5. Report test statistic, degrees of freedom, p-value in Excel, and interpretation in a write-up. <br>6. Use cell references for all calculations. <br>**Submission Instructions:**<br>[Enter the expectations for the student's submissions. Samples are below]<br>· A 3–5-page Word Document<br>· Must include a title page, abstract, and references. These are not counted in the page count/slide count. <br>**Be sure to review the following prior to submitting your assignment:**<br>· <br>[Academic Integrity Guidelines [content page]](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1538203&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-741797)<br>· Assignment Rubric<br>· If you do not see the rubric, in the blue horizontal navigation bar select <br>**Course Tools, then Assignments**. Select the appropriate assignment, and the rubric will be located near the bottom of the page.<br> <br>This assignment aligns with the following:<br>· Course Objectives <br>[3, 5 & 6 [content page]](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1538203&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>· Learning Objectives <br>[1.1 & 2.3 [content page]](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1538203&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>**Resources & Supports**<br>· <br>[Office 365 [wepbage]:](https://www.office.com/) You have free access as an APUS student. Sign in with your MyCampus Email credentials.<br> <br>· <br>[Submitting and Confirming a Submission ](https://youtu.be/HY0ogyh-IhQ): Watch this 3-minute video if you need guidance on submitting your assignment. |

Bottom of Form