Difference between revisions of "Manuals/calci/LARGE"

Latest revision as of 16:23, 7 August 2018

LARGE(Array,k)

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

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

       1. The array is empty.
       2.  $k\leq 0$  or  $k$  is greater than the total number of points in the given set.

@@ Line 2: / Line 2: @@
 *<math>Array</math>  is the array of numbers.
 *<math>k</math> is the position of the largest number.
+**LARGE(), returns the k-th largest value in a data set.
 ==Description==