Percentile
Computes the specified quantile value between 0 and 1.
Computes the specified quantile value between 0 and 1.
Although this tool is called percentile, it actually uses quantile values. A quantile shows where a value falls based on the range of values. For example, 0.25 quantile = 25 percentile and .5 quantile = 50 percentile. Most of the time, you can think of quantiles as percentiles and you'll still be able to understand your data.
Tip
Don't confuse quantile with quartile! Quartiles divide values into 4 equal parts. For example, quartile 1 = 0.25 quantile = 25 percentile. A quartile is a type of quantile.
When to use this tool
Use when you want to understand the frequency of data by grouping values.
Usage example
Let's say we have data about customer service calls. We want to know the length of time of 95% of customer calls. Using this tool, we would input Quantile = .95 and name the new column. The output shows the time we want.