Financial		Logical		Informational		Text
Mathematical		Statistical		Lookup		Reference		Formula Errors

Average or arithmetic mean is calculated by adding a set of numbers and dividing by the count of those numbers

Syntax
AVERAGE(number1, [number2],...)

number1	The first parameter which should be a number format
[number2]	Optional parameters, the next set of numbers

MODE is the most frequently occurring number in a set of numbers.

Syntax
MODE(number1,number2,...)

number1	The value that is being searched
number2	The data table containing lookup value and the corresponding row value

MEDIAN is the middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median.

Syntax
MEDIAN(number1,number2,...)

number1	The value that is being searched
number2	The data table containing lookup value and the corresponding row value

Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing
For example, you can use LARGE to return the highest, runner-up, or third-place score.

Syntax
LARGE(array,k)

Array	is the array or range of data for which you want to determine the k-th largest value.
K	is the position (from the largest) in the array or cell range of data to return.

Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)

Syntax
RANK(number,ref,order)

Number	is the number whose rank you want to find
Ref	is an array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored
Order	is a number specifying how to rank number

Click Here to Download a copy of ExcelTechie Text Statistical Workbook