Percentile Calculator
Find the value at any percentile rank in a dataset using linear interpolation.
Inputs
Percentile Value
46.0000
Data Count
5
Step by step
Values used
Data (comma separated) = 15, 20, 35, 40, 50; Percentile (0–100) = 90
Formula applied
Index = (p/100) × (n − 1); interpolate between adjacent values
Percentile Value
= 46.0000
Data Count
= 5
How it works
A percentile indicates the value below which a given percentage of observations fall. This calculator uses the R-7 linear interpolation method, consistent with Excel's PERCENTILE.INC.
Formula
Index = (p/100) × (n − 1); interpolate between adjacent values
- p
- Desired percentile (0–100)
- n
- Number of data points
Frequently Asked Questions
What does the 90th percentile mean?
It means 90% of the data values fall at or below this value.
Are quartiles the same as percentiles?
Yes — Q1 is the 25th percentile, Q2 the 50th, and Q3 the 75th percentile.