Excel for Statistics > How to use the Excel PERCENTILE function and Excel PERCENTRANK function

Watch the video or read the steps below:

## Excel PERCENTILE function and Excel PERCENTRANK function: Overview

Excel 2013 has *four* options for finding a percentile. Which one you use depends on what you want to do. In previous editions of Excel there were two percentile functions: PERCENTRANK and PERCENTILE. The Excel PERCENTRANK function gave you a percentile for a particular rank, while PERCENTILE returned the particular score from a list. In Excel 2013 there are now **four** options:

- PERCENTILE.INC Finds a score given a percentile. For example, you can ask Excel to find
**what score is in the 50th percentile.**The “INC” part of the function means to include 0% and 100% in the tallies. - PERCENTILE.EXC is exactly the same as PERCENTILE.INC with one difference: 0% and 100% are excluded. For example, it will calculate the 99th percentile but not the 100th percentile.
- PERCENTRANK.INC will return the ranking for a particular data item. for example, if you have a list of scores for a test, the function will give you a percentage ranking (i.e. 99th percent) for a particular data item. In other words,
**if you have a score of, say 50 on a test, you can find out what your ranking is. It included 0% and 100%.** - PERCENTRANK.EXC is exactly the same as PERCENTRANK.INC but it excludes 0% and 100%

## Excel PERCENTILE function: Steps

Step 1: Click an empty cell.

Step 2: Type =PERCENT and then click the function you need from the dropdown list (for example, double click PERCENTRANK.INC

Step 3: Click the “f_{x}” (Insert Function) button on the toolbar. This opens the function’s dialog box.

Step 4: Type in the requested items and then click “OK.”:

- Array: The cell location for your data.
- k: The percentage that you want to find the score for. Enter as a decimal (0 to 1 for PERCENTILE.INC)

## Excel PERCENTRANK function: Steps

Step 1: Click an empty cell.

Step 2: Type =PERCENT and then click the function you need from the dropdown list (for example, double click PERCENTRANK.INC

Step 3: Click the “f_{x}” (Insert Function) button on the toolbar. This opens the function’s dialog box.

Step 4: Type in the requested items and then click “OK.”:

- Array: the list of data (i.e. a set of scores from a test)
- x: the data item you want to find the percentage rank for
- Significance: The number of significant digits (decimal places) you want returned in the answer.

Check out our YouTube channel for more Excel tips and help!

------------------------------------------------------------------------------**Need help with a specific statistics question?** Chegg offers 30 minutes of free tutoring, so you can try them out before committing to a subscription. Click here for more details.

If you prefer an **online interactive environment** to learn R and statistics, this *free R Tutorial by Datacamp* is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try *this Statistics with R track*.

*Facebook page*.