Poisson function

g.ganivet

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:

https://support.microsoft.com/en-au/help/828130/excel-statistical-functions-poisson

 

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