A percentile (or a centile) is a measure used in statistics indicating the value below which a given percentage of observations in a group of observations fall. For example, the 20th percentile is the value (or score) below which 20 percent of the observations may be found.
The term percentile and the related term percentile rank are often used in the reporting of scores from normreferenced tests. For example, if a score is in the 86th percentile, it is higher than 86% of the other scores. The 25th percentile is also known as the first quartile (Q_{1}), the 50th percentile as the median or second quartile (Q_{2}), and the 75th percentile as the third quartile (Q_{3}). In general, percentiles and quartiles are specific types of quantiles.
Contents

Applications 1

The normal distribution and percentiles 2

Definitions 3

The Nearest Rank method 4

Worked examples of the Nearest Rank method 4.1

The Linear Interpolation Between Closest Ranks method 5

Commonalities between the Variants of this Method 5.1

First Variant, C=1/2 5.2

Worked Example of the First Variant 5.2.1

Second Variant, C=1 5.3

Worked Examples of the Second Variant 5.3.1

Third Variant, C=0 5.4

Worked Example of the Third Variant 5.4.1

The Weighted Percentile method 6

Definition of the Weighted Percentile method 6.1

See also 7

References 8

External links 9
Applications
When ISPs bill "burstable" internet bandwidth, the 95th or 98th percentile usually cuts off the top 5% or 2% of bandwidth peaks in each month, and then bills at the nearest rate. In this way infrequent peaks are ignored, and the customer is charged in a fairer way. The reason this statistic is so useful in measuring data throughput is that it gives a very accurate picture of the cost of the bandwidth. The 95th percentile says that 95% of the time, the usage is below this amount. Just the same, the remaining 5% of the time, the usage is above that amount.
Physicians will often use infant and children's weight and height to assess their growth in comparison to national averages and percentiles which are found in growth charts.
The 85th percentile speed of traffic on a road is often used as a guideline in setting speed limits and assessing whether such a limit is too high or low.^{[1]}
The normal distribution and percentiles
Representation of the
threesigma rule. The dark blue zone represents observations within one
standard deviation (σ) to either side of the
mean (μ), which accounts for about 68.2% of the population. Two standard deviations from the mean (dark and medium blue) account for about 95.4%, and three standard deviations (dark, medium, and light blue) for about 99.7%.
The methods given in the Definitions section are approximations for use in smallsample statistics. In general terms, for very large populations following a normal distribution percentiles may often be represented by reference to a normal curve plot. The normal distribution is plotted along an axis scaled to standard deviations, or sigma units. Mathematically, the normal distribution extends to negative infinity on the left and positive infinity on the right. Note, however, that only a very small proportion of individuals in a population will fall outside the −3 to +3 range. For example, with human heights very few people are above the +3 sigma height level.
Percentiles represent the area under the normal curve, increasing from left to right. Each standard deviation represents a fixed percentile. Thus, rounding to two decimal places, −3 \sigma is the 0.13th percentile, −2 \sigma the 2.28th percentile, −1 \sigma the 15.87th percentile, 0 the 50th percentile (both the mean and median of the distribution), +1 \sigma the 84.13th percentile, +2 \sigma the 97.72nd percentile, and +3 \sigma the 99.87th percentile. This is known as the 68–95–99.7 rule or the threesigma rule. Note that in theory the 0th percentile falls at negative infinity and the 100th percentile at positive infinity, although in many practical applications, such as test results, natural lower and/or upper limits are enforced.
Definitions
There is no standard definition of percentile,^{[2]}^{[3]}^{[4]} however all definitions yield similar results when the number of observations is very large.^{[5]} In the limit, as the sample size approaches infinity and the data points become so densely spaced they appear continuous, the 100p^{th} percentile (0<p<1) approximates the inverse of the cumulative distribution function (CDF) thus formed, evaluated at p, as p approximates the CDF. Some methods for calculating the percentiles are given below.
The Nearest Rank method
One definition of percentile, often given in texts, is that the Pth percentile (0 < P \le 100) of a list of N ordered values (sorted from least to greatest) is the smallest value in the list such that P percent of the data is less than or equal to that value. This is obtained by first calculating the ordinal rank and then taking the value from the ordered list that corresponds to that rank. The ordinal rank n is calculated using this formula

n = \left \lceil \frac{P}{100} \times N \right \rceil
Note the following:

Using the Nearest Rank method on lists with fewer than 100 distinct values can result in the same value being used for more than one percentile.

A percentile calculated using the Nearest Rank method will always be a member of the original ordered list.

