# quantitative analysis 31

**Must show work in Excel and attach as document. **

** 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?**