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==
@@ 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.
 *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,n)</math> gives the smallest value.
+*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 array is empty.