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:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot