Range and Mean Absolute Deviation – Excel template

Ned Krastev
Ned Krastev

Range and mean absolute deviation are used for measuring dispersion. The range gives us an idea of how far from each other the two values are, while the mean absolute deviation significantly improves the range calculation, as it takes into consideration the distance from the mean. It is applied by subtracting the minimum value in a given data set from the maximum value.

Some other related topics you might be interested to explore are Mean, Variance and Standard deviation.

This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Statistician, Data Analyst, Data Scientist, or Asset Manager.

You can now download the Excel template for free.

Range and Mean Absolute Deviation are among the topics included in the Quantitative Methods module of the CFA Level 1 Curriculum.