Microsoft Office Tutorials and References

In Depth Information

**Using PERCENTRANK.INC to Assign a Percentile to Every Record**

Figure 14.9.

Figure 14.9.
Unlike

function can de-

termine the breaking point for any particular percentile.

Unlike QUARTILE.INC

QUARTILE.INC, the

, the PERCENTILE.INC

PERCENTILE.INC function can de-

termine the breaking point for any particular percentile.

Using

Using
PERCENTRANK.INC

PERCENTRANK.INC
to Assign a Percentile to Every Record

to Assign a Percentile to Every Record

Suppose you have a database of students in a graduating class. Each stu-

dent has a certain grade point average. To determine each student
’
s standing

in the class, you use the PERCENTRANK.INC function.

Syntax

=PERCENTRANK.INC(array,x,significance)

=PERCENTRANK.EXC(array,x,significance)

The Excel 2007 PERCENTRANK function is being replaced by

PERCENTRANK.INC. The PERCENTRANK.EXC function made its debut in Excel

2010.

The PERCENTRANK.INC function returns the rank of a value in a data set

as a percentage of the data set. You can use this function to evaluate the

relative standing of a value within a data set. For example, you can use

PERCENTRANK.INC to evaluate the standing of an aptitude test score among

all scores for the test. This function takes the following arguments:

•
array

array
—
This is the array or range of data with numeric values that

defines relative standing. If arrayis empty, PERCENTRANK.INC re-

turns a #NUM! error.

•
x
—
This is the value for which you want to know the rank. If xdoes

not match one of the values in array, PERCENTRANK.INC interpol-

ates to return the correct percentage rank.