Difference between revisions of "Manuals/calci/SMALL"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">'''SMALL'''</font></font></font><font color="#7f7f7f"...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''SMALL(ar,n)'''</div><br/> |
| + | *<math>ar</math> is the array of numbers. | ||
| + | *<math>n</math> is the position of a smallest number. | ||
| − | |||
| − | + | ==Description== | |
| − | - | + | *This function gives the n-th smllest value in given array of numbers. |
| − | < | + | *In <math>SMALL(ar,n), ar</math> is the array or range of cells containing the data to be used in the function and <math>n</math> is the position of the smallest number. |
| + | *This function can be used to find data based on relative size. | ||
| + | *Here <math> SMALL(ar,1)</math> = Smallest value in the given set. | ||
| + | *Suppose there is m number of data points in a given array, then <math>SMALL(ar,m)</math>= Larget value in the given set. | ||
| + | *This function will give the result as error when | ||
| + | 1. The ar values are empty. | ||
| + | 2. n<=0 or n in greater than the number of data points. | ||
| − | |||
| − | + | ==Examples== | |
| − | ---- | + | #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 | ||
| + | #Array={-6,-12,-20,-10,-15,0,-25} | ||
| + | =SMALL(E1:E7,4)=-12 | ||
| + | =SMALL(E1:E7,6)=-6 | ||
| + | #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== | |
| − | + | *[[Manuals/calci/LARGE | LARGE ]] | |
| − | + | *[[Manuals/calci/MAX | MAX ]] | |
| + | *[[Manuals/calci/MIN | MIN ]] | ||
| + | *[[Manuals/calci/MEDIAN | MEDIAN ]] | ||
| − | |||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 04:10, 10 January 2014
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 n-th smllest 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), ar} is the array or range of cells containing the data to be used in the function and 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 the smallest number.
- This function can be used to find data based on relative size.
- Here = Smallest value in the given set.
- Suppose there is 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)} = Larget value in the given set.
- This function will give the result as error when
= Smallest value in the given set.1. The ar values are empty. 2. n<=0 or n in greater than the number of data points.
Examples
- 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
- Array={-6,-12,-20,-10,-15,0,-25}
=SMALL(E1:E7,4)=-12 =SMALL(E1:E7,6)=-6
- 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