Question

the height of men in the united states is normally distributed with a mean of 69 inches and a standard deviation of 4 inches. complete the input for the spreadsheet program to calculate the probability that a man in the u.s. chosen at random will be shorter than 64 inches. then identify this probability and round the answer to the nearest tenth. (2 points)

complete the table to calculate normal

distribution using given parameters

	a	b	c	d	e
2	standard deviation	☐
3	x	☐
4	cumulative	true
5	=normdist(b3, b1, b2, b4)	☐%

Explanation:

Step1: Fill table parameters

Mean (B1)=69, Std Dev (B2)=4, x (B3)=64

Step2: Calculate z-score

$z=\frac{64-69}{4}=-1.25$

Step3: Find cumulative probability

Use norm.dist(64,69,4,TRUE)=~0.1056

Step4: Convert to percentage

$0.1056\times100\approx10.6\%$

Answer:

Table filled values: B1=69, B2=4, B3=64; Probability≈10.6%