Percentile
Finds the value at a chosen cut point in a column of numbers, such as the median or the 90th percentile. It answers what a top-decile deal looks like without eyeballing a sorted list.
Inputs
| Input | Accepts | Required |
|---|---|---|
Series | Series (a list of numbers) | Yes |
Percentile | Value (a single number) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Value (a single number) |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Percentile | 50 | A number between 0 and 100. 50 is the median, 25 and 75 are the quartiles, 90 finds the value that only the top 10% exceed. When the cutoff falls between two data points, the result is blended proportionally between them. |
Example
The Closed_Deals table has 400 rows with a Deal_Size column. Set
Percentile to 90 and the result is the deal size that only the largest 10% of
deals exceed, say $185,000. Set it to 50 for the median deal, which is often a
more honest "typical deal" figure than the average when a few huge contracts
skew the mean.