:"Using the SMALL function to efficiently mine low values in a data set"-Table skills免费ppt模版下载-道格办公

"Using the SMALL function to efficiently mine low values in a data set"

```html

Picture and text skills
Case

Returns the k-th smallest value in the data set. Use this function to return a numeric value at a specific position in a data set.

SyntaxSMALL(array,k)

Array is the array or numeric data area for which the kth minimum value needs to be found. K is the position of the returned data in the array or data area (from small to large).

Description

• If array is empty, function SMALL returns the error value #NUM!.

• If k ≤ 0 or k exceeds the number of data points, function SMALL returns the error value #NUM!.

• If n is the number of data points in the array, then SMALL(array,1) equals the minimum value and SMALL(array,n) equals the maximum value.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/yun-yong-SMALL-han-shu-gao-xiao-wa-jue-shu-ju-ji-de-di-zhi.html