rgoogle-sheetspoisson

Is there a qpois() R equivalent in google sheet?

I want to calculate in Google Sheet the quantile function of Poisson distribution.

For example in R :

> qpois(p=0.90,lambda=5)
[1] 8

I have searched the web in order to find any equivalent function in google sheet but I haven't found anything.

Is there any function that I don't know or I came across ?

Solution

  • Poisson is a limiting case of binomial:

    =BINOM.INV(100000, 5/100000, 0.9)
=8