The need to determine the maximum and the minimum values of a range of cells, is common to almost all types of excel projects.
But in statistics the MIN and MAX functions are not enough. The need to calculate, for example, the third largest or smallest value of a range of cells, is very common.
The MAX functions returns the largest number in a set of values.
If you need to get the second or third or n-th largest number in a set of values then you should use the LARGE function.
The MIN functions returns the smallest number in a set of values.
If you need to get the second or third or n-th smallest number in a set of values then you should use the SMALL function.
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.
