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

Home > front end > Is there a qpois() R equivalent in google sheet?

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

Time：11-13

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 ?

CodePudding user response：

Poisson is a limiting case of binomial:

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