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. Search JabSto ::

Custom Search