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




Custom Search