Difference between revisions of "Manuals/calci/LARGE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''LARGE'''('''A''','''k''') '''Where A '''is the array or range of data for which want to decide the k-th largest...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''LARGE(ar,i)'''</div><br/>
 +
*<math>ar</math>  is the array of numbers.
 +
*<math>I</math> is the position of the largest number.
  
−
'''LARGE'''('''A''','''k''')
 
  
−
'''Where A '''is the array or range of data for which want to decide the k-th largest value and '''K''' is the position in the array or cell range of data to return.
 
  
−
</div>
+
==Description==
−
----
+
*This function gives the <math>i</math>-th largest value in the given set of numbers.
−
<div id="1SpaceContent" class="zcontent" align="left">
+
*This function can be used to find data based on relative size - such as the fourth largest number in a given list of data.
 +
*In <math>LARGE(ar,i)</math>, <math>ar</math> is the array of data to find the <math>i</math>-largest value.<math>i</math> is the  position from the largest to return.
 +
*If <math>k</math> is the number of data points in a range, then <math>LARGE(ar,1)</math> gives the largest value, and <math>LARGE(ar,n)</math> gives the smallest value.
 +
*The function gives the result as error when
 +
        1. The array is empty.
 +
        2. <math>i\le 0<math> or <math>i</math> is greater than the total number of points in the given set.
  
−
This function calculates the k-th largest value in a data set.
+
==Examples==
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
! !! A !! B !! C !! D!! E 
 +
|-
 +
! 1
 +
| 13 || 10 || 9 || 13 || 21 
 +
|-
 +
! 2
 +
| 28 || 15 || 10 || 16 || 19
 +
|-
 +
!3
 +
| 12 || 19 || -1 || 0 || 18
 +
|}
  
−
</div>
+
#=LARGE(A1:E2,3) = 19
−
----
+
#=LARGE(A1:E2,9) = 10
−
<div id="7SpaceContent" class="zcontent" align="left">
+
#=LARGE(A2:E3,10) = -1
 +
#=LARGE(A2:E3,9) = 0
  
−
·          LARGE shows the error value, when A is empty or k is less than or equal to 0 or if k is greater than the number of data points
+
==See Also==
−
 
+
*[[Manuals/calci/SMALL | SMALL ]]
−
</div>
+
*[[Manuals/calci/PERCENTILE  | PERCENTILE ]]
−
----
+
*[[Manuals/calci/PERCENTRANK  | PERCENTRANK ]]
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
*[[Manuals/calci/QUARTILE | QUARTILE]]
−
 
 
−
LARGE
 
−
 
 
−
</div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example,
 
−
 
 
−
LARGE(A, K)
 
−
 
 
−
'''B                              C'''
 
−
 
 
−
3                               6
 
−
 
 
−
8                               5
 
−
 
 
−
5                               7
 
−
 
 
−
7                               8
 
−
 
 
−
8                               9
 
−
 
 
−
<nowiki>=LARGE(B2:C6,4) is 8</nowiki>
 
−
 
 
−
<nowiki>=LARGE(B2:C6,8) is 5</nowiki>
 
−
 
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </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"
 
−
|- class="even"
 
−
| class="    " |
 
−
| Column1
 
−
| class="  " | Column2
 
−
| class="  " | Column3
 
−
| class="  " | Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f  " | 3
 
−
| class="sshl_f" | 6
 
−
| class="sshl_f" | 8
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 8
 
−
| class="sshl_f" | 5
 
−
| class="sshl_f" | 5
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 5
 
−
| class="sshl_f" | 7
 
−
| class="SelectTD" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 7
 
−
| class="sshl_f" | 8
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" | 8
 
−
| class=" " | 9
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| Row6
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
==References==
−
----
 

Revision as of 00:13, 24 March 2014

LARGE(ar,i)


  • is the array of numbers.
  • is the position of the largest number.


Description

  • This function gives the -th largest value in the given set of numbers.
  • This function can be used to find data based on relative size - such as the fourth largest number in a given list of data.
  • In , is the array of data to find the -largest value. is the position from the largest to return.
  • If is the number of data points in a range, then gives the largest value, and gives the smallest value.
  • The function gives the result as error when
       1. The array is empty.
       2.  is greater than the total number of points in the given set.

Examples

Spreadsheet
A B C D E
1 13 10 9 13 21
2 28 15 10 16 19
3 12 19 -1 0 18
  1. =LARGE(A1:E2,3) = 19
  2. =LARGE(A1:E2,9) = 10
  3. =LARGE(A2:E3,10) = -1
  4. =LARGE(A2:E3,9) = 0

See Also

References

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