What Is the Percentile Formula?
The percentile formula gives the percentage of values in a dataset that fall below a given value. For a value $x$ in a dataset of $N$ values:
$P = \frac{\text{number of values below } x}{N} \times 100$
A percentile of $90$ means $90%$ of the data sits below that value. The result is always between $0$ and $100$. Before applying the formula, the data must be sorted in ascending order — percentile is about position, and position only exists once the values are in order.
How Do You Calculate a Percentile?
There are two questions people ask, and each has its own direction of the formula. Which one am I solving — the rank of a known value, or the value at a known rank?
Direction 1 — the percentile of a value (rank-based). Count how many values lie below $x$, divide by the total, multiply by $100$:
$$P = \frac{n}{N} \times 100$$
where $n$ is the count of values below $x$ and $N$ is the total number of values.
Direction 2 — the value at a given percentile. To find which value sits at the $k$th percentile, compute the position in the sorted list:
$$i = \frac{k}{100} \times N$$
If $i$ is a whole number, the $k$th percentile is the average of the values in positions $i$ and $i+1$. If $i$ is not whole, round up, and take the value in that position. (Statistics texts and software offer a few variants of this rule, but this is the standard introductory method.)
Percentile Is Not Percentage
This is the distinction that causes the most confusion, so it earns its own line: a percentage is a score out of 100; a percentile is a rank against other people. Scoring $80%$ on a test means you got $80$ of every $100$ marks. Being in the $80$th percentile means you scored higher than $80%$ of the people who took it. A student can score $60%$ and still land in the $95$th percentile if the test was hard for everyone.
Examples of Percentile Formula
Example 1
In the sorted scores $20, 35, 40, 55, 60, 70, 80, 90$, find the percentile of $70$.
Values below $70$: there are $5$ ($20, 35, 40, 55, 60$). Total $N = 8$.
$$P = \frac{5}{8} \times 100 = 62.5$$
Final answer: $70$ is at the $62.5$th percentile.
Example 2
In the dataset $12, 55, 7, 10, 40$, find the percentile of $40$.
Wrong attempt. A common first move is to apply the formula to the data as written: count values below $40$ in the unsorted list. Worse, some count $40$ itself or miscount because the list looks jumbled — getting $n = 4$ and reporting $80$th percentile.
Correct. Sort first: $7, 10, 12, 40, 55$. Now count values strictly below $40$: there are $3$ ($7, 10, 12$). Total $N = 5$.
$$P = \frac{3}{5} \times 100 = 60$$
Final answer: $40$ is at the $60$th percentile. Sorting before counting is the step that makes the count trustworthy.
Example 3
In the sorted set $15, 20, 35, 40, 50$, find the percentile of $35$.
Values below $35$: $2$ ($15, 20$). $N = 5$.
$$P = \frac{2}{5} \times 100 = 40$$
Final answer: $35$ is at the $40$th percentile.
Example 4
Find the value at the $50$th percentile (the median) of $2, 4, 6, 8, 10, 12$.
$$i = \frac{50}{100} \times 6 = 3$$
Since $i = 3$ is a whole number, average positions $3$ and $4$: $\frac{6 + 8}{2} = 7$.
Final answer: the $50$th percentile is $7$ — exactly the median.
Example 5
Find the value at the $25$th percentile (the first quartile) of $5, 8, 11, 14, 17, 20, 23$ ($N = 7$).
$$i = \frac{25}{100} \times 7 = 1.75$$
$i$ is not whole, so round up to position $2$.
Final answer: the $25$th percentile is $8$, the value in the 2nd position.
Example 6
A student scored higher than $171$ of the $190$ other test-takers. What is their percentile?
$$P = \frac{171}{190} \times 100 = 90$$
Final answer: the $90$th percentile — the student outscored $90%$ of the cohort.
Why the Percentile Formula Matters
A raw number sits in a vacuum. The percentile is what places it in a crowd, and that placement is often the decision.
Health. Pediatric growth charts report weight and height as percentiles; a sudden drop from the 60th to the 15th percentile is a signal a doctor acts on, even if the raw weight rose.
Standardised testing. SAT, GRE, and competitive-exam scores are reported as percentiles so a score can be compared across different test versions of differing difficulty.
Quartiles and the five-number summary. The 25th, 50th, and 75th percentiles are the first quartile, median, and third quartile — the backbone of box plots and outlier detection.
Income and benchmarking. "Top 1%" is the 99th percentile of an income distribution; salary bands are set by percentile so they hold across regions.
What Are the Most Common Mistakes With the Percentile Formula?
Mistake 1: Not sorting the data first
Where it slips in: Applying the formula to data in the order it was given.
Don't do this: Count "values below $x$" in an unsorted list.
The correct way: Sort the data into ascending order before counting.
Mistake 2: Confusing percentile with percentage
Where it slips in: Reading a score report.
Don't do this: Treat "$85$th percentile" as "scored $85%$".
The correct way: A percentile is a rank against others; a percentage is a score out of 100. The 85th percentile means you beat $85%$ of people — your actual score could be anything. The second-guesser who knows their raw percentage often distrusts the percentile because the two numbers rarely match.
Mistake 3: Mishandling the position when $i$ is a whole number
Where it slips in: Finding the value at a given percentile (Direction 2).
Don't do this: When $i$ comes out whole, just take the value in position $i$ and stop.
The correct way: When $i$ is a whole number, average the values in positions $i$ and $i+1$. Skipping the average is a quiet off-by-one that shifts the answer.
Conclusion
The percentile formula is $P = \frac{\text{number of values below } x}{N} \times 100$ — the share of a sorted dataset below a value.
The reverse direction, $i = \frac{k}{100} \times N$, finds the value sitting at a given percentile.
A percentile is a rank against others, not a percentage score out of 100.
The 25th, 50th, and 75th percentiles are the first quartile, median, and third quartile.
Sort the data before counting — skipping the sort is the most common mistake.
Practice These Before Moving On
Work through these, then check by sorting and counting carefully.
In $30, 42, 18, 55, 60, 25$, find the percentile of $42$.
Find the value at the $75$th percentile of $4, 8, 12, 16, 20, 24, 28, 32$.
A test-taker scored higher than $342$ of $380$ others. What percentile is that?
Want a live Bhanzu trainer to walk your child through more percentile formula problems? Book a free demo class — online globally.
Was this article helpful?
Your feedback helps us write better content