chi-square analysis For this assignment, use data from W1 Midweek Assignment.ATTACHED Using Microsoft Excel and following instructions given in your le

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 NumberAgeSexHeightYear in college
S118067.21
S218066.91
S320067.51
S418066.81
S519067.31
S620163.41
S719163.21
S818162.81
S918163.61
S10211631
S1119067.82
S12200682
S1320068.12
S1421067.62
S1519067.92
S16201642
S1719163.92
S1820164.22
S1919164.32
S2020163.82
S2122068.33
S2221068.23
S2320068.53
S24200683
S2522068.13
S2620163.83
S2721163.63
S2821163.93
S29201643
S3021164.13
S31220694
S3223069.14
S3323069.34
S3421068.84
S3521069.44
S3622164.34
S37211654
S3821164.84
S3923164.34
S4022164.74

Looking for this or a Similar Assignment? Click below to Place your Order