Manuals/calci/SMALL

SMALL(ar,n)

• 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 ar} is the array of numbers.
• 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 the position of a smallest number.

Description

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

 1. The 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 ar}
 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

1. Array={2,7,9,10,67,9,45,18,0,-1,-5,70,52,39}

• =SMALL(F1:F14,2) = -1
• =SMALL(F1:F14,7) = 9
• =SMALL(F1:F14,1) = -5
• =SMALL(F1:F14,14) = 70

1. Array = {-6,-12,-20,-10,-15,0,-25}

• =SMALL(E1:E7,4) = -12
• =SMALL(E1:E7,6) = -6

1. Array = {1.2,1.5,1.25,1.62,1.521,1.7,1.76}

• =SMALL(B1:B7,6) = 1.7
• =SMALL(B1:B7,8) = NAN

See Also

• LARGE
• MAX
• MIN
• MEDIAN