The following data are available:
Resp Age Exam Paper Sex Year IQ
Mark mark college
1 21 87 83 M 2 80
2 19 83 80 M 1 100
3 23 85 86 M 4 98
4 21 81 75 F 1 76
5 21 81 75 F 3 82
6 20 67 68 F 3 99
7 26 75 88 F 2 120
8 24 92 78 F 4 115
9 26 78 92 M 4 126
10 30 89 95 F 3 129
11 21 72 80 F 1 86
12 19 81 65 M 2 80
13 17 75 77 M 1 70
14 19 76 85 F 1 99
15 35 80 83 F 3 99
16 27 75 60 F 2 60
17 21 85 80 M 3 89
18 27 79 75 M 4 70
19 21 90 93 F 3 140
20 22 97 95 M 3 165
21 21 90 82 M 2 115
22 19 87 86 F 3 119
23 32 95 90 M 2 120
24 19 68 57 F 3 89
1. Data handling:
a. Enter the data in Excell. Save the file to your USB. Name the file "assignment".
b. Provide appropriate variable labels, value labels, and scaling indications to the variables.
2. Descriptives:
a. Use Analyze, Descriptive statistics, Descriptives to summarize metric variables.
b. Use Analyze, Descriptive statistics, Frequencies to summarize nonmetric variables.
c. Create a pie-chart for Year in college.
d. Create a histogram for IQ and include the normal distribution.
e. Make a scatter plot with IQ on the x - axis and exam grade on the y - axis. What do you conclude?
f. Recode the sex variable such that it is 1 for females and 0 for males.
g. Make a scatter plot with sex on the x - axis and IQ on the y - axis. What do you conclude?
h. Compute the mean IQ for males and for females. Conclusion?
i. Create a new dummy variable, IQdum, which is 1 if the IQ is larger than or equal to 100, and 0 otherwise.