ZCubes Wiki

Difference between revisions of "Manuals/calci/SMALL"

(Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">'''SMALL'''</font></font></font><font color="#7f7f7f"...")
 
 
(11 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left"><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">'''SMALL'''</font></font></font><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2"> (</font></font></font><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">'''arr'''</font></font></font><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">'''j'''</font></font></font><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
+
<div style="font-size:30px">'''SMALL(Array,k)'''</div><br/>
 +
*<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.
  
−
<font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">'''Where arr'''</font></font></font><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">   is an array and j is the position in the array or range of data to return.</font></font></font>
+
==Description==
 +
*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.
 +
*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(Array,m)</math>= Largest value in the given set.
 +
*This function will give the result as error when
 +
  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.
  
−
</div>
+
==Examples==
−
----
+
*=SMALL([2,7,9,10,67,9,45,18,0,-1,-5,70,52,39],2) = -1
−
<div id="1SpaceContent" class="zcontent" align="left"> <font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">It calculates values with a particular relative standing in a data set </font></font></font>
+
*=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
 +
{| class="wikitable"
 +
|+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
  
−
<font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">i.e.the j-th smallest value in a data set. </font></font></font>
+
==Related Videos==
  
−
</div>
+
{{#ev:youtube|JRrXuCvtmdc|280|center|SMALL}}
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
SMALL
+
==See Also==
 +
*[[Manuals/calci/LARGE  | LARGE ]]
 +
*[[Manuals/calci/MAX  | MAX ]]
 +
*[[Manuals/calci/MIN  | MIN ]]
 +
*[[Manuals/calci/MEDIAN  | MEDIAN ]]
  
−
</div></div>
+
==References==
−
----
+
*[http://en.wikipedia.org/wiki/Small_number Small number]
−
<div id="8SpaceContent" class="zcontent" align="left"><font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">
 
  
−
<font color="#7f7f7f"><font face="Arial, sans-serif"><font size="2">i.e=SMALL(C1R1:C1R9,3) is 9.</font></font></font>
 
  
−
</font></font></font></div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
  
−
{| id="TABLE3" class="SpreadSheet blue"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| class="    " | Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f  " | 13
 
−
| class="sshl_f" | 9
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 14
 
−
| class=" " |
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 15
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 9
 
−
|
 
−
|
 
−
| class="  " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" | 10
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row6
 
−
| class="sshl_f" | 7
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| class="sshl_f  " | Row7
 
−
| class="sshl_f" | 26
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| class="sshl_f" | Row8
 
−
| class="sshl_f" | 1
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| class="sshl_f" | Row9
 
−
| class="sshl_f " | 17
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 16:12, 8 August 2018

SMALL(Array,k)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the set of numbers.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle k} is the position of a smallest number.
    • SMALL(),returns the k-th smallest value in a data set.

Description

  • This function gives the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle k^{th}} smallest value in given array of numbers.
  • In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SMALL(Array,k)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is the array or range of cells containing the data to be used in the function and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle k} is the position of the smallest number.
  • This function can be used to find data based on relative size.
  • Here Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SMALL(Array,1)} = Smallest value in the given set.
  • Suppose there is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} number of data points in a given array, then Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SMALL(Array,m)} = Largest value in the given set.
  • This function will give the result as error when
 1. The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array}
 values are empty.
 2. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n\le 0}
 or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n}
 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"