Please verify that the poisson probability is correct, I calculated it in excel

Question

Please verify that the poisson probability is correct, I calculated it in excel but I am not sure if I did it correctly, if not please inform how to find excel. Thank you.

Mu 7 f(x) probability Cumulative 0 0.000911882 0.000911882 1 0.006383174 0.007295056 2 0.022341108 0.029636164 3 0.052129252 0.081765416 4 0.091226192 0.172991608 5 0.127716668 0.300708276 6 0.14900278 0.449711056 7 0.14900278 0.598713836 8 0.130377432 0.729091268 9 0.10140467 0.830495937 10 0.070983269 0.901479206 11 0.045171171 0.946650377 12 0.02634985 0.973000227 13 0.014188381 0.987188607 14 0.00709419 0.994282798 15 0.003310622 0.99759342 16 0.001448397 0.999041817 17 0.000596399 0.999638216 18 0.000231933 0.999870149 19 8.5449E-05 0.999955598 20 2.99071E-05 0.999985505

Explanation / Answer

in excel you need to write formula for probability =poisson(x,7,false)

I have calculated above and find no error in your calculation; please revert for any clarification required

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---