percentile

It has been suggested that percentile rank be merged into this article or section. (Discuss)

A percentile is the value of a variable below which a certain percent of observations fall. So 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 descriptive statistics as well as in the reporting of scores from norm-referenced tests.

The 25th percentile is also known as the first quartile(Q₁); the 50th percentile as the median or second quartile(Q₂); the 75th percentile as the third quartile (Q₃).

Definition

There is no standard definition of percentile ^{[1] [2]} , however all definitions yield similar results when the number of observations is large. One definition, usually given in texts, is that the p-th percentile of N ordered values is obtained by first calculating the rank , rounding to the nearest integer, and taking the value that corresponds to that rank.

An alternative method, used in many applications, is to use linear interpolation between the two nearest ranks instead of rounding. Specifically, if we have N values v₁, v₂, v₃,...,v_N , ranked from least to greatest, define the percentile corresponding to the n-th value as In this way, for example, if N = 5 the percentile corresponding to the third value is Suppose we now want to calculate the value v corresponding to a percentile p. If p < p₁ or p > p_N, we take v = v₁ or v = v_N respectively. Otherwise, we find an integer k such that , and take ^[3] When p = 50, the formula gives the median. When N is even and p = 25, the formula gives the median of the first values.

Linked with the percentile function, there is also a weighted percentile, where the percentage in the total weight is counted instead of the total number. In most spreadsheet applications there is no standard function for a weighted percentile. One method for weighted percentile extends the method described above. Suppose we have positive weights w₁, w₂, w₃,...,w_N , associated respectively with our N sample values. Let be the n-th partial sum of these weights. Then the formulae above are generalized by taking and

The way bottom percentile defined is the top values above a give rank

Alternative methods

Many software packages, such as Microsoft Excel, use the following method recommended by NIST^[4] to estimate the value, v_p, of the p^th percentile of an ascending ordered dataset containing N elements with values v₁,v₂,...,v_N;

n is then split into its integer component, k and decimal component, d, such that n = k + d. v_p is then calculated as:

An alternative method is as above, with n calculated as

Relation between percentile, decile and quartile

• P₂₅ = Q₁
• P₅₀ = D₅ = Q₂ = median
• P₇₅ = Q₃
• P₁₀₀ = D₁₀ = Q₄
• P₁₀ = D₁
• P₂₀ = D₂
• P₃₀ = D₃
• P₄₀ = D₄
• P₆₀ = D₆
• P₇₀ = D₇
• P₈₀ = D₈
• P₉₀ = D₉

Note: One quartile is equivalent to 25 percentile while 1 decile is equal to 10 percentile.

Examples

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 throughout is that it gives a very accurate picture of the cost of the bandwidth. The 95th percentile says that 95% of the time, your usage is below this amount. Just the same, the remaining 5% of the time, your usage is above that amount.

Physicians will often use infant and children's weight and height percentile

The normal curve and percentiles

Percentiles are often represented graphically, using a normal curve. A normal curve is always divided in the same respective manner. At the peak, in the center, stands the point of the mean of the distribution being graphed. On both the right and left sides each, the graph is divided into 3 equal parts, 1, 2, and 3 to the right and -1, -2, -3 to the left respectively. The important thing to remember is that at each of these standard deviation represents a fixed percentile. In other words, every standard deviation unit on the axis, including standard deviation units -3 to +3 have specific percentiles that are always paired with them, regardless the data or values in the distribution. So, what are the pairs of percentiles/standard deviation units? -3 = 0.2th percentile; -2 = 2.5th percentile; -1 = 16th percentile; 0 = 50th percentile (also the mean of the distribution as previously stated); +1 = 84th percentile; +2 = 97.5th percentile; +3 = 99.8th percentile.

Percentage also becomes a factor in measuring a distribution graphically. On any normal curve, 99.7% of data lies between the -3 and +3 values, 95% between -2 and +2, 68% between -1 and +1, 34% between 0 and -1 or 0 and +1, 16% between -1 and -2 or +1 and +2 and 2.5% between -2 and -3 or +2 and +3. The remaining 0.3% of the data is between -3 and negative infinity or +3 and positive infinity.

See also

• Quantile
• Decile
• Summary statistics

References

1. ^ Lane, David. "Percentiles". http://cnx.org/content/m10805/latest. Retrieved 2007-09-15. 
2. ^ Pottel, Hans. "Statistical flaws in Excel". http://www.mis.coventry.ac.uk/~nhunt/pottel.pdf. Retrieved 2006-03-22. 
3. ^ "Matlab Statistics Toolbox - Percentiles". http://www.mathworks.com/access/helpdesk/help/toolbox/stats/prctile.html. Retrieved 2006-09-15. 
4. ^ "Engineering Statistics Handbook: Percentile". NIST. http://www.itl.nist.gov/div898/handbook/prc/section2/prc252.htm. Retrieved 2009-02-18. 

External links

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