Based on the data below, run the SPSS software to answer the following questions and make your

write ups.
1. Present the respondents' profile when grouped according to civil status, sex position, adult age group and cholesterol leve
2.Is there a significant difference on the cholesterol level of male and female respondents before taking the mineral supplem
3. Is there a significant difference on the cholesterol level of male and female respondents after taking the mineral suppleme
4. Is there a significant difference on the cholesterol level of the male respondents before and after ta
5. Is there a significant difference on the cholesterol level of the female respondents before and after
6. Is there a significant difference on the cholesterol after taking the mineral supplement when grouped according to civil sta
Note: Include Post Hoc Analysis if there is a signifi
7. Is there a significant relationship between the respondents' cholesterol level and respondents' position and age group ?
8. Is there a significant correlation of the respondents' age, monthly salary, and cholesterol level ?
Employee's # CS Sex Position AGE
1 3 1 1 50
2 2 1 1 47
3 3 1 2 38
4 2 1 3 42
5 2 1 3 29
6 2 1 3 35
7 2 1 3 27
8 2 1 1 47
9 2 1 1 39
10 1 1 1 40
11 1 1 2 29
12 3 1 1 47
13 3 1 2 21
14 3 1 2 24
15 3 1 2 28
16 2 1 2 29
17 2 1 2 36
18 2 1 1 48
19 1 1 2 38
20 1 1 2 39
21 1 1 2 31
22 1 2 2 32
23 1 2 1 39
24 1 2 1 40
25 3 1 3 32
26 2 1 4 26
27 3 1 3 29
28 1 1 1 41
29 2 1 1 41
30 1 1 1 43
31 3 1 3 36
32 3 1 3 35
33 3 2 3 38
34 2 2 1 44
35 2 2 1 45
36 1 1 2 40
37 2 1 2 39
38 2 1 4 25
39 2 1 4 30
40 3 1 3 35
41 3 1 3 26
42 3 1 4 27
43 3 1 2 35
44 1 2 3 29
45 2 2 4 26
46 2 1 4 31
47 2 1 4 32
48 2 2 3 35
49 2 1 2 38
50 1 1 2 31
51 1 1 2 29
52 2 2 3 31
53 2 2 2 32
54 1 2 2 30
55 1 1 3 36
56 1 1 3 37
57 3 1 4 38
58 3 1 3 39
59 3 2 3 41
60 3 2 2 38
61 2 1 3 37
62 2 2 3 39
63 1 2 4 45
64 1 1 3 27
65 1 1 4 40
66 2 2 3 27
67 1 2 3 34
68 3 2 3 34
69 1 2 3 32
 70 1 2 3 35
