# PERCENTILEEXC

The **PERCENTILEEXC** function returns the k-th percentile of a dataset using the exclusive method, requiring k to be between 0 and 1 (exclusive), excluding the minimum and maximum values from the calculation.

### Syntax

```javascript
PERCENTILEEXC(array, k)
```

### Arguments

The **PERCENTILEEXC** 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 (exclusive). Required.
  * 0.25 - 25th percentile
  * 0.5 - Median (50th percentile)
  * 0.75 - 75th percentile

{% hint style="warning" %}

* k must be greater than 0 and less than 1. 
* Unlike [PERCENTILEINC](/planning-sheets/formula-syntax/statistical-functions/percentileinc.md), this function excludes the minimum (0) and maximum (1) values from the calculation.
* If a value less than or equal to 0, or greater than or equal to 1 is provided, the **PERCENTILEEXC** function returns a **#ERR** error. 
  {% endhint %}

### Example

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

You can use the **PERCENTILEEXC** function to determine the relative standing of values within a dataset by calculating exclusive percentiles for metrics such as sales, revenue, or performance scores, especially when working with sample data.

<figure><img src="/files/R2qjjytCZxLd2oynerAr" alt=""><figcaption><p>PERCENTILEEXC function</p></figcaption></figure>

{% hint style="info" %}
We can also use the [**SELECT**](/planning-sheets/formula-syntax/measure-column-selection-functions/select.md) function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue)

<pre><code><strong>PERCENTILEEXC(SELECT([Revenue], 1, 4), 0.80)
</strong></code></pre>

{% endhint %}

### Excel Equivalent

[PERCENTILEEXC](https://support.microsoft.com/en-us/office/percentile-exc-function-bbaa7204-e9e1-4010-85bf-c31dc5dce4ba)

### FAQs

**Q1. How is PERCENTILEEXC calculated?**

PERCENTILEEXC is calculated by determining the k-th percentile of a dataset using the exclusive method, which excludes the minimum and maximum values from the calculation.

<figure><img src="/files/JB0xCmXv6jqrnfOAKfcW" alt="" width="208"><figcaption></figcaption></figure>

Where:

* k = desired percentile (0\<k<1)
* n = number of values

If the calculated position is not a whole number, the result is obtained by interpolating between the surrounding values. It returns the value below which a specified percentage of data falls, excluding 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%.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/formula-syntax/statistical-functions/percentileexc.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.