Microsoft Office Tutorials and References

In Depth Information

**Using NORM. DIST and POISSON. DIST to Determine Probabilities**

10. In the cell below, enter a formula that multiplies the number of

working days per month (22) by the result just calculated with the

POISSON.DIST function.

In our worksheet, this formula is =22*B3, entered in cell B4.

11. If desired, enter a label in an adjacent cell to identify this as the

numberofdayspermonthyoucanexpecttohave20orfewerdefects.

The finished worksheet is shown in Figure 11-12. In this example, I have

formatted cells B3:B4 with two decimal places. You can see that with an average

of 25 defects per day you can expect to earn a bonus 4 days a month.

Figure 11-12:

Using the

POISSON.

DIST

function to

calculate a

cumulative

probability.