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"...") |
|||
| (11 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''SMALL(Array,k)'''</div><br/> |
| + | *<math>Array</math> is the set of numbers. | ||
| + | *<math>k</math> is the position of a smallest number. | ||
| + | **SMALL(),returns the k-th smallest value in a data set. | ||
| − | + | ==Description== | |
| + | *This function gives the <math>k^{th}</math> smallest value in given array of numbers. | ||
| + | *In <math>SMALL(Array,k)</math>, <math>Array</math> is the array or range of cells containing the data to be used in the function and <math>k</math> is the position of the smallest number. | ||
| + | *This function can be used to find data based on relative size. | ||
| + | *Here <math> SMALL(Array,1)</math> = Smallest value in the given set. | ||
| + | *Suppose there is <math>m</math> number of data points in a given array, then <math>SMALL(Array,m)</math>= Largest value in the given set. | ||
| + | *This function will give the result as error when | ||
| + | 1. The <math>Array</math> values are empty. | ||
| + | 2. <math>n\le 0</math> or <math>n</math> 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 | ||
| + | {| class="wikitable" | ||
| + | |+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== | |
| − | + | {{#ev:youtube|JRrXuCvtmdc|280|center|SMALL}} | |
| − | |||
| − | |||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/LARGE | LARGE ]] | ||
| + | *[[Manuals/calci/MAX | MAX ]] | ||
| + | *[[Manuals/calci/MIN | MIN ]] | ||
| + | *[[Manuals/calci/MEDIAN | MEDIAN ]] | ||
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Small_number Small number] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 16:12, 8 August 2018
SMALL(Array,k)
- is the set of numbers.
- is the position of a smallest number.
- SMALL(),returns the k-th smallest value in a data set.
is the set 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 
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
| 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
See Also
References