Percentile of Normal Distribution- Calculation Methods and Examples
What Is a Percentile in a Normal Distribution?
A percentile tells you where a value falls relative to everyone else. If your score is at the 90th percentile, you scored higher than 90% of people. Simple enough.
Normal distribution is that bell curve you remember from stats class. Most values cluster around the mean, with tails stretching out symmetrically on both sides. When you want to find what percentile a specific value belongs to, you're asking: what percentage of the distribution falls below this point?
This comes up constantly in real life. Test scores, medical readings, IQ results, manufacturing tolerances. If the data follows a normal distribution, percentiles give you a way to interpret where any given value sits.
The Z-Score: Your Foundation
Before you can find percentiles, you need Z-scores. A Z-score tells you how many standard deviations a value is from the mean.
The Formula
Z = (X - μ) / σ
Where:
- X is the value you want to analyze
- μ is the population mean
- σ is the standard deviation
Example: Test scores average 100 with a standard deviation of 15. A score of 130 gives you:
Z = (130 - 100) / 15 = 2.0
This means 130 is exactly 2 standard deviations above the mean.
Converting Z-Score to Percentile
Once you have your Z-score, you convert it to a percentile using the cumulative distribution function (CDF). The CDF tells you the probability that a value falls below your Z-score.
For Z = 2.0, the CDF is approximately 0.9772. That puts you at roughly the 97.7th percentile. You scored higher than about 97.7% of test-takers.
Reading the Z-Table
Z-tables give you the cumulative probability for a given Z-score. You find your Z-value in the left column (for 2.0) and then the decimal place in the top row (for .00), then read where they intersect.
For negative Z-scores, the table still works. Z = -1.5 corresponds to approximately the 6.7th percentile. About 6.7% of values fall below this point.
Calculation Methods Compared
You have several ways to get this done. Here's what you're working with:
| Method | Speed | Accuracy | Best For |
|---|---|---|---|
| Z-table lookup | Medium | 2-3 decimal places | Exams, quick estimates |
| Scientific calculator | Fast | High | One-off calculations |
| Online calculators | Fastest | High to very high | Most practical work |
| Excel/Google Sheets | Fast | Very high | Batch calculations |
| Python/R programming | Fastest for volume | Very high | Data analysis, automation |
Pick based on your situation. If you're studying for an exam, learn the Z-table. If you're doing actual work, use software.
How to Calculate Percentile from Normal Distribution
Step 1: Gather Your Numbers
You need three things: your value (X), the mean (μ), and the standard deviation (σ). Without these, you can't proceed.
Step 2: Calculate the Z-Score
Subtract the mean from your value, then divide by the standard deviation. Write it down or enter it into your tool.
Step 3: Find the Cumulative Probability
Use one of these approaches:
- Look up your Z-score in a Z-table
- Use the NORM.S.DIST function in Excel:
=NORM.S.DIST(Z, TRUE) - Use a calculator:
normalCDF(-∞, Z) - Use Python:
scipy.stats.norm.cdf(Z)
Step 4: Convert to Percentile
Multiply the cumulative probability by 100. That's your percentile.
Cumulative probability 0.8413 × 100 = 84.13th percentile
Worked Examples
Example 1: Adult Height
Average adult male height is 175 cm with a standard deviation of 7 cm. What percentile is a man who is 188 cm tall?
Step 1: X = 188, μ = 175, σ = 7
Step 2: Z = (188 - 175) / 7 = 13/7 = 1.86
Step 3: CDF of 1.86 ≈ 0.9686
Step 4: 0.9686 × 100 = 96.86th percentile
This man is taller than roughly 97% of adult males.
Example 2: Low Test Score
An exam has a mean of 72 and standard deviation of 8. A student scored 60. What percentile is this?
Step 1: X = 60, μ = 72, σ = 8
Step 2: Z = (60 - 72) / 8 = -12/8 = -1.5
Step 3: CDF of -1.5 ≈ 0.0668
Step 4: 0.0668 × 100 = 6.68th percentile
This score is below roughly 93% of test-takers.
Example 3: Finding the Value for a Percentile
You want to know what test score corresponds to the 75th percentile. Mean is 70, standard deviation is 10.
Step 1: Target percentile = 75, so CDF = 0.75
Step 2: Find the Z-score where CDF = 0.75. This is approximately Z = 0.674
Step 3: X = μ + (Z × σ) = 70 + (0.674 × 10) = 70 + 6.74 = 76.74
A score of about 77 puts you at the 75th percentile.
Using Excel for Percentile Calculations
Excel has built-in functions that handle this directly:
To find percentile from value:
=NORM.DIST(X, mean, std_dev, TRUE)
To find value from percentile:
=NORM.INV(probability, mean, std_dev)
Example: =NORM.INV(0.90, 100, 15) returns 119.2. A score of about 119 is at the 90th percentile when mean is 100 and SD is 15.
Common Mistakes That Mess Up Your Results
- Using sample standard deviation when you need population standard deviation — check which one your context requires. They use different formulas.
- Confusing one-tailed and two-tailed probability — most percentile calculations use one-tailed. Make sure your method matches your need.
- Forgetting to multiply by 100 — the CDF gives you a probability between 0 and 1. Multiply by 100 for a percentile.
- Assuming normality when data isn't normal — percentiles from a normal distribution model are only valid if your data actually follows that distribution. Test it first with a histogram or Shapiro-Wilk test.
When Normal Distribution Doesn't Apply
Not everything follows a bell curve. Income distribution, website traffic, and many biological measurements are skewed. If your data is clearly non-normal, calculating percentiles using normal distribution assumptions will give you wrong answers.
For non-normal data, use empirical percentiles instead. Sort your data, count the values below your target, divide by total count. Excel's PERCENTILE.EXC or PERCENTILE.INC functions do this automatically.
The Bottom Line
Finding percentiles in a normal distribution comes down to three steps: calculate the Z-score, find the cumulative probability, convert to a percentage. The method you use depends on how many calculations you're doing and what tools you have access to.
For occasional use, a Z-table or online calculator works fine. For recurring work or large datasets, learn the Excel functions or basic Python. Once you understand the logic, the tools are just shortcuts.