PERCENTILE.INC
Formulas / PERCENTILE.INCCalculate 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?
What is returned if the array argument is empty?
How is the PERCENTILE.INC function used?
What is the kth percentile?
