PERCENTILE
Definition of PERCENTILE
Returns the value at a given percentile of a dataset.
Sample Usage
PERCENTILE(A2:A100,A2)
PERCENTILE(A2:A100,0.67)
Syntax
PERCENTILE(data, percentile)
data
- The array or range containing the dataset to consider.percentile
- The percentile whose value withindata
will be calculated and returned.
Notes
The value returned by
PERCENTILE
is not necessarily a member ofdata
as this function interpolates between values to calculate the alpha percentile.The 50th percentile, that is setting
percentile
to0.5
is equivalent to usingMEDIAN
with the same dataset.
See Also
SMALL
: Returns the nth smallest element from a data set, where n is user-defined.
RANK
: Returns the rank of a specified value in a dataset.
QUARTILE
: Returns a value nearest to a specified quartile of a dataset.
PERCENTRANK
: Returns the percentage rank (percentile) of a specified value in a dataset.
MINA
: Returns the minimum numeric value in a dataset.
MIN
: Returns the minimum value in a numeric dataset.
MEDIAN
: Returns the median value in a numeric dataset.
MAXA
: Returns the maximum numeric value in a dataset.
MAX
: Returns the maximum value in a numeric dataset.
LARGE
: Returns the nth largest element from a data set, where n is user-defined.
AVERAGEA
: Returns the numerical average value in a dataset.
AVERAGE
: Returns the numerical average value in a dataset, ignoring text.
In order to use the PERCENTILE formula, start with your edited Excellentable
Then type in the PERCENTILE Formula in area you would like to display the outcome:
Type in the complete PERCENTILE formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.