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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.