Manuals/calci/SMALL - Revision history

Devika at 22:12, 8 August 2018

2018-08-08T22:12:51Z

Devika at 20:35, 12 June 2018

2018-06-12T20:35:43Z

Devika at 20:34, 12 June 2018

2018-06-12T20:34:48Z

Jayaram at 07:19, 13 March 2017

2017-03-13T07:19:33Z

Jayaram at 11:32, 9 March 2017

2017-03-09T11:32:40Z

Devika: /* Examples */

2015-10-26T05:06:46Z

Examples

Swapna at 20:55, 25 June 2015

2015-06-25T20:55:46Z

Devika: /* References */

2015-05-11T18:08:28Z

References

Abin at 09:58, 30 January 2014

2014-01-30T09:58:27Z

Devika at 09:13, 10 January 2014

2014-01-10T09:13:23Z

@@ Line 2: / Line 2: @@
 *<math>Array</math> is the set of numbers.
 *<math>k</math> is the position of a smallest number.
 ==Description==

@@ Line 4: / Line 4: @@
 ==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(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.

@@ 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==
 *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.
-*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
-. The <math>ar</math> values are empty.
+. The <math>Array</math> values are empty.
 . <math>n\le 0</math> or <math>n</math> is greater than the number of data points.

← Older revision		Revision as of 07:19, 13 March 2017
Line 49:		Line 49:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 11:32, 9 March 2017
Line 46:		Line 46:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Small_number Small number]		*[http://en.wikipedia.org/wiki/Small_number Small number]
		+
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 14: / Line 14: @@
 ==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
 ==Related Videos==

← Older revision		Revision as of 18:08, 11 May 2015
Line 33:		Line 33:

	==References==		==References==
		+	*[http://en.wikipedia.org/wiki/Small_number Small number]

@@ Line 5: / Line 5: @@
 ==Description==
-*This function gives the <math>n^th</math> smllest 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), 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.
 *This function can be used to find data based on relative size.
@@ Line 16: / Line 16: @@
 ==Examples==
 #Array={2,7,9,10,67,9,45,18,0,-1,-5,70,52,39}
-=SMALL(F1:F14,2)=-1
+*=SMALL(F1:F14,2)=-1
-=SMALL(F1:F14,7)=9
+*=SMALL(F1:F14,7)=9
-=SMALL(F1:F14,1)=-5
+*=SMALL(F1:F14,1)=-5
-=SMALL(F1:F14,14)=70
+*=SMALL(F1:F14,14)=70
 #Array={-6,-12,-20,-10,-15,0,-25}
-=SMALL(E1:E7,4)=-12
+*=SMALL(E1:E7,4)=-12
-=SMALL(E1:E7,6)=-6
+*=SMALL(E1:E7,6)=-6
 #Array={1.2,1.5,1.25,1.62,1.521,1.7,1.76}
-=SMALL(B1:B7,6)=1.7
+*=SMALL(B1:B7,6)=1.7
-=SMALL(B1:B7,8)=NAN
+*=SMALL(B1:B7,8)=NAN