PERCENTILEOFVALUE

Calculate percentiles based on data

PERCENTILEOFVALUE(series 1, series 2)

Returns the percentile of a given value, or series of values, given an input set of data.

Arguments

Input	Description
target value	Target value(s) to return percentile for
data	Series of data to calculate percentile from

Outputs

Returns a percentile or series of percentiles.

Example

Let's say we have a series of ages and we wish to know what percentile a 26 year-old would be in. Using MODELPERCENTILE(26, {Age}) will allow us to calculate that.

Now let's say that we wish to know what percentile each age in our dataset is. If we input MODELPERCENTILE({Age}, {Age}), we will get a corresponding percentile value for each age.