The 100th percentile is defined to be the largest value in the ordered list.
Worked examples of the Nearest Rank method
Example 1:
Consider the ordered list {15, 20, 35, 40, 50}, which contains five data values. What are the 30th, 40th, 50th and 100th percentiles of this list using the Nearest Rank method?
Percentile
P

Number in list
N

Ordinal rank
n

Number from the ordered list
that has that rank

Percentile
value

Notes

30th

5

n = \left\lceil \frac{30}{100} \times 5 \right \rceil = \lceil 1.5 \rceil = 2.

the second number in the ordered list, which is 20

20

20 is an element of the list

40th

5

n = \left\lceil \frac{40}{100} \times 5 \right \rceil = \lceil 2.0 \rceil = 2.

the second number in the ordered list, which is 20

20

In this example it is the same as the 30th percentile.

50th

5

n = \left\lceil \frac{50}{100} \times 5 \right \rceil = \lceil 2.5 \rceil = 3.

the third number in the ordered list, which is 35

35

35 is an element of the ordered list.

100th

5

Last

50, which is the last number in the ordered list

50

The 100th percentile is defined to be the largest value in the list, which is 50.

So the 30th, 40th, 50th and 100th percentiles of the ordered list {15, 20, 35, 40, 50} using the Nearest Rank method are {20, 20, 35, 50}
Example 2:
Consider an ordered population of 10 data values {3, 6, 7, 8, 8, 10, 13, 15, 16, 20}. What are the 25th, 50th, 75th and 100th percentiles of this list using the Nearest Rank method?
Percentile
P

Number in list
N

Ordinal rank
n

Number from the ordered list
that has that rank

Percentile
value

Notes

25th

10

n = \left\lceil \frac{25}{100} \times 10 \right \rceil = \lceil 2.5 \rceil = 3.

the third number in the ordered list, which is 7

7

7 is an element of the list

50th

10

n = \left\lceil \frac{50}{100} \times 10 \right \rceil = \lceil 5.0 \rceil = 5.

the fifth number in the ordered list, which is 8

8

8 is an element of the list.

75th

10

n = \left\lceil \frac{75}{100} \times 10 \right \rceil = \lceil 7.5 \rceil = 8.

the eighth number in the ordered list, which is 15

15

15 is an element of the list.

100th

10

Last

20, which is the last number in the ordered list

20

The 100th percentile is defined to be the largest value in the list, which is 20.

So the 25th, 50th, 75th and 100th percentiles of the ordered list {3, 6, 7, 8, 8, 10, 13, 15, 16, 20} using the Nearest Rank method are {7, 8, 15, 20}
Example 3:
Consider an ordered population of 11 data values {3, 6, 7, 8, 8, 9, 10, 13, 15, 16, 20}. What are the 25th, 50th, 75th and 100th percentiles of this list using the Nearest Rank method?
Percentile
P

Number in list
N

Ordinal rank
n

Number from the ordered list
that has that rank

Percentile
value

Notes

25th

11

n = \left\lceil \frac{25}{100} \times 11 \right \rceil = \lceil 2.75 \rceil = 3.

the third number in the ordered list, which is 7

7

7 is an element of the list

50th

11

n = \left\lceil \frac{50}{100} \times 11 \right \rceil = \lceil 5.50 \rceil = 6.

the sixth number in the ordered list, which is 9

9

9 is an element of the list.

75th

11

n = \left\lceil \frac{75}{100} \times 11 \right \rceil = \lceil 8.25 \rceil = 9.

the ninth number in the ordered list, which is 15

15

15 is an element of the list.

100th

11

Last

20, which is the last number in the ordered list

20

The 100th percentile is defined to be the largest value in the list, which is 20.

So the 25th, 50th, 75th and 100th percentiles of the ordered list {3, 6, 7, 8, 8, 9, 10, 13, 15, 16, 20} using the Nearest Rank method are {7, 9, 15, 20}
The Linear Interpolation Between Closest Ranks method
An alternative to rounding used in many applications is to use linear interpolation between adjacent ranks.
Commonalities between the Variants of this Method
All of the following variants have the following in common. Given the order statistics

\{v_i,i=1,2,...,N : v_{i+1}\ge v_i,\forall i=1,2,...N1\},
we seek a linear interpolation function that passes through the points (v_i,i). This is simply accomplished by

