ID 1 2 3 4 5 6 7 8 9 SHAREALISAS 10 11 12 13 14 15 16 17 18 19 20 College Year Female Female Male Female Male Female Male Female

Question

ID 1 2 3 4 5 6 7 8 9 SHAREALISAS 10 11 12 13 14 15 16 17 18 19 20 College Year Female Female Male Female Male Female Male Female Gender Female Sophomore Male Senior Senior Freshman Junior 2 5 3 1 9 Senior Freshman Sophomore Junior 2 8 3 3 Junior 2 7 Female Freshman 3 1 Male Sophomore 2 5 Senior Junior 3 5 GPA 2 3 3 1 3 8 2 9 1 8 Female Male Female Sophomore 3 9 Female Sophomore 2 3 Male Junior 28 Male Sophomore 3 1 Female Junior Female Freshman 3 5 3 5 Age 9 43 22 18 20 23 18 19 28 21 18 19 21 21 42 19 21 25 21 17 Drinks per Month 45 30 0 35 20 10 45 28 9 0 19 25 2 19 10 45 29 14 5 28 Marijuana per Month 22 NOONGO OOg 10 Victims per Month 2 1 0 3 0 0 1 0 0 0 0 2 1 2 1 1 0 1 0 1 The data on the left shows the results of a survey of 20 college students Assignments With an alpha of 0 05 conduct a five step hypothesis test to determine if drinks per month is significantly related to marijuana per month With an alpha of 0 05 conduct a five step hypothesis test to determine if age is significantly related to victims per month Hints Excel function correlation only gives you a r Le the correlation Excel function regression gives you obtained t value and p value i e the significance Notes 1 Write down your five steps in a MS Word file 2 Use Excel to complete the fourth step which is Compute the Obtained Value 3 Copy and paste the Excel table into the MS Word file make sure you adjust the table so numbers can be shown clearly 4 Upload your MS Word file

Kunduz · Accepted Answer

Click to see the answer