Difference between revisions of "Manuals/calci/LARGE"
Jump to navigation
Jump to search
| (4 intermediate revisions by 2 users not shown) | |||
| 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. |
| − | + | **LARGE(), returns the k-th largest value in a data set. | |
| − | |||
==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>k</math>-largest value.<math>k</math> is the position from the largest to return. |
| − | *If <math> | + | *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. | ||
| − | 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== | ||
| Line 49: | Line 48: | ||
| − | [[Z_API_Functions | List of Main Z Functions]] | + | *[[Z_API_Functions | List of Main Z Functions]] |
| − | [[ Z3 | Z3 home ]] | + | *[[ Z3 | Z3 home ]] |
Latest revision as of 16:23, 7 August 2018
LARGE(Array,k)
- is the array of numbers.
- is the position of the largest number.
- LARGE(), returns the k-th largest value in a data set.
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
, 
is the number of data points in a range, then 
gives the largest value, and 
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