Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Economics (https://www.askmehelpdesk.com/forumdisplay.php?f=101)
-   -   Normal Distribution Stats Econ (https://www.askmehelpdesk.com/showthread.php?t=321626)

  • Feb 24, 2009, 04:22 PM
    phatinium
    Normal Distribution Stats Econ
    Weekly demand at a grocery store for a brand of cereal is normally distributed according to X ~ N(800 boxes, 752 boxes).

    a. What is the probability that the demand next week is less than 959 boxes?
    b. What is the probability that the demand next week is more than 1004 boxes?
    c. How many boxes should the store order for next week to have only a 2.5 percent chance of running short of the cereal?
  • Mar 7, 2009, 03:18 PM
    kurtwz

    If you still need this try Excel:

    a) =normdist(959,800,752,true) (.5837)
    b) =1-normdist(1004,800,752,true) (.3931)
    c) Use solver and set target cell to value of .975 (2274)

  • All times are GMT -7. The time now is 12:52 PM.