| Line 1: |
Line 1: |
| − | <div style="font-size:30px">'''SMALL(ar,n)'''</div><br/> | + | <div style="font-size:30px">'''SMALL(Array,k)'''</div><br/> |
| − | *<math>ar</math> is the array of numbers. | + | *<math>Array</math> is the set of numbers. |
| − | *<math>n</math> is the position of a smallest number. | + | *<math>k</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)</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. | + | *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(ar,1)</math> = Smallest value in the given set. | + | *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(ar,m)</math>= Largest 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 | | *This function will give the result as error when |
| − | 1. The <math>ar</math> values are empty. | + | 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. |
| | | | |