Overview
Deciles split a distribution into ten equal parts. This shows which decile group a value falls in, and finds the cutoff for any decile, assuming the data are roughly normal.
Enter the value, the mean and the standard deviation, and which cutoff you want. D9 is the point 90% of values fall below.
Worked examples
| Inputs | Result |
|---|---|
| Value74Mean62Standard deviation9Decile cutoff to find (1–9)9 | Percentile rank: 90.88%Decile group: 10 of 10D9 cutoff (90th percentile): 73.53 |
Show 2 more examples
| Value85Mean100Standard deviation15Decile cutoff to find (1–9)1 | Percentile rank: 15.87%Decile group: 2 of 10D1 cutoff (10th percentile): 80.78 |
| Value100Mean100Standard deviation15Decile cutoff to find (1–9)5 | Percentile rank: 50%Decile group: 6 of 10D5 cutoff (50th percentile): 100 |
Percentile rank by value
With the calculator's starting values, the percentile rank is 90.88%. The table shows how it changes with the value.
| Value | Percentile rank |
|---|---|
| 40 | 0.73% |
| 50 | 9.12% |
| 60 | 41.21% |
| 70 | 81.3% |
| 74starting value | 90.88% |
| 80 | 97.72% |
| 90 | 99.91% |
| 100 | 100% |
| 110 | 100% |
Other inputs: Mean: 62 · Standard deviation: 9 · Decile cutoff to find: 9 1–9. Change them in the calculator above for your own numbers.
How it works
The value is turned into a z-score, and the normal curve gives its percentile rank. Each group spans 10 percentile points, so the 90.88th percentile is in group 10. The Dk cutoff is the mean plus the z-score for k × 10% times the standard deviation. For skewed data, use the actual data’s percentiles instead.
The formula
| z(p) | z-score with area p to its left |
Practical tips
- With a mean of 62 and SD of 9, a value of 74 is in the top decile group, and D9 is 73.53.
- D5 is the median, the 50th percentile.
- For raw data in Excel, =PERCENTILE.INC(range, 0.9) gives D9.
Frequently asked questions
What is the difference between a decile and a percentile?
Deciles split data into 10 parts, and percentiles into 100. D1 is the 10th percentile.
What is a top decile?
The highest 10% of values, those above D9.