In statistics the MIN function is not enough. The need to calculate, for example, the third smallest value of a range of cells, is very common.
This is what the SMALL function calculates. It returns the n-th smallest value from an array of numeric values.
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.
When you are working in statistics Excel can be a very powerful ally.
In statistics there are various ways to measure the average – or more appropriate, the central tendency – of a range of numbers.
Excel implements three of them.
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.
