percentile¶
Syntax¶
Parameters¶
x- a numeric expression.
sorted-value-list- a list-valued expression that is sorted in ascending numerical order.
Returns¶
Returns a value between 0.0 (if x is less than all values the list) and 100.0 (if x is greater than or equal to all values in the list).
Description¶
Returns the percentage of values in the sorted-value-list that are less than or equal to x.
If the second argument is not a sorted list of values, the results are unpredictable.