How can the Inverse Cumulative Distribution Function of the Poisson distribution be computed using Excel?

edit

The Inverse Cumulative Distribution Function of the Poisson distribution can be computed using Excel by using the "=POISSON.INV(probability,mean)" function.

• "probability" is the probability of the event occurring
• "mean" is the average rate of occurrence

For example, if we want to find the value of x such that P(X <= x) = 0.8 for a Poisson distribution with a mean of 5, we can use the following formula in Excel:

=POISSON.INV(0.8, 5)

Excel will return the value of x where P(X <= x) = 0.8, which in this case is 8.