# Learn How to Use Microsoft Excel PERCENTILE.INC Function

Written by | 0 Comments | 656 Views

In this article, you will learn how to use Microsoft Excel PERCENTILE.INC function and its prime function in Microsoft Excel. You will also get to know Microsoft Excel PERCENTILE.INC function return value and syntax with the help of some examples.

Microsoft Excel PERCENTILE.INC Function

The main purpose of Microsoft Excel PERCENTILE.INC function is to get the kth percentile. That implies, with the help of PERCENTILE.INC function you can able to calculates the "kth percentile" for the given set of data, where k is 0 to 1. It should be noted that percentile is a value below which a given percentage of values in a data set fall. You can also use PERCENTILE.INC to determine the 90th percentile, the 80th percentile, and so on. So, with the help of PERCENTILE.INC function, you can able to get the kth percentile.

Return Value of PERCENTILE.INC Function

The return value will be the calculated percentile for "k".

Syntax of PERCENTILE.INC Function

=PERCENTILE.INC(array, k)

Where the arguments:

• array: This is the data value array.
• k: This is the number representing the kth percentile.

## How to Use Microsoft Excel PERCENTILE.INC Function?

So we know that, Microsoft Excel PERCENTILE.INC function you can able to get the kth percentile. That implies, with the help of PERCENTILE.INC function you can able to calculates the "kth percentile" for the given set of data, where k is 0 to 1. It should be noted that percentile is a value below which a given percentage of values in a data set fall. You can also use PERCENTILE.INC to determine the 90th percentile, the 80th percentile, and so on. So, with the help of PERCENTILE.INC function, you can able to get the kth percentile.