Administration and Executive AssistantTier 630 minadvanced

Probability with NORM.DIST

Find the probability a measurement falls below a spec limit, using the cumulative form of NORM.DIST.

What you will learn

• Use NORM.DIST with cumulative set to TRUE to find a probability
• Explain the difference between the cumulative probability and the density NORM.DIST returns when cumulative is FALSE
• Apply NORM.DIST to a quality-control question about the chance of an out-of-spec reading

Excel skills

NORM.DIST · Probability Distributions

The task

A production process's measurements follow a normal distribution. Work out the probability that a unit falls below the spec limit and gets rejected, in Summary!B6.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free