Percentile Calculator
Find the value at any percentile of a data set, and the percentile rank of a value.
40th percentile
29
- Count
- 5
Show the work
Sort the data
n = 5
15, 20, 35, 40, 50
Position in the sorted list
h = (n − 1) × p + 1
(5 − 1) × 0.4 + 1 = 2.6
Interpolate between values k and k + 1
xk + (h − k) × (xk + 1 − xk), k = whole part of h
20 + 0.6 × (35 − 20) = 29
How it works
Inclusive (Excel PERCENTILE.INC): position h = (n − 1)p, interpolate between the neighbors; exclusive (PERCENTILE.EXC): h = (n + 1)p − 1
Questions
- How does the percentile calculator work?
- Inclusive (Excel PERCENTILE.INC): position h = (n − 1)p, interpolate between the neighbors; exclusive (PERCENTILE.EXC): h = (n + 1)p − 1.
- What do I need to enter?
- Data, Percentile, Method, Rank of value. Optional fields can be left blank.
Related tools
- Quartile & Five-Number Summary CalculatorGet the quartiles, interquartile range (IQR), five-number summary and outliers of a data set.
- Confidence Interval CalculatorFind the confidence interval for a mean from the sample mean, standard deviation and sample size.
- Sample Size CalculatorFind how many people to survey (or measurements to take) for a chosen margin of error and confidence level.
- Margin of Error CalculatorFind the margin of error of a survey result or a sample mean at a chosen confidence level.
- Probability CalculatorCombine the probabilities of two events: both, either, neither, exactly one, and not A.
- Odds to Probability CalculatorConvert odds (for or against) to a probability, or a probability to odds.
Want this on your site? Embed the percentile calculator.