Difference between revisions of "Manuals/calci/LARGE"

From ZCubes Wiki
Jump to navigation Jump to search
Line 9: Line 9:
 
*This function can be used to find data based on relative size - such as the fourth largest number in a given list of data.
 
*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.  
 
*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,n)</math> gives the smallest value.
+
*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  
 
*The function gives the result as error when  
 
         1. The array is empty.
 
         1. The array is empty.

Revision as of 13:02, 6 June 2018

LARGE(Array,k)


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