PERCENTILEVALUE
Calculate value(s) from specified percentiles
Last updated
Calculate value(s) from specified percentiles
Last updated
PERCENTILEVALUE(series 1
, series 2
)
Returns value(s) at a specified percentile based on a given series of data.
Input
Description
target percentile
Target percentile(s) to return a value for
data
Series of data to form percentile calculations with
Returns value(s) at specified percentiles.