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

    This function returns the nth percentile of values in a range.

    Syntax

    PERCENTILE(array,n)

    Arguments

    This function has these arguments:

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

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    PERCENTILE(A1:A12,0.95)

    PERCENTILE(R1C1:R1C45,0.866)

    PERCENTILE({5,15,25,50,65},0.45) gives the result 23

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    PERCENTRANK | QUARTILE | Statistical Functions