Excel Binomial Distribution Professional Hockey Games

Not show how it works Here are the steps for using Excels POISSON.DIST.

In the X box, enter the number of events for which youre determining the probability.

In the Mean box, enter the mean of the process, which for this example is 1.

Enter FALSE. With the entries for X, Mean, and Cumulative, the answer appears in the dialog box.

To follow through with the calculations, type 2 into the X box to calculate pr (2), and 3 to find pr (3).

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.

Excel Binomial Distribution Professional Hockey Games

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.

He is a former member of the American Statistical Association and has taught statistics at the undergraduate, honors undergraduate, and graduate levels.

Excel For Mac Binomial Distribution