Question

height male=1

149.0   0
169.3   0
162.8   0
169.7   0
165.1   0
168.6   0
155.6   0
153.2   0
159.0   0
156.5   0
144.4   0
164.4   0
149.5   0
162.8   0
155.7   0
159.4   0
162.5   0
154.1   0
155.6   0
160.0   0
156.4   0
173.2   0
152.4   0
167.7   0
158.8   0
166.6   0
162.2   0
163.3   0
168.6   0
163.4   0
155.0   0
163.6   0
175.1   0
164.7   0
171.8   0
167.6   0
159.4   0
161.9   0
156.3   0
157.6   0
155.6   0
154.9   0
177.8   0
166.1   0
148.7   0
169.1   0
162.6   0
158.4   0
160.6   0
166.9   0
150.6   0
147.2   0
154.6   0
157.5   0
156.6   0
157.4   0
165.2   0
160.9   0
162.9   0
157.3   0
160.3   0
147.9   0
164.0   0
163.1   0
166.1   0
156.1   0
153.3   0
163.1   0
159.5   0
172.1   0
169.1   0
158.4   0
156.5   0
155.0   0
170.6   0
162.2   0
167.7   0
177.3   0
162.2   0
154.8   0
160.2   0
157.8   0
164.6   0
181.4   0
169.1   0
175.6   0
159.5   0
155.5   0
161.5   0
164.1   0
154.8   0
160.0   0
158.4   0
172.0   0
164.8   0
170.9   0
168.8   0
167.0   0
166.1   0
162.9   0
168.0   0
165.4   0
155.6   0
164.0   0
170.2   0
160.1   0
168.9   0
163.3   0
152.0   0
160.3   0
157.0   0
156.5   0
166.9   0
162.5   0
156.8   0
164.7   0
160.1   0
155.1   0
153.3   0
165.8   0
165.6   0
163.0   0
155.4   0
167.1   0
166.3   0
159.6   0
176.1   0
178.8   0
169.5   0
165.6   0
156.8   0
170.9   0
151.6   0
173.6   0
154.4   0
159.7   0
162.5   0
146.7   0
162.9   0
171.1   0
144.2   0
161.4   0
169.8   0
134.5   0
167.6   0
157.6   0
161.2   0
178.5   1
155.0   1
179.0   1
181.7   1
178.5   1
166.3   1
170.0   1
171.7   1
180.5   1
172.9   1
178.6   1
167.5   1
164.5   1
175.7   1
181.9   1
184.3   1
181.1   1
172.2   1
178.5   1
178.7   1
172.6   1
165.7   1
177.1   1
174.4   1
174.4   1
166.7   1
171.9   1
170.9   1
169.7   1
176.8   1
185.1   1
159.9   1
180.4   1
180.8   1
169.0   1
166.4   1
162.4   1
168.5   1
162.0   1
174.8   1
179.4   1
187.2   1
169.1   1
175.9   1
174.9   1
174.3   1
168.5   1
185.1   1
167.5   1
161.8   1
173.2   1
176.6   1
178.4   1
165.3   1
178.7   1
180.1   1
169.3   1
161.6   1
174.6   1
189.7   1
166.4   1
170.5   1
169.1   1
178.6   1
167.9   1
183.7   1
169.8   1
177.0   1
179.8   1
169.3   1
172.6   1
169.0   1
183.6   1
180.0   1
185.7   1
179.1   1
190.3   1
161.9   1
177.5   1
174.2   1
180.4   1
160.6   1
165.6   1
168.2   1
164.5   1
169.4   1
174.7   1
176.7   1
178.2   1
183.1   1
188.4   1
173.5   1
180.0   1
170.5   1
174.3   1
173.2   1
182.8   1
193.3   1
171.4   1
172.8   1
160.5   1
173.1   1
168.5   1
177.5   1
166.2   1
170.0   1
186.3   1
177.2   1
169.8   1
181.1   1
183.0   1
166.9   1
180.3   1
173.7   1
168.7   1
179.8   1
171.5   1
170.4   1
171.2   1
178.2   1
181.1   1
182.0   1
183.5   1
178.7   1
170.1   1
162.8   1
183.6   1
182.9   1
175.5   1
176.3   1
171.9   1
171.5   1
172.0   1
174.4   1
165.4   1
186.0   1
181.3   1
170.0   1
173.8   1
172.2   1
178.4   1
167.1   1
170.4   1
181.0   1
172.5   1
171.1   1
165.4   1
174.4   1
162.7   1
166.2   1
180.3   1
166.6   1
170.7   1

find mean and standard deviation of height in females

if height of females from this data is normally distributed with mean and standard deviation you calculated in question 1 find percentage of females who are taller than meghan markle who is 5ft 7 in convert height into centimeters also show how you calculated z-score and area you obtained.

Is meghan's height significant? show work explain findings.

Answer 1

following information has been generated using ms-excel

	female(x)
n=	147
sum=	23768
mean=	161.69
sd=	7.46

here population standard deviation(sd) is calculated as it was not mentioned any where it is a sample.

for height x=5ft 7 inch=67 inches=67*2.54 cm=170.18 cm

z-score=(x-mean)/sd=(170.18-161.69)/7.46=1.1381

P(of females who are taller than meghan markle who is 5ft 7 in)=P(X>170.18)=P(Z>1.1381)=

=1-P(Z<=1.1381)=1-0.8725=0.1275

so proportion of females who are taller than meghan markle who is 5ft 7 in=12.75%

since P(of females who are taller than meghan markle who is 5ft 7 in)=0.1275 which is more than typical value of 0.05, so  meghan's height is not significant.