This is the z-table used backwards. You can enter a left area (a percentile), a right area, the middle area of a confidence level, or the total of both tails (α). Add a mean and standard deviation to turn z into a raw score.
z = 1.6449
Rounded for the table: z ≈ 1.64.
Type 0.95 or 95% (either works). Values come from the standard normal distribution, accurate to 4 decimals. The table rows are the 5-decimal areas from our z-table.
Question (illustrative numbers): exam scores are normal with mean 70 and standard deviation 10. What score marks the 90th percentile?
Step 1. Left area: the 90th percentile has 0.90 of the area to its left.
Step 2. Read the z-table backwards: 0.90 falls between Φ(1.28) = 0.89973 and Φ(1.29) = 0.90147. The closer entry is z = 1.28; the exact value is z = 1.2816.
Step 3. Convert: x = μ + zσ = 70 + 1.2816 × 10 = 82.8.
Answer: a score of about 82.8 is the 90th percentile. Click “90th percentile” above and enter 70 and 10 to check it.
Find the left area that equals the percentile, then read the z-table backwards: look for that area in the body of the table and take its row and column. For the 90th percentile, 0.90 falls between Φ(1.28) = 0.89973 and Φ(1.29) = 0.90147, so z ≈ 1.28. The exact value is 1.2816.
z = 1.645 (1.6449 to four decimals). In the z-table, 0.95 sits between 0.94950 at z = 1.64 and 0.95053 at z = 1.65, which is why textbooks round it to 1.645. It is also the one-tailed critical value for α = 0.05.
z = 1.960. If 95% of the area is between −z and z, each tail holds 2.5%, so the left area at z is 0.975. The z-table has 0.97500 exactly at z = 1.96. For 90% it is 1.645 and for 99% it is 2.576.
Subtract the right area from 1 to get the left area, then look that up. For a right-tail area of 0.05, the left area is 0.95 and z = 1.645. Choose “Right area” in the calculator and it does the subtraction for you.
Use x = μ + zσ. With mean 70 and standard deviation 10, the 90th percentile is 70 + 1.2816 × 10 = 82.8. Enter a mean and standard deviation in the calculator to get x directly.
Use =NORM.S.INV(p) for a left area p, for example =NORM.S.INV(0.95) returns 1.6449. For a raw score use =NORM.INV(p, mean, sd). Google Sheets accepts the same formulas.
No. The z-score calculator goes from a raw score to z. This page goes the other way, from an area or percentile to z. To turn a z-score into an area, use the z-table or the area between two z-scores calculator.