Free percentile calculator: find the P-th percentile from a dataset, calculate percentile rank of a value, or convert between z-scores and percentiles. Step-by-step solutions.
Math
global
Percentile Calculator, Math, Free percentile calculator: find the P-th percentile from a dataset, calculate percentile rank of a value, or convert between z-scores and percentiles. Step-by-step solutions., percentile rank, z-score converter, dataset percentile, statistical ranking, calc, compute
Percentile Calculator
Free percentile calculator: find the P-th percentile from a dataset, calculate percentile rank of a value, or convert between z-scores and percentiles. Step-by-step solutions.
Percentile Calculator, Math, Free percentile calculator: find the P-th percentile from a dataset, calculate percentile rank of a value, or convert between z-scores and percentiles. Step-by-step solutions., percentile rank, z-score converter, dataset percentile, statistical ranking, calc, compute
Percentile Calculator
Free percentile calculator: find the P-th percentile from a dataset, calculate percentile rank of a value, or convert between z-scores and percentiles. Step-by-step solutions.
10 values parsed. Supports commas, spaces, tabs, or new lines.
P75
0th25th (Q1)50th75th (Q3)100th
75th Percentile
69.7500
10 valuesExcel method
Percentile Summary
Key percentiles & statistics from your dataset
10th Percentile (P10)
17.4000
25th Percentile (Q1)
26.2500
50th Percentile (Median)
47.5000
75th Percentile (Q3)
69.7500
90th Percentile (P90)
86.9000
IQR (Q3 − Q1)
43.5000
Interquartile range
Count
10
Mean
49.60
Min
12
Max
95
Distribution Overview
Where values fall across percentiles
P1017.4000
Q1 (P25)26.2500
Median (P50)47.5000
Q3 (P75)69.7500
P9086.9000
Step-by-Step Solution
How this result was calculated
Formula
rank = (P / 100) × (n − 1)
Step 1: Sort the 10 values in ascending order
Step 2: Calculate the rank index
rank = (75 / 100) × (10 − 1) = 6.7500
Step 3: Interpolate between positions 6 and 7
63 + 0.7500 × (72 − 63) = 69.7500
Sorted Dataset
10 values, sorted ascending
12182530405563728695
What Is a Percentile?
Understanding percentiles in statistics
A percentile indicates the value below which a given percentage of observations fall. If you score at the 90th percentile on a test, 90% of test-takers scored lower than you. Percentiles are widely used in standardized testing, growth charts, income analysis, and any context where you need to understand relative standing.
Excel-compatible formula (interpolation)
rank = (P / 100) × (n − 1)
Percentile vs. percentage: A percentage is a fraction of 100 (e.g., you got 85% of questions right). A percentile is a ranking among a group (e.g., your score is higher than 85% of all test-takers). They measure different things — one is absolute, the other is relative.
Calculation Methods Compared
How different formulas produce different results
Interpolation (Excel / Google Sheets)
Calculates a fractional rank and linearly interpolates between adjacent values. This is the method used by Excel's PERCENTILE() function, Google Sheets, and most spreadsheet software. It produces smooth results even for small datasets.
rank = (P/100) × (n−1), then interpolate
Nearest Rank
Rounds up to the nearest whole rank and returns that value directly. Simpler and commonly taught in statistics courses. Always returns an actual value from the dataset, never an interpolated one.
Nearest rank: rank = ⌈0.75 × 10⌉ = 8 → value at position 8 = 15
Different methods, different answers — choose based on your use case.
Normal Distribution & Z-Scores
Converting between values, z-scores, and percentiles
When data follows a normal (bell curve) distribution, you can convert any value to a percentile using the z-score formula: z = (x − μ) / σ. The z-score tells you how many standard deviations a value is from the mean.
Common Z-Score to Percentile Conversions
z = −2.0 → 2.28th
z = −1.0 → 15.87th
z = 0.0 → 50th
z = 1.0 → 84.13th
z = 1.645 → 95th
z = 1.96 → 97.5th
z = 2.0 → 97.72th
z = 2.576 → 99.5th
The normal distribution mode in this calculator lets you convert in both directions: enter a value to find its percentile, or enter a percentile to find the corresponding value. Useful for test scoring, quality control, and scientific research.
Percentiles in Excel & Google Sheets
Built-in formulas for percentile calculations
Find a Percentile Value
=PERCENTILE(A1:A100, 0.75)
=PERCENTILE.INC(A1:A100, 0.75)
=PERCENTILE.EXC(A1:A100, 0.75)
=QUARTILE(A1:A100, 3)
Find Percentile Rank
=PERCENTRANK(A1:A100, 50)
=PERCENTRANK.INC(A1:A100, 50)
=PERCENTRANK.EXC(A1:A100, 50)
=NORM.DIST(x, mean, sd, TRUE)
Note: PERCENTRANK uses linear interpolation. This calculator uses the midrank formula, which may give different results for small datasets or tied values.
INC vs EXC: PERCENTILE.INC includes 0 and 1 as valid percentile inputs (inclusive), while PERCENTILE.EXC excludes them (exclusive). For most uses, the inclusive version (which matches our interpolation method) is standard.
Frequently Asked Questions
Common questions about percentiles, percentile rank, z-scores, and quartiles
Sort your data in ascending order, then use the formula rank = (P/100) × (n−1) where P is the target percentile and n is the number of values. If the rank is not a whole number, interpolate between the two adjacent values. For example, the 75th percentile of {3, 6, 7, 8, 10} has rank = 0.75 × 4 = 3, so the value is 8.
A percentage is a fraction of 100 — for example, scoring 85% on a test means you got 85 out of 100 questions right. A percentile is a ranking — being at the 85th percentile means your score is higher than 85% of all test-takers. One measures absolute performance, the other measures relative standing.
Percentile rank indicates a value's relative standing within a dataset. This calculator uses the midrank formula: PR = (L + 0.5×E) / N × 100, where L is the number of values strictly below your value, E is the number of values equal to it, and N is the total count. This differs from Excel's PERCENTRANK function, which uses linear interpolation between data points. For small datasets or values with ties, the two methods can give noticeably different results. Because equal values are counted at half weight in the midrank formula, the maximum possible rank with unique values is (N − 0.5) / N × 100, not 100.
The interpolation method (used by Excel's PERCENTILE function) calculates a fractional position and averages between two adjacent values, producing smoother results. The nearest rank method rounds up to the next whole position and returns that exact value from the dataset. For large datasets, results are similar; for small datasets, they can differ significantly.
A z-score tells you how many standard deviations a value is from the mean in a normal distribution. To convert to a percentile, use the standard normal cumulative distribution function (CDF). Common conversions: z=0 is the 50th percentile, z=1.0 is the 84.13th, z=1.645 is the 95th, z=1.96 is the 97.5th, and z=2.576 is the 99.5th percentile.
Use =PERCENTILE(range, k) where range is your data and k is a decimal between 0 and 1 (e.g., 0.75 for the 75th percentile). For percentile rank, Excel's =PERCENTRANK(range, value) uses linear interpolation between data points, which differs from this calculator's midrank method. Both are valid — the midrank formula handles ties more symmetrically, while PERCENTRANK interpolates. Excel also offers PERCENTILE.INC (inclusive, same as PERCENTILE) and PERCENTILE.EXC (exclusive) variants.
Quartiles are specific percentiles that divide data into four equal parts. Q1 (first quartile) = 25th percentile, Q2 (median) = 50th percentile, Q3 (third quartile) = 75th percentile. The Interquartile Range (IQR) is Q3 − Q1 and measures the spread of the middle 50% of data. It's commonly used to identify outliers.
The 90th percentile (P90) is the value below which 90% of observations fall. It's commonly used in performance monitoring (e.g., 90th percentile response time means 90% of requests are faster than this), salary analysis, and standardized testing. P90 is more stable than the maximum value because it ignores extreme outliers.
Yes. Dataset-based percentile calculations work with any distribution — they just sort and rank the actual data. The normal distribution mode (z-score conversion) assumes a bell curve, which is appropriate for many natural phenomena. If your data is heavily skewed, use the dataset mode instead of the normal distribution mode for accurate results.
Embed Percentile Calculator
Add this calculator to your website or blog for free.
ganak.app