MATH 144 Grand Canyon University Statistics Finding Percentiles Spreadsheet

According to the National Center for Health Statistics, the mean height of an American male is 69.3 inches and the mean height of an American female is 63.8 inches. The standard deviation for both genders is 2.7 inches.

Assuming that heights among a single gender are normally distributed. Find the z-score for your height in inches using the mean of your own gender and then find the percentile at which you fall among people of your own gender using the percentile table from problem 25 of the Topic 2

i
X Х
More Info
–
Z-score
Percentile
Z-score
Percentile
86.43
– 3.5
00.02
1.1
– 3.0
00.13
1.2
88.49
– 2.9
1.3
90.32
00.19
00.26
– 2.8
1.4
-2.7
00.35
1.5
91.92
93.32
94.52
95.54
00.47
1.6
– 2.6
-2.5
1.7
-2.4
1.8
1.9
96.41
97.13
97.72
Standard Scores and Percentiles
Z-score Percentile Z-score Percentile
– 1.00 15.87 0.00 50.00
– 0.95 17.11
0.05 51.99
-0.90 18.41 0.10 53.98
– 0.85
19.77 0.15 55.96
-0.80 21.19 0.20 57.93
-0.75 22.66 0.25 59.87
-0.70 24.20 0.30 61.79
– 0.65 25.78 0.35 63.68
-0.60 27.43 0.40 65.54
– 0.55 29.12 0.45 67.36
-0.50 30.85 0.50 69.15
-0.45 32.64 0.55 70.88
-0.40 34.46 0.60 72.57
-0.35 36.32 0.65 74.22
-0.30 38.21 0.70 75.80
-0.25 40.13 0.75 77.34
-0.20 42.07 0.80 78.81
-0.15 44.04 0.85 80.23
-0.10 46.02 0.90
81.59
-0.05 48.01 0.95 82.89
-0.00 50.00 1.00 84.13
-2.3
– 2.2
-2.1
– 2.0
2.0
00.62
00.82
01.07
01.39
01.79
02.28
02.87
03.59
04.46
2.1
98.21
2.2
– 1.9
2.3
98.61
98.93
99.18
99.38
2.4
– 1.8
– 1.7
2.5
– 1.6
05.48
2.6
99.53
– 1.5
06.68
2.7
99.65
– 1.4
2.8
08.08
09.68
99.74
99.81
– 1.3
2.9
– 1.2
11.51
3.0
99.87
– 1.1
13.57
3.5
99.98
Print
Done