Difference between revisions of "Manuals/calci/LARGE"

Revision as of 13:01, 6 June 2018

LARGE(Array,k)

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,n)$ 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 8: / Line 8: @@
 *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.
-*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.
+*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>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.
+*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.
 *The function gives the result as error when
 . The array is empty.