PercentileMode.ExcelInc - Enumeration

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:

List.Percentile

Contribute » | Contributors: Rick de Groot

Examples

Related enumerations

Applies to