Revision history [back]
 | 1 | initial version |
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.