Percentile
The selected percentile.
Percentile is the value of the Pth percentile of an ascending ordered data set containing N elements with values .
There are two steps to compute for Percentile.
Steps:
1. Calculate the rank:
The rank is then split into its integer component k and decimal component d, such that ..
2. Use the formula below to calculate as:
Sample 1
Consider the ordered list of values 15, 20, 35, 40, 50. What is the 40th percentile of this list?
Steps:
1. Calculate the rank of the 40th percentile as follows.
Thus, n=2.6, which gives us k=2 and d=0.6.
2. Calculate the value of the 40th percentile.
Thus, the value of the 40th percentile of the ordered list 15, 20, 35, 40, 50 is 29.
Sample 2
Consider the ordered list 1,2,3,4. What is the 75th percentile of this list?
Steps:
1. Calculate the rank of the 75th percentile as follows.
N = 75/100(41) + 1 = 3.25
Thus, n=3.25, which gives us k=3 and d=0.25.
2. Calculate the value of the 75th percentile.
Thus, the value of the 75th percentile of the ordered list 1,2,3,4 is 3.25.
Sample 3
Given the following sample fields:
Number 
Arbitrary 
Negative Values 
Positive Values 
One 
Binary 
Currency 
Decimal 
1 
3 
1 
1 
1 
0 
$1.00 
1.01 
2 
2 
2 
2 

1 
$10.00 
2.02 
3 
1 
3 
3 

0 
$100.00 
3.03 
4 
0 
4 
4 

1 
$1,000.00 
4.04 
5 
1 
5 
5 

0 
$10,000.00 
5.05 
6 
2 
6 
6 

1 
$1.00 
6.06 
7 
3 
7 
7 

0 
$10.00 
7.07 
8 
0 
8 
8 


$100.00 
8.08 
9 
0 
9 
9 


$1,000.00 
9.09 
10 
0 
10 
0 


$0.00 
0.00 
Sample fields.
The 50^{th} Percentile value for each field in the table:
5.50 
0.00 
5.50 
4.50 
1.00 
0.00 
0.50 
4.55 
5.50 
0.00 
5.50 
4.50 
1.00 
0.00 
0.50 
4.55 
The results per field.