Manuals/calci/LARGE

LARGE(ar,i)

• $ar$ is the array of numbers.
• $I$ is the position of the largest number.

Description

• This function gives the $i$-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 $LARGE(ar,i)$, $ar$ is the array of data to find the $i$-largest value.$i$ is the position from the largest to return.
• If $k$ is the number of data points in a range, then $LARGE(ar,1)$ gives the largest value, and $LARGE(ar,n)$ gives the smallest value.
• The function gives the result as error when

       1. The array is empty.
       2. $i\leq 0<math>or<math>i$ 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

• SMALL
• PERCENTILE
• PERCENTRANK
• QUARTILE