PERCENTILEOFVALUE
Calculate percentiles based on data
Last updated
Calculate percentiles based on data
Last updated
PERCENTILEOFVALUE(series 1
, series 2
)
Returns the percentile of a given value, or series of values, given an input set of data.
Returns a percentile or series of percentiles.
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.
Input
Description
target value
Target value(s) to return percentile for
data
Series of data to calculate percentile from