Difference between revisions of "Manuals/calci/SMALL"
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''SMALL( | + | <div style="font-size:30px">'''SMALL(Array,k)'''</div><br/> |
| − | *<math> | + | *<math>Array</math> is the set of numbers. |
| − | *<math> | + | *<math>k</math> is the position of a smallest number. |
| + | **SMALL(),returns the k-th smallest value in a data set. | ||
==Description== | ==Description== | ||
| − | *This function gives the <math> | + | *This function gives the <math>k^{th}</math> smallest value in given array of numbers. |
| − | *In <math>SMALL( | + | *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. | *This function can be used to find data based on relative size. | ||
| − | *Here <math> SMALL( | + | *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( | + | *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 | *This function will give the result as error when | ||
| − | 1. The <math> | + | 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. | 2. <math>n\le 0</math> or <math>n</math> is greater than the number of data points. | ||
Latest revision as of 17: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
1. The values are empty. 2. 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