The excel command NORM.DIST (x, mean, std_dev, true) returns the value of P( X <

Question

The excel command NORM.DIST (x, mean, std_dev, true) returns the value of P( X </ x) for the normal curve with the given mean and standard deviation.  Include both the answer and the command to find the answer, round to 5 decimal places.

The height of male students at a certain university is normally distributed with a mean of 71 inches with a standard deviation of 1.2 inches.

A) What is the probability that a male student height is at most 73 inches?

B) What is the probability that a male student height is at least 67 inches?

C) What is the probability that a male student height is between 69 and 74 inches?

Explanation / Answer

Mean is 71 and s is 1.2

A) P(x<73)=NORM.DIST(73,71,1.2,TRUE)=0.9522

B) P(x>67)=1-NORM.DIST(67,71,1.2,TRUE)=0.9996

C) P(69<x<74)=P(x<74)-P(x<69)=NORM.DIST(74,71,1.2,TRUE)-NORM.DIST(69,71,1.2,TRUE)=0.946

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.