v(x)=v_{\lfloor x\rfloor}+(x%1)(v_{\lfloor x\rfloor+1}v_{\lfloor x\rfloor}),\forall x\in[1,N] : v(i)=v_i\text{, for } i=1,2,...,N,
where \lfloor x\rfloor uses the floor function to represent the integral part of positive x, whereas x%1 uses the mod function to represent its fractional part (the remainder after division by 1). (Note that, though at the endpoint x=N, v_{\lfloor x\rfloor+1} is undefined, it does not need to be because it is multiplied by x%1=0.) As we can see, x is the continuous version of the subscript i, linearly interpolating v between adjacent nodes.
There are two ways in which the variant approaches differ. The first is in the linear relationship between the rank x, the percent rank P=100p, and a constant that is a function of the sample size N:

x=f(p,N)=(N+c_1)p+c_2.
There is the additional requirement that the midpoint of the range (1,N), corresponding to the median, occur at p=0.5:

f(0.5,N)=\frac{N+c_1}{2}+c_2=\frac{N+1}{2}\therefore 2c_2+c_1=1,
and our revised function now has just one degree of freedom, looking like this:

x=f(p,N)=(N+12C)p+C.
The second way in which the variants differ is in the definition of the function near the margins of the [0,1] range of p: f(p,N) should produce, or be forced to produce, a result in the range [1,N], which may mean the absence of a onetoone correspondence in the wider region.
First Variant, C=1/2
(Sources: Matlab "prctile" function,^{[6]}^{[7]})

x=f(p)=\begin{cases} Np+\frac{1}{2},\forall p\in\left [p_1,p_N\right ], \\ 1,\forall p\in\left [0,p_1\right ], \\ N,\forall p\in\left [p_N,1\right ]. \end{cases},
where

p_i=\frac{1}{N}\left(i\frac{1}{2}\right),i\in[1,N]\cap\mathbb{N}

\therefore p_1=\frac{1}{2N}, p_N=\frac{2N1}{2N}.
Furthermore, let

P_i=100p_i.
The inverse relationship is restricted to a narrower region:

p=\frac{1}{N}\left(x\frac{1}{2}\right),x\in(1,N)\cap\mathbb{R}.
Worked Example of the First Variant
Consider the ordered list {15, 20, 35, 40, 50}, which contains five data values. What are the 5th, 30th, 40th and 95th percentiles of this list using the Linear Interpolation Between Closest Ranks method? First, we calculate the percent rank for each list value.
List value
v_i

Position of that value
in the ordered list
i

Number of values
N

Calculation of
percent rank

Percent rank,
P_i

Notes

15

1

5

\frac{100}{5}\left(1\frac{1}{2}\right)=10.

10


20

2

5

\frac{100}{5}\left(2\frac{1}{2}\right)=30.

30


35

3

5

\frac{100}{5}\left(3\frac{1}{2}\right)=50.

50


40

4

5

\frac{100}{5}\left(4\frac{1}{2}\right)=70.

70


50

5

5

\frac{100}{5}\left(5\frac{1}{2}\right)=90.

90


Then we take those percent ranks and calculate the percentile values as follows:
Percent Rank
P

Number of values
N

Is P < P_1?

Is P > P_n?

Is there a
percent rank
equal to P?

What do we use for percentile value?

Percentile value
v(f(p))

Notes

5

5

Yes

No

No

We see that P=5, which is less than the first percent rank p1=10, so use the first list value v1, which is 15

15

15 is a member of the ordered list

30

5

No

No

Yes

We see that P=30 is the same as the second percent rank p2=30, so use the second list value v2, which is 20

20

20 is a member of the ordered list

40

5

No

No

No

We see that P=40 is between percent rank p2=30 and p3=50, so we take k=2, k+1=3, P=40, pk=p2=30, vk=v2=20, vk+1=v3=35, N=5.
Given those values we can then calculate v as follows:
v=20+5\times\frac{4030}{100}(3520)=27.5

27.5

27.5 is not a member of the ordered list

95

5

No

Yes

No

We see that P=95, which is greater than the last percent rank pN=90, so use the last list value, which is 50

50

50 is a member of the ordered list

So the 5th, 30th, 40th and 95th percentiles of the ordered list {15, 20, 35, 40, 50} using the Linear Interpolation Between Closest Ranks method are {15, 20, 27.5, 50}
Second Variant, C=1
(Source: Some software packages, including Microsoft Excel^{[4]} (up to and including version 2013 by means of the PERCENTILE.INC function). Noted as an alternative by NIST^{[8]})

x = f(p,N) = p(N1)+1 \text{, } p\in[0,1]

