Spread Formula Reference
Formula Functions / Functions M to Q / PERCENTILE.EXC
In This Topic
    PERCENTILE.EXC
    In This Topic

    Summary

    This function returns the kth percentile of values in a range where k is between 0..1, exclusive.

    Syntax

    PERCENTILE.EXC(array,k)

    Arguments

    This function has these arguments:

    Argument Description
    array Array of values representing the data
    k Value representing the percentile value between 0 and 1

    Remarks

    This function returns the #NUM! error value if the array is empty. If k is nonnumeric, #VALUE! is returned. If k = 0 or 1, #NUM! is returned. The function interpolates to determine the value at the kth percentile if k is not a multiple of 1/(n-1). The function interpolates when the value for the specified percentile is between two values in the array. If the function cannot interpolate for the percentile, #NUM! is returned.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    PERCENTILE.EXC(A1:A12,0.95)

    PERCENTILE.EXC(R1C1:R1C45,0.866)

    PERCENTILE.EXC({5,15,25,50,65},0.45) gives the result 22

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also