PERCENTRANK.INC

Excel Functions

Get percentile rank, inclusive

Syntax

EXCEL

=PERCENTRANK.INC(array, x, [significance])

Arguments

Parameter	Description
`array`	Array of data values.
`x`	Value to rank.
`significance`	[optional] Number of significant digits in result. Defaults to 3.

Return Value

Calculated rank as a decimal value

Details

The Excel PERCENTRANK.INC returns the relative standing of a value within a data set as a percentage. For example, a test score greater than or equal to 80% of all test scores is said to be at the 80th percentile. In this case, PERCENTRANK.INC will assign a rank of .80 to the score. In the example shown, the formula in C5 is: where "data" is the named range C5:C12. Note: The PERCENTRANK.INC function replaces PERCENTRANK, which is now classified as a "compatibility function". When x does not exist within the array, the function interpolates a value between data points. For example, when the x value of 4.00 is passed as an argument to the function, the percentage is interpolated to 42.4%, which lies between the percent ranks of 3.3 and 4.56, which are 33.3% and 50.0%, respectively. In the gr

Examples

Example 1

The Excel PERCENTRANK.INC returns the relative standing of a value within a data set as a percentage. For example, a test score greater than or equal