\therefore p = \frac{x1}{N1} \text{, } x\in[1,N].
Note that the x\leftrightarrow p relationship is onetoone for p\in[0,1], the only one of the three variants with this property; hence the "INC" suffix, for inclusive, on the Excel function.
Worked Examples of the Second Variant
Example 1:
Consider the ordered list {15, 20, 35, 40, 50}, which contains five data values. What is the 40th percentile of this list using this variant method?
First we calculate the rank of the 40th percentile:

x = \frac{40}{100}(51)+1=2.6
So, x=2.6, which gives us \lfloor x\rfloor=2 and x%1=0.6. So, the value of the 40th percentile is

v(2.6) = v_2+0.6(v_3v_2) = 20+0.6(3520) = 29.
Example 2:
Consider the ordered list {1,2,3,4} which contains four data values. What is the 75th percentile of this list using the Microsoft Excel method?
First we calculate the rank of the 75th percentile as follows:

x = \frac{75}{100}(41)+1=3.25
So, x=3.25, which gives us an integral part of 3 and a fractional part of 0.25. So, the value of the 75th percentile is

v(3.25) = v_3+0.25(v_4v_3) = 3+0.25(43) = 3.25.
Third Variant, C=0
(The primary variant recommended by NIST.^{[8]} Adopted by Microsoft Excel since 2010 by means of PERCENTIL.EXC function. However, as the "EXC" suffix indicates, the Excel version excludes both endpoints of the range of p, i.e., p\in(0,1), whereas the "INC" version, the second variant, does not; in fact, any number smaller than 1/(N+1) is also excluded and would cause an error.)

x = f(p,N) = \begin{cases} p(N+1)\text{, }p\in\left(0,\frac{N}{N+1}\right] \\ N\text{, }p\in\left[\frac{N}{N+1},1\right] \end{cases}.
The inverse is restricted to a narrower region:

p = \frac{x}{N+1}\text{, }x\in(0,N).
Worked Example of the Third Variant
Consider the ordered list {15, 20, 35, 40, 50}, which contains five data values. What is the 40th percentile of this list using the NIST method?
First we calculate the rank of the 40th percentile as follows:

x = \frac{40}{100}(5+1)=2.4
So x=2.4, which gives us \lfloor x\rfloor=2 and x%1=0.4. So the value of the 40th percentile is calculated as:

v(2.4) = v_2+0.4(v_3v_2) = 20+0.4(3520) = 26
So the value of the 40th percentile of the ordered list {15, 20, 35, 40, 50} using this variant method is 26.
The Weighted Percentile method
Definition of the Weighted Percentile method
In addition to the percentile function, there is also a weighted percentile, where the percentage in the total weight is counted instead of the total number. There is no standard function for a weighted percentile. One method extends the above approach in a natural way.
Suppose we have positive weights w_1, w_2, w_3, \dots, w_N associated, respectively, with our N sorted sample values. Let

S_n=\sum_{k=1}^n w_k,
the nth partial sum of the weights. Then the formulas above are generalized by taking

p_n=\frac{100}{S_N}\left(S_n\frac{w_n}{2}\right)
and

v=v_k+\frac{Pp_k}{p_{k+1}p_k}(v_{k+1}v_k).
The 50% weighted percentile is known as the weighted median.
See also
References

^ .

^

^

^ ^{a} ^{b}

^

^ , This is equivalent to Method 5 discussed here

^

^ ^{a} ^{b}
External links

Free Online Software (Calculator) computes Percentiles for any dataset according to 8 different percentile definitions.

Percentiles: Measures of Relative Standing of an observation in data set. Percentiles for grouped and ungrouped data.
This article was sourced from Creative Commons AttributionShareAlike License; additional terms may apply. World Heritage Encyclopedia content is assembled from numerous content providers, Open Access Publishing, and in compliance with The Fair Access to Science and Technology Research Act (FASTR), Wikimedia Foundation, Inc., Public Library of Science, The Encyclopedia of Life, Open Book Publishers (OBP), PubMed, U.S. National Library of Medicine, National Center for Biotechnology Information, U.S. National Library of Medicine, National Institutes of Health (NIH), U.S. Department of Health & Human Services, and USA.gov, which sources content from all federal, state, local, tribal, and territorial government publication portals (.gov, .mil, .edu). Funding for USA.gov and content contributors is made possible from the U.S. Congress, EGovernment Act of 2002.
Crowd sourced content that is contributed to World Heritage Encyclopedia is peer reviewed and edited by our editorial staff to ensure quality scholarly research articles.
By using this site, you agree to the Terms of Use and Privacy Policy. World Heritage Encyclopedia™ is a registered trademark of the World Public Library Association, a nonprofit organization.