In statistics the MAX function is not enough. The need to calculate, for example, the third largest value of a range of cells, is very common. This is what the LARGE function calculates. It returns the n-th largest value from an array of numeric values.
The MODE.SNGL function is one of the three Excel functions that measure Central Tendency. The other two are the AVERAGE and MEDIAN functions. It calculates the most frequent value in a data set. It has the same syntax as the MODE function.
In statistics the median is the middle of a set of numbers. This is what the function MEDIAN calculates. It is one of the functions that Excel has implemented to calculate the Central Tendency.
The MODE function is one of the three Excel functions that measure Central Tendency. The other two are the AVERAGE and MEDIAN functions. It calculates the most frequent value in a data set.
The AVERAGE function returns the arithmetic mean of its arguments.
The COUNT function provides us with a way to count the number of cells that contain numbers.
The COUNTA function counts the number of cells in a range, that are not empty.
It is sometimes being confused with its sibling COUNT function.
One of the most used functions in Excel is the SUM function. It is used to calculate the sum of a cell range and can be used by itself or in combination with other functions boosting their potential.
