Manuals/calci/SMALL

SMALL(Array,k)

• $Array$ is the set of numbers.
• $k$ is the position of a smallest number.
  • SMALL(),returns the k-th smallest value in a data set.

Description

• This function gives the $k^{th}$ smallest value in given array of numbers.
• In $SMALL(Array,k)$, $Array$ is the array or range of cells containing the data to be used in the function and $k$ is the position of the smallest number.
• This function can be used to find data based on relative size.
• Here $SMALL(Array,1)$ = Smallest value in the given set.
• Suppose there is $m$ number of data points in a given array, then $SMALL(Array,m)$= Largest value in the given set.
• This function will give the result as error when

 1. The $Array$ values are empty.
 2. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n\le 0}
 or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n}
 is greater than the number of data points.

Examples

• =SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],2) = -1
• =SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],7) = 9
• =SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],1) = -5
• =SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],14) = 70

Spreadsheet

	A	B	C	D	E	F	G
1	-6	-12	-20	-10	-15	0	-25
2	1.2	1.5	1.25	1.62	1.521	1.7	1.76

• =SMALL(A1:G1,4) = -12
• =SMALL(A1:G1,6) = -6
• =SMALL(A2:G2,6) = 1.7
• =SMALL(A2:G2,8) = NAN

Related Videos

SMALL

See Also

• LARGE
• MAX
• MIN
• MEDIAN

References

• Small number

• List of Main Z Functions

• Z3 home