Difference between revisions of "Manuals/calci/SMALL"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*<math>ar</math> is the array of numbers. | *<math>ar</math> is the array of numbers. | ||
*<math>n</math> is the position of a smallest number. | *<math>n</math> is the position of a smallest number. | ||
| − | |||
==Description== | ==Description== | ||
*This function gives the <math>n^{th}</math> smallest value in given array of numbers. | *This function gives the <math>n^{th}</math> smallest value in given array of numbers. | ||
| − | *In <math>SMALL(ar,n), ar</math> is the array | + | *In <math>SMALL(ar,n)</math>, <math>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. | *This function can be used to find data based on relative size. | ||
*Here <math> SMALL(ar,1)</math> = Smallest value in the given set. | *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>= | + | *Suppose there is <math>m</math> number of data points in a given array, then <math>SMALL(ar,m)</math>= Largest value in the given set. |
*This function will give the result as error when | *This function will give the result as error when | ||
| − | 1. The ar values are empty. | + | 1. The <math>ar</math> values are empty. |
| − | 2. <math>n\le 0</math> or n is greater than the number of data points. | + | 2. <math>n\le 0</math> or <math>n</math> is greater than the number of data points. |
==Examples== | ==Examples== | ||
#Array={2,7,9,10,67,9,45,18,0,-1,-5,70,52,39} | #Array={2,7,9,10,67,9,45,18,0,-1,-5,70,52,39} | ||
| − | *=SMALL(F1:F14,2)=-1 | + | *=SMALL(F1:F14,2) = -1 |
| − | *=SMALL(F1:F14,7)=9 | + | *=SMALL(F1:F14,7) = 9 |
| − | *=SMALL(F1:F14,1)=-5 | + | *=SMALL(F1:F14,1) = -5 |
| − | *=SMALL(F1:F14,14)=70 | + | *=SMALL(F1:F14,14) = 70 |
| − | #Array={-6,-12,-20,-10,-15,0,-25} | + | #Array = {-6,-12,-20,-10,-15,0,-25} |
| − | *=SMALL(E1:E7,4)=-12 | + | *=SMALL(E1:E7,4) = -12 |
| − | *=SMALL(E1:E7,6)=-6 | + | *=SMALL(E1:E7,6) = -6 |
| − | #Array={1.2,1.5,1.25,1.62,1.521,1.7,1.76} | + | #Array = {1.2,1.5,1.25,1.62,1.521,1.7,1.76} |
| − | *=SMALL(B1:B7,6)=1.7 | + | *=SMALL(B1:B7,6) = 1.7 |
| − | *=SMALL(B1:B7,8)=NAN | + | *=SMALL(B1:B7,8) = NAN |
| − | |||
==See Also== | ==See Also== | ||
| Line 33: | Line 31: | ||
*[[Manuals/calci/MIN | MIN ]] | *[[Manuals/calci/MIN | MIN ]] | ||
*[[Manuals/calci/MEDIAN | MEDIAN ]] | *[[Manuals/calci/MEDIAN | MEDIAN ]] | ||
| − | |||
==References== | ==References== | ||
Revision as of 03:58, 30 January 2014
SMALL(ar,n)
- is the array of numbers.
- is the position of a smallest number.
is the array of numbers.
is the position of a smallest number.Description
- This function gives the smallest value in given array of numbers.
- In , 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 = Smallest value in the given set.
- Suppose there is number of data points in a given array, then = Largest value in the given set.
- This function will give the result as error when
smallest value in given array of numbers.
, 
= Smallest value in the given set.
number of data points in a given array, then 
= Largest value in the given set.1. The values are empty. 2. or is greater than the number of data points.
or 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