Microsoft Office Tutorials and References

In Depth Information

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

3. Click the cell containing the lower limit value (49.9) or enter the cell

address.

4. Enter a comma (
,).

5. Click the cell containing the mean, or enter the cell address.

6. Enter a comma (
,).

7. Click the cell containing the standard deviation, or enter the cell

address.

8. Enter a comma (
,).

9. Enter
TRUE)
.

10. Press Enter to complete the function.

This cell now displays the probability of a bolt being less than or equal

to the lower limit.

11. In another cell, enter
=NORMDIST(
to start the function entry.

12. Click the cell containing the upper-limit value (50.1), or enter the cell

address.

13. Repeat Steps 4 through 10.

This cell now displays the probability of a bolt being less than or equal

to the upper limit.

14. In another cell, enter a formula that subtracts the lower-limit

probability from the upper-limit probability.

This cell now displays the probability that a bolt will be within the

specified limits.

Figure 11-8 shows a worksheet that was created to solve this problem. You

can see from cell B8 that the answer is 0.9545 — in other words, 95.45

percent of your bolts fall in the prescribed limits, and you can accept the

customer’s order. Note in this worksheet that the formulas in cells B6:B8 are

presented in the adjacent cells so you can see what they look like.

Figure 11-8:

Using the

NORM.DIST

function to

calculate

probabilities.