Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / PERCENTILE
In This Topic
    PERCENTILE
    In This Topic

    Summary

    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

    See Also