Investment Studio > Expressions > Functions > Statistical > LARGE

float large(float array table, integer rank)

Returns the rank:th largest value in table.

rank is a number between 1 and the number of elements in table.

All array elements are converted to float, with exclusion if conversion fails.

Example

=large({9, 47, 6, 2, 8, 4}, 1)

returns 47 (the largest number);

=large({9, 47, 6, 2, 8, 4}, 4)

returns 6 (the 4:th largest number).

See also max, median, min, percentile, percentrank, quartile, rank, small.