Changes

no edit summary
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.
 +
**SMALL(),returns the k-th smallest value in a data set.
    
==Description==
 
==Description==
*This function gives the <math>n^{th}</math> smallest value in given array of numbers.   
+
*This function gives the <math>k^{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.
  
writer
6,694

edits