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...")
 
 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''LARGE(Array,k)'''</div><br/>
 +
*<math>Array</math>  is the array of numbers.
 +
*<math>k</math> is the position of the largest number.
 +
**LARGE(), returns the k-th largest value in a data set.
  
−
'''LARGE'''('''A''','''k''')
+
==Description==
 +
*This function gives the <math>k</math>-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 <math>LARGE(Array,k)</math>, <math>Array</math> is the array of data to find the <math>k</math>-largest value.<math>k</math> is the  position from the largest to return.
 +
*If <math>i</math> is the number of data points in a range, then <math>LARGE(Array,1)</math> gives the largest value, and <math>LARGE(Array,i)</math> gives the smallest value.
 +
*The function gives the result as error when
 +
        1. The array is empty.
 +
        2. <math>k\le 0</math> or <math>k</math> is greater than the total number of points in the given set.
  
−
'''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.
+
==Examples==
−
 
+
{| class="wikitable"
−
</div>
+
|+Spreadsheet
−
----
+
|-
−
<div id="1SpaceContent" class="zcontent" align="left">
+
! !! A !! B !! C !! D!! E 
−
 
+
|-
−
This function calculates the k-th largest value in a data set.
+
! 1
−
 
+
| 13 || 10 || 9 || 13 || 21 
−
</div>
+
|-
−
----
+
! 2
−
<div id="7SpaceContent" class="zcontent" align="left">
+
| 28 || 15 || 10 || 16 || 19
−
 
+
|-  
−
·          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
+
!3
−
 
+
| 12 || 19 || -1 || 0 || 18
−
</div>
+
|}
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
−
 
 
−
LARGE
 
−
 
 
−
</div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
−
 
 
−
Lets see an example,
 
−
 
 
−
LARGE(A, K)
 
  
−
'''B                              C'''
+
#=LARGE(A1:E2,3) = 19
 +
#=LARGE(A1:E2,9) = 10
 +
#=LARGE(A2:E3,10) = -1
 +
#=LARGE(A2:E3,9) = 0
  
−
3                               6
+
== Related Videos ==
 +
{{#ev:youtube|MhVGbi-hv7M|280|center|LARGE}}
  
−
8                               5
 
  
−
5                               7
+
==See Also==
 +
*[[Manuals/calci/SMALL | SMALL ]]
 +
*[[Manuals/calci/PERCENTILE  | PERCENTILE ]]
 +
*[[Manuals/calci/PERCENTRANK  | PERCENTRANK ]]
 +
*[[Manuals/calci/QUARTILE | QUARTILE]]
  
−
7                               8
+
==References==
 +
*[http://en.wikipedia.org/wiki/Large_numbers LARGE NUMBERS]
  
−
8                               9
 
  
−
<nowiki>=LARGE(B2:C6,4) is 8</nowiki>
+
*[[Z_API_Functions | List of Main Z Functions]]
−
 
 
−
<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>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 17:23, 7 August 2018

LARGE(Array,k)


  • is the array of numbers.
  • is the position of the largest number.
    • LARGE(), returns the k-th largest value in a data set.

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

Related Videos

LARGE


See Also

References


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