# PERCENTILE

Returns the k-th percentile of values in a range

## Syntax

```
PERCENTILE(array, k)
```

## Arguments

| Argument | Description                                                      | Required |
| -------- | ---------------------------------------------------------------- | -------- |
| `array`  | The array or range of data that defines relative standing       | Required |
| `k`     | The percentile value in the range 0..1, inclusive              | Required |

## Examples

### 90th percentile of test scores

=PERCENTILE(A1:A7, 0.9)

Result ⇒93.2

|     |     |
| --- | --- |
|     | A |
| 1   | 85 |
| 2   | 90 |
| 3   | 78 |
| 4   | 92 |
| 5   | 88 |
| 6   | 95 |
| 7   | 82 |

### Median (50th percentile)

=PERCENTILE(A1:A5, 0.5)

Result ⇒30

|     |     |
| --- | --- |
|     | A |
| 1   | 10 |
| 2   | 20 |
| 3   | 30 |
| 4   | 40 |
| 5   | 50 |

### 25th percentile (first quartile)

=PERCENTILE(A1:A5, 0.25)

Result ⇒5

|     |     |
| --- | --- |
|     | A |
| 1   | 1  |
| 2   | 5  |
| 3   | 10 |
| 4   | 15 |
| 5   | 20 |

## Related Functions

Other Statistical functions:

- [AVEDEV](/content/docs/formulas/avedev.html)  \- Returns the average of the absolute deviations of data points from their mean
- [AVERAGE](/content/docs/formulas/average.html)  \- Returns the average of given arguments. Text is ignored.
- [CORREL](/content/docs/formulas/correl.html)  \- Returns the correlation coefficient between two data sets
- [COUNT](/content/docs/formulas/count.html)  \- Returns the count of numeric values in a dataset.
- [COUNTA](/content/docs/formulas/counta.html)  \- Returns the count of values in a list of arguments including text, logical values, error values, and empty text.
- [COUNTIF](/content/docs/formulas/countif.html)  \- Returns the count of cells that meet a specified criteria
- [COUNTIFS](/content/docs/formulas/countifs.html)  \- Returns the count of criteria_ranges based on the given criterions.
- [FORECAST](/content/docs/formulas/forecast.html)  \- Calculates, or predicts, a future value by using existing values
- [LARGE](/content/docs/formulas/large.html)  \- Returns the k-th largest value in a data set
- [MAX](/content/docs/formulas/max.html)  \- Returns the largest number from the provided arguments
- [MEDIAN](/content/docs/formulas/median.html)  \- Returns the median of the given numbers
- [MIN](/content/docs/formulas/min.html)  \- Returns the smallest number from the provided arguments
- [MINIFS](/content/docs/formulas/minifs.html)  \- Returns the minimum value from a range that meets multiple criteria.
- [MODE](/content/docs/formulas/mode.html)  \- Returns the most frequently occurring value in a data set
- [PERCENTRANK](/content/docs/formulas/percentrank.html)  \- Returns the rank of a value in a dataset as a percentage (0 to 1) of the dataset
- [RANK](/content/docs/formulas/rank.html)  \- Returns the rank of a number from the list of other numeric values
- [SMALL](/content/docs/formulas/small.html)  \- Returns the k-th smallest value in a data set
- [STDEV](/content/docs/formulas/stdev.html)  \- Returns the estimated standard deviation based on a sample
- [STDEVP](/content/docs/formulas/stdevp.html)  \- Calculates standard deviation based on the entire population
- [SUMIF](/content/docs/formulas/sumif.html)  \- Returns the sum of a range depending on criteria
- [SUMPRODUCT](/content/docs/formulas/sumproduct.html)  \- Returns the sum of products for a list of arguments
- [VAR](/content/docs/formulas/var.html)  \- Returns the estimated variance for a sample of data
- [VARP](/content/docs/formulas/varp.html)  \- Calculates variance based on the entire population