PERCENTILE

Formulas / PERCENTILE
Calculate the kth percentile for a set of data.
=PERCENTILE(array, k)
  • array - required, range of data defining the relative standing
  • k - required, percentile value in the range 0 to 1, inclusive

Examples

  • =PERCENTILE(scores,E5)

    The PERCENTILE function returns the nth percentile of a dataset. For example, if you want to find the 40th percentile of the scores in cell C5:C14, you would use the formula above. This would return the value at the 40th percentile of the scores in C5:C14.

  • =PERCENTILE(scores,0.1)

    The PERCENTILE function can also be used to return the k-th smallest value in a data set. For example, if you want to find the 10th smallest value in cell C5:C14, you can use the formula above. This would return the value at the 10th percentile of the scores in C5:C14.

  • =PERCENTILE(scores,0.9)

    The PERCENTILE function can also be used to return the k-th largest value in a data set. For example, if you want to find the 90th largest value in cell C5:C14, you can use the formula above. This would return the value at the 90th percentile of the scores in C5:C14.

  • =PERCENTILE(scores,0.5)

    The PERCENTILE function can also be used to return the median of a data set. For example, if you want to find the median of the scores in cell C5:C14, you can use the formula above. This would return the median value of the scores in C5:C14 at the 50th percentile.


Summary

The PERCENTILE function is a Sourcetable function used to calculate the kth percentile of a set of values. It can be used to set a threshold of acceptance, and the accuracy may be improved in later versions, with interpolation to determine the value at the k-th percentile if k is not a multiple of 1/n.

  • The PERCENTILE function calculates the "kth percentile" for a set of data, where k can be a decimal or a percentage between 0 and 1.
  • The PERCENTILE function returns a value greater than or equal to the specified percentage.

Frequently Asked Questions

What is the PERCENTILE function?
The PERCENTILE function returns the kth percentile of a set of values. This function is useful for determining a threshold of acceptance.
Are there any new functions that provide improved accuracy?
Yes, new functions may be available in future versions of Excel that provide improved accuracy.
How do I use the PERCENTILE function?
Using the PERCENTILE function is fairly straightforward. In the function, you specify the data set and the percentile you want to calculate. You can also provide an optional “k” argument, which is the percentile you want to find (range 0 to 1).
What are the benefits of using the PERCENTILE function?
  • It can help you quickly determine the threshold of acceptance.
  • It can help you identify outliers in your data.
  • It can help you make informed decisions about your data.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV