For this assignment, use data from W1 Midweek Assignment.ATTACHED Using Microsoft Excel and following instructions given in
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →For this assignment, use data from W1 Midweek Assignment.ATTACHED
Using Microsoft Excel and following instructions given in your lectures, conduct a chi-square analysis to determine whether sex and the year in college are related. Report your results in APA format and write one to two sentences interpreting your results.
Move your output into a 1-page Microsoft Word document and write a short, APA-formatted interpretation of the results, modeled on the example given in the lecture.
Sheet1
| sex (Male=0, Female=1) | ||||
| Year in college= (1= freshman, 2=sophomore, 3= junior, 4= senior | ||||
| Subject ID Number | Age | Sex | Height | Year in college |
| S1 | 18 | 0 | 67.2 | 1 |
| S2 | 18 | 0 | 66.9 | 1 |
| S3 | 20 | 0 | 67.5 | 1 |
| S4 | 18 | 0 | 66.8 | 1 |
| S5 | 19 | 0 | 67.3 | 1 |
| S6 | 20 | 1 | 63.4 | 1 |
| S7 | 19 | 1 | 63.2 | 1 |
| S8 | 18 | 1 | 62.8 | 1 |
| S9 | 18 | 1 | 63.6 | 1 |
| S10 | 21 | 1 | 63 | 1 |
| S11 | 19 | 0 | 67.8 | 2 |
| S12 | 20 | 0 | 68 | 2 |
| S13 | 20 | 0 | 68.1 | 2 |
| S14 | 21 | 0 | 67.6 | 2 |
| S15 | 19 | 0 | 67.9 | 2 |
| S16 | 20 | 1 | 64 | 2 |
| S17 | 19 | 1 | 63.9 | 2 |
| S18 | 20 | 1 | 64.2 | 2 |
| S19 | 19 | 1 | 64.3 | 2 |
| S20 | 20 | 1 | 63.8 | 2 |
| S21 | 22 | 0 | 68.3 | 3 |
| S22 | 21 | 0 | 68.2 | 3 |
| S23 | 20 | 0 | 68.5 | 3 |
| S24 | 20 | 0 | 68 | 3 |
| S25 | 22 | 0 | 68.1 | 3 |
| S26 | 20 | 1 | 63.8 | 3 |
| S27 | 21 | 1 | 63.6 | 3 |
| S28 | 21 | 1 | 63.9 | 3 |
| S29 | 20 | 1 | 64 | 3 |
| S30 | 21 | 1 | 64.1 | 3 |
| S31 | 22 | 0 | 69 | 4 |
| S32 | 23 | 0 | 69.1 | 4 |
| S33 | 23 | 0 | 69.3 | 4 |
| S34 | 21 | 0 | 68.8 | 4 |
| S35 | 21 | 0 | 69.4 | 4 |
| S36 | 22 | 1 | 64.3 | 4 |
| S37 | 21 | 1 | 65 | 4 |
| S38 | 21 | 1 | 64.8 | 4 |
| S39 | 23 | 1 | 64.3 | 4 |
| S40 | 22 | 1 | 64.7 | 4 |
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds