PERCENTILE
The PERCENTILE function returns the value within a set of numeric values that corresponds to a particular percentile.
PERCENTILE(value-set, percentile-value)
value-set: A collection that must contain number values, date/time values, or duration values. All values must be of the same value type.
percentile-value: A number value representing the percentile value you want to find. percentile-value is either entered as a decimal (for example, 0.25) or as a percentage (for example, 25%). It must be greater than or equal to 0 and less than or equal to 1.
Notes
Values included in the collection that are the same are ranked together, but impact the outcome.
Examples |
|---|
Suppose the following table contains the cumulative test scores for this semester for your 20 students. (The data is organized this way for the example; it would likely originally have been in 20 separate rows.) |
A | B | C | D | E | |
|---|---|---|---|---|---|
1 | 30 | 75 | 92 | 86 | 51 |
2 | 83 | 100 | 92 | 68 | 70 |
3 | 77 | 91 | 86 | 85 | 83 |
4 | 77 | 90 | 83 | 75 | 80 |
=PERCENTILE(A1:E4, 0.90) returns 92, the minimum cumulative test score to be in the top 10% of the class (90th percentile). =PERCENTILE(A1:E4, 3/4) returns 87, the minimum cumulative test score to be in the top quarter of the class (75th percentile). =PERCENTILE(A1:E4, 0.50) returns 83, the minimum cumulative test score to be in the top half of the class (50th percentile). |