Calculate value(s) from specified percentiles
PERCENTILEVALUE(series 1, series 2)
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.
Last updated 3 years ago
Was this helpful?