PERCENTILE.INC

Formulas / PERCENTILE.INC
Calculate the kth percentile.
=PERCENTILE.INC(array, k)
  • array - required, data defining relative standing
  • k - required, specifies the percentile value for the range 0..1, inclusive

Examples

  • =PERCENTILE.INC(scores,E5)

    The PERCENTILE.INC function is used to calculate the percentile of a given set of values. In the example, the 40th percentile of the scores in C5:C14 is calculated.

  • =PERCENTILE.INC(scores,E20)

    The PERCENTILE.INC function can also be used to calculate the percentile of a given set of values from a different range of cells. For example, to calculate the 80th percentile of the scores in C20:C29, the preceding formula would be used.

  • =PERCENTILE.INC(A1:A5,0.5)

    The PERCENTILE.INC function can also be used to calculate the percentile of a given set of values that are in an array. For example, the formula above would calculate the 50th percentile of the values in the array.

  • =PERCENTILE.INC(scores,0.9)

    The PERCENTILE.INC function can also be used to calculate the percentile of a given set of values with a given percentile value. For example, to calculate the 90th percentile of the scores in C30:C39, the preceding formula would be used.


Summary

The PERCENTILE.INC function calculates the kth percentile of a range of values, with the k argument being a value between 0 and 100. It can be used to examine candidates who have scored above a certain percentile.

  • The PERCENTILE.INC function returns a value greater than or equal to the specified percentile, calculated using a range of 0 to 1.
  • It calculates the "kth percentile" for a set of data, which is the value below which a given percentage of values fall in a data set.

Frequently Asked Questions

What is the PERCENTILE.INC function?
The PERCENTILE.INC function returns the kth percentile of values in a range. The kth percentile is a value between 0 and 100, inclusive. It is useful for determining a threshold of acceptance.
What is returned if the array argument is empty?
The PERCENTILE.INC function returns the #NUM! error if the array argument is empty.
How is the PERCENTILE.INC function used?
The PERCENTILE.INC function is used to determine the kth percentile of values in a range. It is useful for determining a threshold of acceptance.
What is the kth percentile?
The kth percentile is the value in the range 0 to 100, inclusive. It is used to determine the kth percentile of values in a range.

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