Name

PERCENTILE

Synopsis

Use PERCENTILE to find a value that is at the specified percentile of the values in the list. For example, you may want to find the value that is smaller than 25% of the specified values.

To Calculate

=PERCENTILE(Array, K)

Both arguments are required for this function.

Array

Indicates a range of numeric values.

K

Indicates a decimal value between 0 and 1 that indicates the percentile that you want to find.

Example

Figure 15-35 illustrates how PERCENTILE is used with a list of numeric values to find a value that is 30% of the other numeric values are smaller than. On the other hand, PERCENTRANK indicates the percent ranking of the specified numeric value.

Use PERCENTILE to find that value that is larger than the specified percentage of the list and PERCENTRANK to find the ranking of a specific value

Figure 15-35. Use PERCENTILE to find that value that is larger than the specified percentage of the list and PERCENTRANK to find the ranking of a specific value

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial