PERCENTILEVALUE

Calculate value(s) from specified percentiles

PERCENTILEVALUE(series 1, series 2)

Returns value(s) at a specified percentile based on a given series of data.

Arguments

Input

Description

target percentile

Target percentile(s) to return a value for

data

Series of data to form percentile calculations with

Outputs

Returns value(s) at specified percentiles.

Example

Last updated