Ask Your Question
4

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

asked 2021-08-15 11:00:00 +0000

lakamha gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

answered 2022-05-05 02:00:00 +0000

djk gravatar image

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.

edit flag offensive delete link more

Your Answer

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

Add Answer


Question Tools

Stats

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

Seen: 15 times

Last updated: May 05 '22