Manuals/calci/SMALL

Revision as of 14:35, 12 June 2018 by Devika (talk | contribs)
SMALL(Array,k)


  • 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 Array} is the set 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 k} 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 k^{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(Array,k)} , 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 Array} is the array or range of cells containing the data to be used in the function and   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(Array,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(Array,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 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

References