Investment Studio > Expressions > Functions > Statistical > SMALL

float small(float array table, integer rank)

Returns the rank:th smallest 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

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

returns 2 (the smallest number);

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

returns 8 (the 4:th smallest number).

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