CODEWITHSUNDEEP
rgoogle-sheetspoisson
Homer Jay Simpson
Homer Jay Simpson

Reputation: 1224

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 ?

Upvotes: 1

Views: 102

Answers (1)

Ric
Ric

Reputation: 5721

Poisson is a limiting case of binomial:

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

Upvotes: 3

Related Questions