# How to Find Percentiles in Microsoft Excel

Microsoft Excel makes calculating percentiles easy, helping you analyze your data effectively. Whether you’re a business professional, student, or data analyst, understanding percentiles can provide valuable insights into your data.

## How to Find Percentiles in Microsoft Excel

Finding percentiles in Microsoft Excel is a simple process involving using built-in functions. Here are the steps to help you calculate percentiles efficiently:

• ### Step 1. Open Your Excel Workbook

Start by opening the Excel workbook that contains the data set you want to analyze.

• ### Step 2. Select Your Data

Highlight the range of cells that includes the data you need to calculate the percentile for.

• ### Step 3. Choose the Percentile Function

To find a percentile, you can use either the PERCENTILE.INC or PERCENTILE.EXC function.

• ### Step 4. Enter the Function

Click on an empty cell where you want the percentile result to appear. Type =PERCENTILE.INC( or =PERCENTILE.EXC( followed by selecting your data range. For example, =PERCENTILE.INC(A1:A10, 0.9) to find the 90th percentile.

• ### Step 5. Specify the Percentile

After selecting the data range, add a comma and specify the percentile as a decimal. For instance, use 0.25 for the 25th percentile. Your formula should look like this: =PERCENTILE.INC(A1:A10, 0.25). Press the “Enter” key to calculate and display the percentile value in the selected cell.

You may also find valuable insights in the following articles offering tips for Microsoft Excel:

Note

## FAQs

### What function do I use to calculate percentiles in Excel?

Use the PERCENTILE.INC or PERCENTILE.EXC function.

### How do I specify the percentile I want to calculate?

Enter the desired percentile as a decimal, such as 0.75 for the 75th percentile.

### Can I find percentiles for a specific data range?

Yes, select the data range within the function, like A1:A10.

### What’s the difference between PERCENTILE.INC and PERCENTILE.EXC?

PERCENTILE.INC includes the endpoints, while PERCENTILE.EXC excludes them.

### Where does the percentile result appear?

The result appears in the cell where you entered the function.