Difference between revisions of "Manuals/calci/SMALL"

Latest revision as of 17:12, 8 August 2018

SMALL(Array,k)

$Array$ is the set of numbers.
is the position of a smallest number.
- SMALL(),returns the k-th smallest value in a data set.

This function gives the $k^{th}$ smallest value in given array of numbers.
In $SMALL(Array,k)$ , $Array$ is the array or range of cells containing the data to be used in the function and $k$ is the position of the smallest number.
This function can be used to find data based on relative size.
Here $SMALL(Array,1)$ = Smallest value in the given set.
Suppose there is $m$ number of data points in a given array, then $SMALL(Array,m)$ = Largest value in the given set.
This function will give the result as error when

 1. The  $Array$  values are empty.
 2.  $n\leq 0$  or  $n$  is greater than the number of data points.

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

@@ Line 2: / Line 2: @@
 *<math>Array</math> is the set of numbers.
 *<math>k</math> is the position of a smallest number.
+**SMALL(),returns the k-th smallest value in a data set.
 ==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.