It is a poisson distribution problem and =POISSON.DIST excel formula can be used.
I. "P(=0)" =POISSON.DIST(0,4,FALSE) which yields 0.018316
ii. P(=1) =POISSON.DIST(1,4,FALSE) which yields 0.073263
4. P(=10)=POISSON.DIST(10,2,FALSE) which yields "3.81899E-05"
Comments
Leave a comment