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

add a comment

3

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.

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Asked: ** 2021-08-15 11:00:00 +0000 **

Seen: **10 times**

Last updated: **May 05 '22**

What is the method for obtaining the integral of a function that represents monthly distribution?

What does it mean when a CloudFront distribution sends back an Error 400?

What is the procedure for performing histogram matching using a normal distribution as a reference?

Can you create a chart in Excel that displays the completion status of actions by month?

What is the process of moving information from one tab to another in Excel by transposing it?

Copyright QStack.ai, 2010-2023. Content on this site is licensed under the Creative Commons Attribution Share Alike 3.0 license.