# PercentileMode.ExcelInc

Updated on

PercentileMode.ExcelInc (1) 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.INC should be used.

## Examples

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

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

Some other examples using PercentileMode.ExcelInc are:

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

// Returns { 2.6, 4.2, 7, 11, 15, 41 }
= List.Percentile(
{ 1, 5, 15, 80, 100 },
{ 0.1, 0.2, 0.3, 0.4, 0.5, 0.6 },
[ PercentileMode = PercentileMode.ExcelInc ]
)
``````

Other related enumerations are:

## Applies to

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

Contribute » | Contributors: Rick de Groot