SMALL
Syntax:
SMALL ( array , k )
Description: Computes the kth smallest value in a data set.
Arguments:
Name |
Type |
Description |
|---|---|---|
array |
array, reference |
The set of numbers from which the kth-smallest value is to be determined. |
k |
number |
The position (from the smallest) in the array or cell range of data to return. |
Return Type and Value: number – The kth smallest value in a data set.
However, if
array is empty, the return value is unspecified.
k ≤ 0 or k is greater than the number of data points,
#NUM!is returned.
example: