Results 1 to 12 of 12

Poisson distribution

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    8

    Poisson distribution

    New to macro in excel. Need to implement Poisson distribution in a macro. The attached sheet has details. Need the stock level for 80% 90% 95%. So basically a number in k5 that will generate 80% Poisson Probability. This can be done manually ofcourse. Need to automate this process for the values in columns L M N.Obviously ignore 0 cells in those columns.


    For the first case stock level 2 is close to 84% instead of 80% which will work. But there wil be no stock level for 90% and a stock level of 3 fore 95%.

    In short is there a way to fill out Q R S through a macro?
    Last edited by hnasir; 05-19-2012 at 12:46 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1