Z-Score Calculator Standardise a value, and see its percentile on the normal curve

Enter a value, the mean and the standard deviation. The z-score tells you how many standard deviations the value sits above or below the mean.

z = (x − μ) ÷ σ

Z-score
standard deviations from the mean
Percentile (area below)
Area above

Do this in Excel or Google Sheets

ResultFormula
Z-score=STANDARDIZE(x, mean, sd) or =(x-mean)/sd
Percentile (area below)=NORM.S.DIST(z, TRUE)
Z-score from a data set=(A1-AVERAGE($A$1:$A$99))/STDEV.P($A$1:$A$99)

Z-scores are the first step into statistics and data modelling — territory my Excel and Power BI courses cover in depth.

Learn Excel & Power BI with my courses →

What a z-score tells you

A z-score, or standard score, rewrites a value in terms of standard deviations from the mean. A z of 0 sits exactly at the mean; +1.5 is one-and-a-half standard deviations above it; −2 is two below. Because it strips out the original units, you can compare values from completely different scales — a maths mark against an English mark, for instance.

Z-score and percentile

If the data is roughly normally distributed, the z-score maps to a percentile. This tool estimates the area below the z-score using the standard normal distribution, so a z of about +1.28 lands near the 90th percentile.

Frequently asked questions

Can a z-score be negative?

Yes. A negative z-score simply means the value is below the mean; a positive one means it's above.

Why is the percentile only an estimate?

The percentile assumes a normal (bell-shaped) distribution. If your data is heavily skewed, treat it as an approximation.

What if the standard deviation is zero?

A z-score can't be computed when σ is 0, because every value equals the mean and there's no spread to divide by.