This video demonstrates how to calculate the median deviation (median absolute deviation) using Microsoft Excel. The mean deviation, variance, and standard deviation are also reviewed.
This video was a helpful step by step guide to calculating the mean, median, mean deviation, median deviation, variance, and standard deviation in Excel. It also helped to clear up some of those terms for me.
Thanks for this explanation. But what to do if boxes we want to select are not in consecutive boxes (for example, if I want to compute the median deviation of values in boxes A1; A3:A5)?