71 3 1 1 50
72 2 1 1 47
73 3 1 2 38
74 2 1 3 42
75 2 1 3 29
76 2 1 3 35
77 2 1 3 27
78 2 1 1 47
79 2 1 1 39
80 1 1 1 40
81 1 1 2 29
82 3 1 1 47
83 3 1 2 21
84 3 1 2 24
85 3 1 2 28
86 2 1 2 29
87 2 1 2 36
88 2 1 1 48
89 1 1 2 38
90 1 1 2 39
91 1 1 2 31
92 1 2 2 32
93 1 2 1 39
94 1 2 1 40
95 3 1 3 32
96 2 1 4 26
97 3 1 3 29
98 1 1 1 41
99 2 1 1 41
100 1 1 1 43
101 3 1 3 36
102 3 1 3 35
103 3 2 3 38
104 2 2 1 44
105 2 2 1 45
106 1 1 2 40
107 2 1 2 39
108 2 1 4 25
109 2 1 4 30
110 3 1 3 35
111 3 1 3 26
112 3 1 4 27
113 3 1 2 35
114 1 2 3 29
115 2 2 4 26
116 2 1 4 31
117 2 1 4 32
118 2 2 3 35
119 2 1 2 38
120 1 1 2 31
121 1 1 2 29
122 2 2 3 31
123 2 2 2 32
124 1 2 2 30
125 1 1 3 36
126 1 1 3 37
127 3 1 4 38
128 3 1 3 39
129 3 2 3 41
130 3 2 2 38
131 2 1 3 37
132 2 2 3 39
133 1 2 4 45
134 1 1 3 27
135 1 1 4 40
136 2 2 3 27
137 1 2 3 34
138 3 2 3 34
139 1 2 3 32
140 1 2 3 35
ns and make your write ups.
osition, adult age group and cholesterol level.
pondents before taking the mineral supplement ?
spondents after taking the mineral supplement ?
male respondents before and after taking the mineral supplement?
emale respondents before and after taking the mineral supplement?
pplement when grouped according to civil status, and position ?
e: Include Post Hoc Analysis if there is a significant difference?
nd respondents' position and age group ?
holesterol level ?
adult age group MS CLB CLA Cholesterol level
2 21100 235 200 2
2 20000 230 229 2
2 18000 220 215 2
2 16700 215 215 2
1 12780 188 180 1
2 14390 221 200 2
1 12870 188 180 1
2 25500 236 237 2
2 26000 203 200 2
2 31000 234 230 2
1 18390 178 170 1
2 32000 230 228 2
1 15890 170 171 1
1 18900 184 184 1
1 17690 185 180 1
1 17890 190 184 1
2 20000 198 190 1
2 24700 240 233 2
2 18000 201 201 2
2 18900 203 203 2
2 17890 190 189 1
2 16890 191 190 1
2 22000 218 200 2
2 21180 219 200 2
2 15500 200 200 2
1 10390 188 187 1
1 11100 189 190 1
2 23550 232 225 2
2 20000 235 228 2
2 21100 240 234 2
2 15700 202 200 2
2 14570 201 200 2
2 12280 211 208 2
2 19900 239 214 2
2 19990 244 225 2
2 18900 239 228 2
2 15790 220 215 2
1 9000 175 174 1
2 10870 191 190 1
2 15490 207 207 2
1 12240 183 183 1
1 11650 184 183 1
2 16790 205 201 2
1 11350 185 181 1
1 9900 179 175 1
2 10090 180 170 1
2 10690 180 171 1
2 11320 199 191 1
2 15900 211 201 2
2 16000 181 173 1
1 16700 176 165 1
2 14210 179 180 1
2 15550 182 180 1
2 19000 178 175 1
2 11170 208 200 2
2 12390 215 211 2
2 11280 195 190 1
2 14580 219 214 2
2 13260 241 240 2
2 18900 200 169 1
2 14560 194 190 1
2 12560 210 190 1
2 13450 232 232 2
1 12280 171 170 1
2 10860 230 228 2
1 11230 170 166 1
2 14260 190 180 1
2 12220 200 201 2
2 12000 194 184 1
2 13200 210 201 2
2 21100 235 200 2
2 20000 230 229 2
2 18000 220 215 2
2 16700 215 215 2
1 12780 188 180 1
2 14390 221 200 2
1 12870 188 180 1
2 25500 236 237 2
2 26000 203 200 2
2 31000 234 230 2
1 18390 178 170 1
2 32000 230 228 2
1 15890 170 171 1
1 18900 184 184 1
1 17690 185 180 1
1 17890 190 184 1
2 20000 198 190 1
2 24700 240 233 2
2 18000 201 201 2
2 18900 203 203 2
2 17890 190 189 1
2 16890 191 190 1
2 22000 218 200 2
2 21180 219 200 2
2 15500 200 200 2
1 10390 188 187 1
1 11100 189 190 1
2 23550 232 225 2
2 20000 235 228 2
2 21100 240 234 2
2 15700 202 200 2
2 14570 201 200 2
2 12280 211 208 2
2 19900 239 214 2
2 19990 244 225 2
2 18900 239 228 2
2 15790 220 215 2
1 9000 175 174 1
2 10870 191 190 1
2 15490 207 207 2
1 12240 183 183 1
1 11650 184 183 1
2 16790 205 201 2
1 11350 185 181 1
1 9900 179 175 1
2 10090 180 170 1
2 10690 180 171 1
2 11320 199 191 1
2 15900 211 201 2
2 16000 181 173 1
1 16700 176 165 1
2 14210 179 180 1
2 15550 182 180 1
2 19000 178 175 1
2 11170 208 200 2
2 12390 215 211 2
2 11280 195 190 1
2 14580 219 214 2
2 13260 241 240 2
2 18900 200 169 1
2 14560 194 190 1
2 12560 210 190 1
2 13450 232 232 2
1 12280 171 170 1
2 10860 230 228 2
1 11230 170 166 1
2 14260 190 180 1
2 12220 200 201 2
2 12000 194 184 1
2 13200 210 201 2
Position Sex
1-Administrator 1- male
2- Faculty 2 - female
3-Staff
4-Maintenance

