# PERCENTILEINC

The **PERCENTILEINC** function returns the k-th percentile of a dataset using the inclusive method, allowing k values from 0 to 1, including both the minimum and maximum values in the calculation.

{% hint style="info" %}
**PERCENTILE** is the legacy version of the **PERCENTILEINC** function and works similarly. It can be used in place of PERCENTILEINC for inclusive percentile calculations.
{% endhint %}

### Syntax

```javascript
PERCENTILEINC(array, k)
```

### Arguments

The **PERCENTILEINC** function syntax has the following arguments:

* array: The range or list of numeric values for which you want to calculate the percentile. Required.
* k: The percentile value to return, expressed as a decimal between 0 and 1. Required.
  * 0 - Minimum value
  * 0.25 - 25th percentile
  * 0.5 - Median (50th percentile)
  * 0.75 - 75th percentile
  * 1 - Maximum value

{% hint style="warning" %}
If a value other than 0 to 1 is provided for k, the **PERCENTILEINC** function returns a **#ERR** error.
{% endhint %}

### Example

<pre class="language-javascript"><code class="lang-javascript"><strong>PERCENTILEINC(10,20,30,40,50,60,70,80, 0.25)
</strong>// Returns 27.5
<strong>PERCENTILEINC(10,20,30,40,50,60,70,80, 0.5)
</strong>// Returns 45
<strong>PERCENTILEINC(10,20,30,40,50,60,70,80, 0.75)
</strong>// Returns 62.5
</code></pre>

You can use the **PERCENTILEINC** function to determine the relative standing of values within a dataset by calculating specific percentiles for metrics such as sales, revenue, or performance scores.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FQFxSmtjm9anKpBjoL8PC%2F2026-02-17_11h28_56.png?alt=media&#x26;token=1b48b1a4-d87a-4ab4-93f1-2d3b6c5b25b2" alt=""><figcaption><p>PERCENTILEINC function</p></figcaption></figure>

{% hint style="info" %}
We used the [**SELECT**](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/select) function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue)
{% endhint %}

### Excel Equivalent

[PERCENTILEINC](https://support.microsoft.com/en-us/office/percentile-inc-function-680f9539-45eb-410b-9a5e-c1355e5fe2ed)

### FAQs

**Q1. How is PERCENTILEINC calculated?**

PERCENTILEINC is calculated by determining the k-th percentile of a dataset using the inclusive method, which includes the minimum and maximum values in the calculation.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FUbI7GcyAbA1WKucUFFGc%2F2026-02-17_11h37_30.png?alt=media&#x26;token=0865e44a-46de-4bc4-9408-606e356910b8" alt="" width="247"><figcaption></figcaption></figure>

Where:

* k = desired percentile (between 0 and 1)
* n = number of values

The result is interpolated if the position is not a whole number. It returns the value below which a specified percentage of data falls, including both the minimum and maximum values.

**Q2. What does a percentile represent?**

A percentile shows how a value compares to other values in a dataset.

For example, consider student exam scores. If a student’s score is at the 90th percentile:

* 90% of the students scored below this value.
* 10% of the students scored above this value.

This means the student performed better than most of the class and is among the top 10%.