Difference between revisions of "Manuals/calci/SMALL"

From ZCubes Wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by 4 users not shown)
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), 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 m number of data points in a given array, then <math>SMALL(ar,m)</math>= Larget 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 ar values are empty.
+
   1. The <math>Array</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}
+
*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],2) = -1
−
*=SMALL(F1:F14,2)=-1
+
*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],7) = 9
−
*=SMALL(F1:F14,7)=9
+
*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],1) = -5
−
*=SMALL(F1:F14,1)=-5
+
*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],14) = 70
−
*=SMALL(F1:F14,14)=70
+
{| class="wikitable"
−
#Array={-6,-12,-20,-10,-15,0,-25}
+
|+Spreadsheet
−
*=SMALL(E1:E7,4)=-12
+
|-
−
*=SMALL(E1:E7,6)=-6
+
! !! A !! B !! C !! D!! E!! F !! G
−
#Array={1.2,1.5,1.25,1.62,1.521,1.7,1.76}
+
|-
−
*=SMALL(B1:B7,6)=1.7
+
! 1
−
*=SMALL(B1:B7,8)=NAN
+
| -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==
 
==See Also==
Line 33: Line 44:
 
*[[Manuals/calci/MIN  | MIN ]]
 
*[[Manuals/calci/MIN  | MIN ]]
 
*[[Manuals/calci/MEDIAN  | MEDIAN ]]
 
*[[Manuals/calci/MEDIAN  | MEDIAN ]]
 +
 +
==References==
 +
*[http://en.wikipedia.org/wiki/Small_number Small number]
  
  
−
==References==
+
 
 +
*[[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.

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
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

SMALL

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/SMALL&oldid=210969"