Difference between revisions of "Manuals/calci/LARGE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''LARGE( | + | <div style="font-size:30px">'''LARGE(Array,k)'''</div><br/> |
| − | *<math> | + | *<math>Array</math> is the array of numbers. |
| − | *<math> | + | *<math>k</math> is the position of the largest number. |
==Description== | ==Description== | ||
| − | *This function gives the <math> | + | *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. | *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( | + | *In <math>LARGE(Array,k)</math>, <math>Array</math> is the array of data to find the <math>i</math>-largest value.<math>k</math> is the position from the largest to return. |
| − | *If <math>k</math> is the number of data points in a range, then <math>LARGE( | + | *If <math>k</math> is the number of data points in a range, then <math>LARGE(Array,k)</math> gives the largest value, and <math>LARGE(Array,1)</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. | ||
| − | 2. <math> | + | 2. <math>k\le 0</math> or <math>k</math> is greater than the total number of points in the given set. |
==Examples== | ==Examples== | ||
Revision as of 13:57, 6 June 2018
LARGE(Array,k)
- is the array of numbers.
- is the position of the largest number.
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
, 
-largest value.
gives the smallest value. 1. The array is empty.
2. or is greater than the total number of points in the given set.
or 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