Manuals/calci/LARGE

LARGE(Array,k)

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

Description

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

       1. The array is 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 k\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 k}
 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

• SMALL
• PERCENTILE
• PERCENTRANK
• QUARTILE

References

• LARGE NUMBERS

• List of Main Z Functions

• Z3 home