Computing the Percentile Rank in Excel

Fundamentals of Social Statistics by Adam J. McKee

To compute the percentile rank of a score in Excel, use the PERCENTRANK function.  Let’s say for example that an honor society advisor wants to rank a pool of applicants by GPA.

Figure 19. Percentile rank in Excel.

Figure 19. Percentile rank in Excel. 

Note that this function does not return an array of values.  You must enter a function for each value to get a column of results as in the example above.  In the Function Argument dialog box, “Array” is your list of scores, and “X” is the score you want to compute the percentile rank for.

[ Back | Contents | Next ]

Last Modified:  06/03/2021

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.