Poisson function


My customer needs to calculate the POISSON cumulative results to find out the lambda value that goes above a probability treshold.

In a maintenance use case, this is useful for him to statistically determine given a target service level and the past average of incidents how many incidents should occur in the future, and therefore calculate the associated costs.


Excel has a built-in function to perform this calculation, and a specific iterative algorithm since 2003 to manage the calculation even for big numbers.


See the article below for further details and attached spreadsheet as an example:



It would be helpful if that kind of statistical function would be available out of the box in Anaplan!


8 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!