Products, services, and OS functions
may not be available in this country.

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).

See alsoFREQUENCYPERCENTRANKQUARTILE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.