What is PERCENTILE.INC function in Excel?

The PERCENTILE.INC function is one of the Statistical functions of Excel.

It returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

We can find this function in Statistical category of insert function Tab.

How to use PERCENTILE.INC function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select PERCENTILE.INC function.

6. Then select ok.

7. In the function arguments Tab you will see PERCENTILE.INC function.

8. Array is the array or range of data that defines relative standing.

9. K is the percentile value that is between 0 through 1, inclusive.

10. You will see the results in the formula result section.

Examples of PERCENTILE.INC function in Excel

PERCENTILE.INC related functions 

Leave a Reply

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