Question

z-Score Using the database created in W1 Assignment, convert each subject's age and height into a z-score. Using the z-score of ±1.645 for the 5 percent cutoff and the z-score of ±1.96 for the 2.5 percent in the tail, identify the subject identification (ID) number for subjects who are closest to the cutoff for the upper 2.5 percent and 5 percent of the scores and the lower 2.5 percent and 5 percent of the scores. Do this by comparing each participant’s z-score with the appropriate critical value (1.645, 1.96, -1.645, -1.96). Save the Minitab worksheet. Name your Minitab worksheet

SUBJECT ID AGE Standardize AGE SEX HEIGHT Standardize HEIGHT_1 YEAR
1 20 -1.19601231300587 F 163 -0.765302098503698 f
2 21 -0.658478689183006 F 163 -0.765302098503698 f
3 22 -0.120945065360145 F 163 -0.765302098503698 f
4 23 0.416588558462717 F 157 -1.27835378465143 F
5 24 0.954122182285578 F 157 -1.27835378465143 F
6 25 1.49165580610844 F 168 -0.337759026713922 S
7 20 -1.19601231300587 F 178 0.51732711686563 S
8 21 -0.658478689183006 F 173 0.0897840450758539 S
9 22 -0.120945065360145 F 173 0.0897840450758539 S
10 23 0.416588558462717 F 160 -1.02182794157756 S
11 24 0.954122182285578 F 163 -0.765302098503698 JR
12 25 1.49165580610844 F 183 0.944870188655406 JR
13 20 -1.19601231300587 F 163 -0.765302098503698 JR
14 21 -0.658478689183006 F 163 -0.765302098503698 JR
15 22 -0.120945065360145 F 165 -0.594284869787788 JR
16 23 0.416588558462717 F 145 -2.30445715694689 SR
17 24 0.954122182285578 F 165 -0.594284869787788 SR
18 25 1.49165580610844 F 163 -0.765302098503698 SR
19 20 -1.19601231300587 F 173 0.0897840450758539 SR
20 21 -0.658478689183006 F 173 0.0897840450758539 SR
21 22 -0.120945065360145 M 183 0.944870188655406 F
22 23 0.416588558462717 M 165 -0.594284869787788 F
23 24 0.954122182285578 M 191 1.62893910351905 F
24 25 1.49165580610844 M 180 0.68834434558154 F
25 19 -1.73354593682873 M 180 0.68834434558154 F
26 20 -1.19601231300587 M 163 -0.765302098503698 S
27 21 -0.658478689183006 M 183 0.944870188655406 S
28 22 -0.120945065360145 M 173 0.0897840450758539 S
29 23 0.416588558462717 M 165 -0.594284869787788 S
30 24 0.954122182285578 M 195 1.97097356095087 S
31 25 1.49165580610844 M 168 -0.337759026713922 JR
32 19 -1.73354593682873 M 168 -0.337759026713922 JR
33 20 -1.19601231300587 M 195 1.97097356095087 JR
34 21 -0.658478689183006 M 178 0.51732711686563 JR
35 22 -0.120945065360145 M 178 0.51732711686563 JR
36 23 0.416588558462717 M 191 1.62893910351905 SR
37 24 0.954122182285578 M 170 -0.166741797998012 SR
38 25 1.49165580610844 M 163 -0.765302098503698 SR
39 20 -1.19601231300587 M 183 0.944870188655406 SR
40 21 -0.658478689183006 M 195 1.97097356095087 SR
      

Answer 1

closest to ±1.645 for the 5 percent cutoff
SUBJECT_ID	AGE	Standardize_AGE	SEX	HEIGHT	Standardize_HEIGHT	YEAR
16	23	0.41658856	F	145	-2.304457157	SR
25	19	-1.73354594	M	180	0.688344346	F
30	24	0.95412218	M	195	1.970973561	S
32	19	-1.73354594	M	168	-0.337759027	JR
33	20	-1.19601231	M	195	1.970973561	JR
40	21	-0.65847869	M	195	1.970973561	SR
closest to ±1.96 for the 2.5 percent cutoff
SUBJECT_ID	AGE	Standardize_AGE	SEX	HEIGHT	Standardize_HEIGHT	YEAR
16	23	0.41658856	F	145	-2.304457157	SR
30	24	0.95412218	M	195	1.970973561	S
33	20	-1.19601231	M	195	1.970973561	JR
40	21	-0.65847869	M	195	1.970973561	SR