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!
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!