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

This is what you have to use to solve the probability equation:

A. = NORM.DIST(73,71,1.2,TRUE) = .95221

B = 1-NORM.DIST(67,71,1.2,TRUE) = .99957

C = =NORM.DIST(74,71,1.2,TRUE)-NORM.DIST(69,71,1.2,TRUE) = .946

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

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