A social worker desirous of studying Behaviour and Practices of individuals with
ID: 3316139 • Letter: A
Question
A social worker desirous of studying Behaviour and Practices of individuals within a particular society carried out a survey on a sample of individuals. A subset of the data collected with selected variables is given to you in the Excel data file “KB_set”.
Please show all workings. Use the data provided to assist the social worker to complete the following tasks:
Question: Test at the 5% level of significance if there is an association between marital status and alcohol usage
Respondents # Age of Respondent Sex of Respondents Relationship Status Age at first Sexual Encounter Practice Religion number of persons use condom with in the last 12 months # of persons had sex with last 12 months Alcohol usage last four weeks 1 24 2 4 20 1 1 1 3 2 15 2 4 15 1 1 1 4 3 16 2 4 12 1 2 2 4 4 15 2 4 13 1 2 2 4 5 23 2 1 13 1 0 1 3 6 15 2 4 14 1 1 1 4 7 18 2 4 17 2 1 1 4 8 18 2 4 18 1 1 1 4 9 22 2 4 4 1 2 3 1 10 15 1 4 9 2 1 1 3 11 19 1 4 15 2 1 1 2 12 21 1 3 17 2 2 4 2 13 17 1 3 15 1 1 1 4 14 22 1 3 15 2 0 1 3 15 17 1 3 15 1 0 0 3 16 19 1 3 10 2 0 3 1 17 17 1 3 12 2 1 1 4 18 23 1 1 15 2 0 1 3 19 16 1 4 13 1 0 0 4 20 16 1 3 13 2 1 3 4 21 20 1 3 12 2 1 9 3 22 20 1 4 15 2 2 2 3 23 16 1 4 14 1 1 1 3 24 19 1 3 10 2 3 9 1 25 23 1 3 10 2 0 2 3 26 17 1 2 16 1 1 1 4 27 19 1 4 12 2 2 3 3 28 24 1 2 13 2 4 9 1 29 16 1 4 15 2 1 1 4 30 23 1 1 17 2 0 1 2 31 19 1 3 12 2 1 1 4 32 16 2 4 13 1 2 2 4 33 25 2 4 18 2 1 2 3 34 23 2 2 18 1 0 1 4 35 41 2 1 21 1 0 1 3 36 20 2 4 16 1 1 2 4 37 40 2 3 16 2 0 1 4 38 37 2 1 20 1 0 1 4 39 26 2 1 24 1 1 1 4 40 38 2 4 25 1 0 2 4 41 45 2 1 17 1 1 2 4 42 18 2 3 16 1 2 3 2 43 43 2 2 18 1 1 1 3 44 42 2 1 19 1 0 1 4 45 46 2 1 19 1 0 0 4 46 16 2 4 12 1 1 1 4 47 36 2 1 15 1 1 2 2 48 31 2 2 13 2 1 1 2 49 35 2 1 14 2 1 1 2 50 38 2 2 14 2 0 1 2 51 26 2 1 17 1 2 3 3 52 31 2 3 24 2 2 2 2 53 23 2 3 18 1 0 1 4 54 23 2 3 18 1 0 1 4 55 29 2 2 19 2 3 3 4 56 18 2 2 13 2 2 3 4 57 20 2 1 13 2 1 1 2 58 28 2 4 15 2 1 1 4 59 44 2 1 19 1 1 1 4 60 32 2 2 16 1 0 1 4 61 26 2 1 15 2 1 1 4 62 36 2 1 21 1 0 0 4 63 20 1 3 12 2 2 3 3 64 31 1 1 17 1 0 1 3 65 40 1 1 15 2 0 1 2 66 26 1 2 15 2 1 2 4 67 19 1 3 17 1 0 1 3 68 25 1 4 10 1 5 11 3 69 26 1 4 14 1 1 1 4 70 49 1 1 16 2 0 1 2Explanation / Answer
Test at the 5% level of significance if there is an association between marital status and alcohol usage
we can use chi-square
using chi-square of independnce
Alcohol usage last four weeks Relationship Status 1.1 1.2 1.3 1.4 2.1 2.2 2.3 2.4 3.1 3.2 3.3 3.4 4.1 4.2 4.3 4.4 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 3 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 4 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 2 4 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 2 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 4 3 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 3 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 4 3 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 3 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 3 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 3 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 4 2 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 2 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 3 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 4 2 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 3 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 3 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 4 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 2 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 3 2 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 4 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 2 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 3 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 4 3 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 4 3 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 4 2 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 4 2 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 2 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 2 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 4 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 3 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 2 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 3 3 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 5 8 1 2 1 6 2 3 6 7 1 1 7 14 70Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.