Manuals/calci/LARGE

LARGE(Array,k)

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 $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.