Legend/Label:
CS-Civil Status
1-single
2-married
3-separated

MS- Monthly Salary

CLB-Cholesterol Level Before taking the mineral supplement
CLA-Cholesterol Level After taking the mineral supplement

Adult age group

1- young adult ( 18 – 29 years old )
2 – middle adult ( 30 – 49 years old )
3 – old adult ( 50 years old and above )

Cholesterol level
3 – above 240 ( high)
2 – 200 – 240 ( borderline)
1 – below 200 (desirable)
Based on the data below, run the SPSS software to answer the following questions and make your wr

1. Is there a significant difference on the cholesterol level of the male respondents before and after ta
2. Is there a significant difference on the cholesterol level of the female respondents before and after

male clb cla female clb

1 235 200 2 191
1 230 229 2 218
1 220 215 2 219
1 215 215 2 211
1 188 180 2 239
1 221 200 2 244
1 188 180 2 185
1 236 237 2 179
1 203 200 2 199
1 234 230 2 179
1 178 170 2 182
1 230 228 2 178
1 170 171 2 241
1 184 184 2 200
1 185 180 2 210
1 190 184 2 232
1 198 190 2 170
1 240 233 2 190
1 201 201 2 200
1 203 203 2 194
1 190 189 2 210
1 200 200 2 191
1 188 187 2 218
1 189 190 2 219
1 232 225 2 211
1 235 228 2 239
1 240 234 2 244
1 202 200 2 185
1 201 200 2 179
1 239 228 2 199
1 220 215 2 179
1 175 174 2 182
1 191 190 2 178
1 207 207 2 241
1 183 183 2 200
1 184 183 2 210
1 205 201 2 232
1 180 170 2 170
1 180 171 2 190
1 211 201 2 200
1 181 173 2 194
1 176 165 2 210
1 208 200
1 215 211
1 195 190
1 219 214
1 194 190
1 171 170
1 230 228
1 235 200
1 230 229
1 220 215
1 215 215
1 188 180
1 221 200
1 188 180
1 236 237
1 203 200
1 234 230
1 178 170
1 230 228
1 170 171
1 184 184
1 185 180
1 190 184
1 198 190
1 240 233
1 201 201
1 203 203
1 190 189
1 200 200
1 188 187
1 189 190
1 232 225
1 235 228
1 240 234
1 202 200
1 201 200
1 239 228
1 220 215
1 175 174
1 191 190
1 207 207
1 183 183
1 184 183
1 205 201
1 180 170
1 180 171
1 211 201
1 181 173
1 176 165
1 208 200
1 215 211
1 195 190
1 219 214
1 194 190
1 171 170
1 230 228
 questions and make your write ups.

spondents before and after taking the mineral supplement?

respondents before and after taking the mineral supplement?

cla
190
200
200 legend
208 CLB-Cholesterol Level Before taking the mineral supplement
214 CLA-Cholesterol Level After taking the mineral supplement
225
181
175
191
180
180
175
240
169
190
232
166
180
201
184
201
190
200
200
208
214
225
181
175
191
180
180
175
240
169
190
232
166
180
201
184
201