Administration and Executive AssistantTier 630 minadvanced

Cutoffs with NORM.INV

Find the score that marks the top slice of a distribution, using the right probability, not its mirror image.

What you will learn

• Use NORM.INV to find the value at a given percentile of a normal distribution
• Explain why "the top 5%" corresponds to the 95th percentile, not the 5th
• Recognise that using the wrong tail produces a plausible-looking value on the wrong side of the mean

Excel skills

NORM.INV · Probability Distributions

The task

Scores follow a normal distribution. Find the score where the top 5% of the class begins, in Summary!B5.

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