Question

John knows that monthly demand for his product follows a normal distribution with a mean of 2,500 units and a standard deviation of 425 units. Given this, please provide the following answers for John.

a. What is the probability that in a given month demand is less than 3,000 units?

b. What is the probability that in a given month demand is greater than 2,200 units?

c. What is the probability that in a given month demand is between 2,200 and 3,000 units?

d. What is the probability that demand will exceed 5,000 units next month?

e. If John wants to make sure that he meets monthly demand with production output at least 95% of the time. What is the minimum he should produce each month?

Present in excel with formulas

Answer 1

a)

P(x< 3000)
= P(z < ( 3000 - 2500)/425)
= P(z < 1.1765)
= 0.8803 ... By using excel : =NORM.DIST(1.1765,0,1,TRUE)

b)

P(x> 2200)
= P(z < ( 2200 - 2500)/425)
= P(z > -0.7059)
= 0.7599... By using excel : 1 - =NORM.DIST(-0.7059,0,1,TRUE)

c)
P(2200 < x < 3000)

= P((2200 - 2500)/425 < z < ( 3000 - 2500)/425)
= P( -0.7059 < z < 1.1765)
= 0.6402

d)

P(x> 5000)
= P(z < ( 5000 - 2500)/425)
= P(z >5.8824)
= 1... By using excel : 1 - =NORM.DIST(1,0,1,TRUE)

e)
z value at 95% = 1.645
By using excel: =NORM.INV(0.95,0,1)

z = (x -mean)/s
1.645 = ( x - 2500)/425
x = 3199.062791