# PercentileMode.ExcelExc

Updated on

PercentileMode.ExcelExc (2) is an enumeration that specifies the percentile mode type. It is a member of the PercentileMode.Type and indicates that when interpolating values for List.Percentile, a method compatible with Excel’s PERCENTILE.EXC should be used.

## Examples

Find the quartiles of the list { 1, 1, 15, 80, 85 } using an interpolation method matching Excel’s `PERCENTILE.EXC`.

``````// Returns {1, 15, 82.5 }
= List.Percentile(
{ 1, 1, 15, 80, 85 },
{ 0.25, 0.5, 0.75 },
[ PercentileMode = PercentileMode.ExcelExc ]
)``````

Some other examples using PercentileMode.ExcelExc are:

``````// Returns { 1, 82.5 }
= List.Percentile(
{ 1, 1, 15, 80, 85 },
{ 0.25, 0.75 },
[ PercentileMode = PercentileMode.ExcelExc ]
)

// Returns { null, 1.8, 4.2, 9, 15, 54 }
= List.Percentile(
{ 1, 5, 15, 80, 100 },
{ 0.1, 0.2, 0.3, 0.4, 0.5, 0.6 },
[ PercentileMode = PercentileMode.ExcelExc ]
)
``````

Other related enumerations are:

## Applies to

Here’s a list of functions that work with PercentileMode.Type:

Contribute » | Contributors: Rick de Groot