Question: Use the NORM.DIST function to calculate the following probabilities, X ~ N(100, 25): (a) P(X 95); (b) P(95 X 105); (c) P(105

Use the NORM.DIST function to calculate the following probabilities, X ~ N(100, 25):

(a) P(X ≤ 95); 

(b) P(95 ≤ X ≤ 105); 

(c) P(105 ≤ X ≤ 115);  

(d) P(93 ≤ X ≤ 99). 

For each probability identify the region to be found by shading the area on the normal probability distribution graph.

Step by Step Solution

3.29 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To calculate these probabilities using the NORMDIST function in Excel you can use the following fo... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Statistics Using Excel Questions!