Statistical Analysis with Excel For Dummies
Book image
Explore Book Buy On Amazon
Poisson can be a very useful tool when approaching statistical analysis with Excel. Not show how it works? Here are the steps for using Excel’s POISSON.DIST:
  1. Select a cell for POISSON.DIST’s answer.
  2. From the Statistical Functions menu, select POISSON.DIST to open its Function Arguments dialog box.
  3. In the Function Arguments dialog box, enter the appropriate values for the arguments. In the X box, enter the number of events for which you’re determining the probability. For this example, you’re looking for pr(1), so enter 1. In the Mean box, enter the mean of the process, which for this example is 1. In the Cumulative box, it’s either TRUE for the cumulative probability or FALSE for just the probability of the number of events. Enter FALSE. With the entries for X, Mean, and Cumulative, the answer appears in the dialog box. The answer for this example is .367879441.
  4. Click OK to put the answer into the selected cell.
excel

In the example, you see the probability for two defective joints in 1,000 and the probability for three. To follow through with the calculations, type 2 into the X box to calculate pr(2), and 3 to find pr(3).

In the 21st century it’s pretty easy to calculate the binomial probabilities directly. The image below shows you the Poisson and the binomial probabilities for the numbers in column B and the conditions of the example. The probabilities are graphed so you can see how close the two really are. Cell D3 was selected, so the Formula bar shows you how BINOM.DIST was used to calculate the binomial probabilities.

9781119271154-fg1905

Although the Poisson’s usefulness as an approximation is outdated, it has taken on a life of its own. Phenomena as widely disparate as reaction time data in psychology experiments, degeneration of radioactive substances, and scores in professional hockey games seem to fit Poisson distributions. This is why business analysts and scientific researchers like to base models on this distribution.

About This Article

This article is from the book:

About the book author:

Joseph Schmuller works on the Digital & Enterprise Architecture Team at Availity. He has taught statistics at the undergraduate and graduate levels. He has created and delivered courses for LinkedIn Learning, and he is the author of all previous editions of Statistical Analysis with Excel For Dummies.

This article can be found in the category: