Difference between revisions of "Manuals/calci/LARGE"
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
*<math>Array</math> is the array of numbers. | *<math>Array</math> is the array of numbers. | ||
*<math>k</math> is the position of the largest number. | *<math>k</math> is the position of the largest number. | ||
| − | + | **LARGE(), returns the k-th largest value in a data set. | |
| − | |||
==Description== | ==Description== | ||
| Line 9: | Line 8: | ||
*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, | + | *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. | ||
Latest revision as of 17:23, 7 August 2018
LARGE(Array,k)
- 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 Array} is the array of numbers.
- 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 of the largest number.
- LARGE(), returns the k-th largest value in a data set.
Description
- This function gives 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} -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 , 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 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. 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
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 13 | 10 | 9 | 13 | 21 |
| 2 | 28 | 15 | 10 | 16 | 19 |
| 3 | 12 | 19 | -1 | 0 | 18 |
- =LARGE(A1:E2,3) = 19
- =LARGE(A1:E2,9) = 10
- =LARGE(A2:E3,10) = -1
- =LARGE(A2:E3,9) = 0
Related Videos
See Also
References