How to use the PERCENTRANK.INC function
What is the PERCENTRANK.INC function?
The PERCENTRANK.INC function calculates the percent rank of a given number compared to the whole data set. PERCENTRANK.INC stands for "PERCENTRANK Inclusive". This includes the value of the score in the ranking. This function was introduced in Excel 2010 and has replaced the PERCENTRANK function.
What is the percent rank?
The percent rank (or percentile rank) indicates the percentage of scores that fall at or below a given score in a dataset. It provides a way to evaluate the standing of a score relative to others.
When is the PERCENTRANK.INC function useful?
Use the PERCENTRANK.INC function to evaluate the standing of an aptitude test score among all scores for the test.
What is an aptitude test score?
An aptitude test is a standardized test designed to measure a person's ability or skills in a specific topic. An aptitude test score is the performance measurement on such a test.
Evaluating an aptitude test score's percentage ranking allows understanding its standing compared to other test takers. Higher percentiles indicate better relative performance on the aptitude test.
PERCENTRANK.INC function Syntax
PERCENTRANK.INC(array, x, [significance])
PERCENTRANK.INC function Arguments
| array | Required. The array or range of data with numeric values that defines relative standing. |
| x | Required. The value for which you want to know the percent rank. |
| [significance] | Optional. Lower bound, default value 0 (zero). |
What is relative standing?
Relative standing refers to how a particular score compares to the distribution of scores within a group or population. It allows you to understand where a score ranks in relation to others.
PERCENTRANK.INC function example
The image above shows 15 numbers in column B. 2 numbers are less than 11 (second argument) and 12 numbers are larger than 11.
Formula in cell C7:
The PERCENTRANK.INC function interpolates in order to return the correct value if x doesn't match a value in the array.
What is interpolate?
Interpolate means to estimate or infer a data point within a range of known data points. In statistics, interpolation refers to estimating the percentage between existing data points in a distribution.
How is the PERCENTRANK.INC function calculated?
- Sort the scores from lowest to highest.
- Determine the rank of the given score in the ordered list.
- Calculate the percent rank using the formula:
Percent rank = (Rank - 1) / (Total number of scores - 1)
(3-1)/(15-1)
becomes
2/14 = 0.142 (approx. 3 digits)
PERCENTRANK.INC function not working
The PERCENTRANK.INC function returns
- #NUM! error value if:
- array is empty
- [significance]Â < 1
Functions in 'Statistical' category
The PERCENTRANK.INC function function is one of many functions in the 'Statistical' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form