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.
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.
Some of the most useful features in Excel, are hidden under the data ribbon button, What-If analysis. In this tutorial, we will try to explain and use the Goal Seek feature.
