Executive Solution Overview
**files (1)** – ## SOCI332WEEK7Assignment.docx **## SOCI332WEEK7Assignment.docx** | | | | — | — | | Hide Assignment Information | | Instructions | | | **Assignment Directions:**<br>1. Conduct a chi-square test from Chapter 11 in Excel with an example dataset; include table of observed vs expect…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
**files (1)**
– ## SOCI332WEEK7Assignment.docx
**## SOCI332WEEK7Assignment.docx**
| | |
| — | — |
| Hide Assignment Information |
| Instructions | |
| **Assignment Directions:**<br>1. Conduct a chi-square test from Chapter 11 in Excel with an example dataset; include table of observed vs expected. ( <br>[https://openstax.org/details/books/introductory-statistics-2e](https://openstax.org/details/books/introductory-statistics-2e) ) <br> <br>**Excel Directions:**<br>1. <br>**Chi-Square:**<br>a. Build observed counts table. <br>b. Calculate expected counts: = (row_total * col_total) / grand_total. <br>c. Compute (Observed – Expected)² / Expected in each cell and sum => chi-square statistic. <br>d. Use =CHISQ.DIST.RT(chi_square_stat, df) to compute p-value. <br>**Submission Instructions:**<br>[Enter the expectations for the student's submissions. Samples are below]<br>· A 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>[4, 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. |
Week 7 Assignment: Hypothesis Testing (Two Samples), Chi-Square, Regression & Correlation
Top of Form
Bottom of Form
**## SOCI332WEEK7Assignment.docx**
| | |
| — | — |
| Hide Assignment Information |
| Instructions | |
| **Assignment Directions:**<br>1. Conduct a chi-square test from Chapter 11 in Excel with an example dataset; include table of observed vs expected. ( <br>[https://openstax.org/details/books/introductory-statistics-2e](https://openstax.org/details/books/introductory-statistics-2e) ) <br> <br>**Excel Directions:**<br>1. <br>**Chi-Square:**<br>a. Build observed counts table. <br>b. Calculate expected counts: = (row_total * col_total) / grand_total. <br>c. Compute (Observed – Expected)² / Expected in each cell and sum => chi-square statistic. <br>d. Use =CHISQ.DIST.RT(chi_square_stat, df) to compute p-value. <br>**Submission Instructions:**<br>[Enter the expectations for the student's submissions. Samples are below]<br>· A 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>[4, 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. |
Week 7 Assignment: Hypothesis Testing (Two Samples), Chi-Square, Regression & Correlation
Top of Form
Bottom of Form
Leave a Reply