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.
Search JabSto ::




Custom Search