Z-Score Calculator - Percentile, Outliers and Modified Z

    Z-scores four ways: one value against a mean and SD, every value in a list with outlier flags, z to percentile and percentile to z, plus T-score, stanine and NCE for test reports.

    Parameters

    Enter data for calculations

    Only the boxes for your choice appear

    Form progress0 / 1 fields

    💡 Fill in all required fields to unlock the calculate button

    Z-score calculator for one value, a whole list, or a percentile

    An IQ of 130 on a scale with mean 100 and standard deviation 15 sits exactly 2.00 standard deviations above the mean, higher than 97.7% of a normal population. That is the first of four jobs this z-score calculator does. It also scores every value in a list and flags outliers with the modified z-score that survives an extreme value, turns a z-score into a percentile and a two-tailed p-value, and turns a percentile back into a z-score, both one-sided and two-sided. For single values it adds the equivalent T-score, stanine and NCE, so one result reads on the scales that test reports use.

    68.3%
    of a normal distribution within 1 SD of the mean
    95.4%
    within 2 SD
    99.73%
    within 3 SD

    Four modes and the boxes each one opens

    1. What do you want to calculate - one value against a known mean and SD, z-scores for a list, a z-score to a percentile, or a percentile to a z-score. Only the matching boxes appear, and nothing in a hidden box is used.
    2. Value, mean and standard deviation - all three in the same units, such as test points, centimeters or seconds. The SD must be greater than zero.
    3. List of numbers and the kind of SD - values separated by spaces, commas or new lines, with a dot for decimals. Sample SD divides by n - 1 and fits data drawn from a larger group; population SD divides by n and fits a complete set.
    4. Z-score - any number, negative for values below the mean, such as 1.96 or -1.5.
    5. Percentage - strictly between 0 and 100, such as 95 or 97.5.
    6. Read the result: the z-score or percentile in the main tile, the tiles below it, and, for a list, the table with ordinary and modified z side by side.

    What a z-score measures, and what it does not

    A z-score is a distance measured in standard deviations: z = (value - mean) / SD. The unit disappears in the division, which is the whole point. A reaction time of 62 ms against a mean of 70 and an SD of 5 has z = -1.60, a grade point average of 3.1 against 2.8 and 0.45 has z = 0.67, and the two can now be compared on one ruler even though one is in milliseconds and the other in grade points.

    The z-score itself needs no assumption about the shape of the data. The percentile printed next to it does: it is read from the normal curve, so for strongly skewed data such as incomes or waiting times it can be several points off. When the data are in front of you, the list mode prints the actual rank of each value among the others as well, the way Excel's PERCENTRANK.INC computes it, so the two can be compared.

    One more property matters for outliers. In a list, the extreme value inflates the very SD it is divided by. With n values and a sample SD no z can exceed (n - 1) / √n, which is 2.85 for ten values, so the popular rule "above 3 is an outlier" cannot fire in a short list. The modified z-score of Iglewicz and Hoaglin, 0.6745 × (value - median) / MAD, uses the median and the median absolute deviation, which an outlier cannot move, and flags values above 3.5.

    The z-table in twelve rows

    Each row is what the calculator returns in the z-to-percentile mode. The rows at 1.645, 1.96 and 2.576 are the critical values behind 90%, 95% and 99% confidence intervals.

    z Below Above Between -z and z Two-tailed p
    050.0%50.0%0%100%
    0.569.1%30.9%38.3%61.7%
    184.1%15.9%68.3%31.7%
    1.28290.0%10.0%80.0%20.0%
    1.593.3%6.7%86.6%13.4%
    1.64595.0%5.0%90.0%10.0%
    1.9697.5%2.5%95.0%5.0%
    297.7%2.3%95.4%4.6%
    2.32699.0%1.0%98.0%2.0%
    2.57699.50%0.50%99.00%1.00%
    399.87%0.13%99.73%0.27%
    3.29199.950%0.050%99.900%0.100%

    For a negative z swap the Below and Above columns: z = -1 has 15.9% below it.

    Three kinds of printed z-table, one answer

    Textbooks print the normal table in three layouts, and reading the wrong one is a classic exam mistake. For z = 1.2 the three tables show three different numbers that all describe the same curve:

    Table type Area it gives Entry at z = 1.2
    Cumulative (left tail)everything below z0.8849
    Upper tail (right tail)everything above z0.1151
    Mean to z (center)from 0 up to z0.3849

    The quick check: the first two always add up to 1, and the center entry is the cumulative one minus 0.5. The calculator's "below" tile is the cumulative table, "above" is the upper-tail table, and half of "between -z and z" is the center table. A negative z needs no separate table, because the curve is symmetric: the area below -1.2 equals the area above 1.2.

    One z-score on five reporting scales

    Standardized tests rarely print z itself. They rescale it: a T-score is 50 + 10z, the IQ scale 100 + 15z, a normal curve equivalent 50 + 21.06z, and a stanine is 2z + 5 rounded and held between 1 and 9. The single-value mode prints all of them.

    z Percentile T-score IQ scale Stanine NCE Band
    -2.002.3%30.07017.9unusual
    -1.0015.9%40.085328.9clearly away from the mean
    0.6774.8%56.7110664.0typical
    1.5093.3%65.0122.5881.6clearly away from the mean
    2.0097.7%70.0130992.1unusual

    Standardizing five values by hand

    Take the scores 12, 15, 18, 21 and 24. Their mean is 18 and the squared distances from it are 36, 9, 0, 9 and 36, which sum to 90. Divided by n - 1 = 4 that gives a variance of 22.5 and a sample SD of 4.7434. Each z is then the distance divided by that SD:

    Value Distance from 18 z, sample SD z, population SD Rank in the list
    12-6-1.26-1.410.0%
    15-3-0.63-0.7125.0%
    1800.000.0050.0%
    2130.630.7175.0%
    2461.261.41100.0%

    Two checks worth knowing. The z-scores of any list add up to exactly 0, and with the population SD their squares add up to n, here 5. If a spreadsheet column of z-scores does not sum to zero, a wrong mean went into it. The population column, with its SD of 4.2426 (the square root of 90 / 5), reaches 1.41 at the ends. The largest any z can be in a list of five, with the population SD, is the square root of n - 1, which is 2, and it is reached only when four values are equal and the fifth differs: in 10, 10, 10, 10, 20 the value 20 has z = 2.00.

    Less obvious facts about z-scores

    The outlier that hides itself. In the list 38, 42, 35, 40, 44, 39, 41, 37, 43, 72 the value 72 is far from the rest, yet its ordinary z is only 2.75, because it drags the sample SD up to 10.52. Its modified z is 8.50 (median 40.5, MAD 2.5), well past the 3.5 threshold.
    Sample or population SD changes every z. The same ten values have a population SD of 9.98 instead of 10.52, so each z is about 5% larger in magnitude. Spreadsheets differ here: Excel STANDARDIZE takes whatever SD you pass it, while STDEV.S and STDEV.P give the two versions.
    One-sided and two-sided 95% are different z-scores. The 95th percentile is 1.645; the value that leaves 95% in the middle is 1.960. The percentile mode prints both, because mixing them up is the most common slip in a confidence interval.
    Tables stop, the calculation does not. Printed z-tables usually end near 3.49. At z = 6 the upper tail is about one in a billion, and the calculator still reports it instead of rounding it to zero. That matters in quality work, where six-sigma targets and particle physics discovery claims at five sigma both live far beyond the printed rows.

    What each band of z means for a single value

    |z|, rounded to two places Label in the result Share of a normal population this far out or farther
    below 1typicalmore than 31.7%
    1 to 2clearly away from the mean31.7% down to 4.6%
    2 to 3unusual4.6% down to 0.27%
    3 or moreextreme0.27% or less

    These bands are conventions for describing a distance, not clinical or academic cut-offs. A growth chart, a lab reference range or an admissions policy has its own thresholds, and those win over any generic label.

    Where z-scores turn up outside a statistics class

    Growth charts. Pediatric charts from the WHO report a child's height or weight as a z-score against children of the same age and sex, and the WHO growth standards use -2 and +2 as the lines for stunting, wasting and overweight. The chart supplies its own mean and SD for each month of age, so a generic mean and SD should not be typed in for a child; the chart's own tables apply.

    Bone density. A DEXA scan prints a T-score and a Z-score, and these are not the scale called T-score above. The densitometry T-score compares bone density with young healthy adults, the Z-score with people of the same age, and the WHO definition of osteoporosis sits at a densitometry T-score of -2.5 or lower.

    Test scores. IQ tests, the scale scores of many aptitude tests and school reports built on stanines are all a z-score dressed in a different mean and SD, which is why the scales table above converts freely between them.

    Quality control. Laboratory proficiency testing scores each lab's result as a z-score against the assigned value, and the usual reading is |z| up to 2 satisfactory, between 2 and 3 questionable and 3 or more unsatisfactory. Control charts put their action lines at 3 SD for the same reason: 0.27% of a stable process falls outside by chance.

    Hypothesis tests. A z test statistic is a z-score of the sample mean, measured in standard errors instead of standard deviations, and its two-tailed p-value is exactly the "outside" column of the z-table.

    Z-score questions from the search box

    Is a z-score of 1.5 good?
    On a test where higher is better, yes: 93.3% of a normal population scores lower. A score of 1,350 on a scale with mean 1,050 and SD 200 is exactly that, a T-score of 65.0 and stanine 8.
    What does a negative z-score mean?
    Only that the value is below the mean. z = -1.60 for a 62 ms reaction time is faster than average, so in that case below the mean is the better side; the sign says nothing about good or bad.
    What z-score counts as an outlier?
    The common rule is |z| above 3, but in lists of about ten values or fewer it can never trigger, as shown above. For small lists use the modified z-score above 3.5, which the list mode prints for every value.
    What z-score corresponds to the 90th percentile?
    z = 1.282. For the middle 90% of a distribution the bounds are -1.645 and 1.645 instead.
    How do I calculate a z-score in Excel or Google Sheets?
    Use =STANDARDIZE(value, mean, sd), or write it out as =(A2-AVERAGE(A$2:A$11))/STDEV.S(A$2:A$11). For the percentile use =NORM.S.DIST(z, TRUE), and for the reverse =NORM.S.INV(0.95), which returns 1.645. Swap STDEV.S for STDEV.P to match the population option here.
    How many values beyond z = 3 should I expect in a large data set?
    About 0.27% of normally distributed values, so roughly 27 in 10,000 and 2.7 in 1,000. Finding a handful in a large file is therefore normal. Finding hundreds more than that usually means heavy tails, a mixture of two groups or data-entry errors.

    Related tools

    R Squared Calculator

    How much of the variance a model explains, from predictions or from SSE and SST - See calculator

    Percentile Calculator

    Percentiles from your own data by Excel INC, EXC and nearest rank, no normal curve assumed - See calculator

    Interquartile Range Calculator

    Tukey fences, the other outlier rule that does not depend on the SD - See calculator

    Skewness Calculator

    Checks whether the normal-curve percentiles can be trusted for your data - See calculator

    Coefficient of Variation Calculator

    Compares spread across data sets with different means - See calculator

    Standard Deviation Calculator

    The SD for the denominator, sample or population - See calculator

    Linear Regression Calculator

    Standardized residuals are z-scores of the errors around a fitted line - See calculator

    Similar calculators from this section