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(s) to return percentile for |
| 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.
Last updated