Homework Database

Following is a database of information you have gathered from several participants in your study. The codebook is as follows:

• ID=participant identification number
• GENDER IDENTIFICATION:
• M=Male
• F=Female
• NB=Nonbinary
• Missing=leave blank
• Employed:
• 0=Not employed
• 1=Employed
• Missing=leave blank
• Age:
• Continuous variable, age in years
• Missing=leave blank
• Education=EDUC:
• Continuous variable, years of education
• Missing=leave blank
• AUDIT: Alcohol Use Disorders Identification Test:
• Continuous scale from 0 to 40
• Missing=leave blank

Link to AUDIT (if you want to try it):

https://www.drugabuse.gov/sites/default/files/files/AUDIT.pdf(Links to an external site.)

ID

GENDER

EMPLOYED

AGE

EDUC

AUDIT

AUD

SES

8021

0

45

18

8022

M

o

44

11

19

8023

M

0

47

11

6

8024

M

1

40

9

31

8025

ff

11

54

21

8026

F

0

50

10

24

8027

F

0

51

12

27

8028

F

1

49

12

31

8029

F

0

55

12

21

8030

m

0

47

12

8

8031

F

0

46

9

19

8032

F

0

58

13

29

8033

nB

1

33

8034

0

46

27

8035

F

0

40

13

24

8036

F

0

54

16

19

8037

0

44

27

8038

M

0

45

8

10

8039

F

0

52

09

21

8040

0

55

0

8041

345

0

26

25

8042

F

0

46

10

29

8043

M

1

47

16

34

8044

M

1

40

9

27

8045

M

0

39

13

8

8046

M

0

53

12

5

8047

F

0

46

11

30

8048

M

0

32

12

29

8049

F

1

46

14

8

8050

NB

0

54

13

20

QUESTIONS

1. List at least three missing or incorrectly entered responses in this database that could be corrected without the major likelihood of making incorrect assumptions. How would you clean those responses?
2. Let's say that an AUDIT score of16 or higher suggests a possible alcohol use disorder (AUD). Using 16 as a cutoff, recode the AUDIT into the new column called AUD as a dichotomous variable, whereby having a possible AUD=1 and not having a possible AUD=0.
3. Students need to Create a new variable called SES (already included in the table above), by recalculating education and employment as follows: A person who is employedandhas at least 12 years of education=2; all others=1. Students must create this new variable and enter it into the SES column after cleaning data.

CREATE FREQUENCY TABLES

1. Fill in the frequency table for AGE (leave out any missing data points)

FREQUENCY DISTRIBUTION OF AGE

Age

n

%

25-29

30-34

35-39

40-44

45-49

50-54

55-59

1. Fill in the following frequency table for AUD (there are no data points missing)

FREQUENCY DISTRIBUTION OF AUD

AUDIT

n

%

0-10

11-20

21-30

31-40