You don't need to. Average deviation (about the mean) is always zero!
Chat with our AI personalities
The mean average deviation is the same as the mean deviation (or the average deviation) and they are, by definition, 0.
You calculate the mean.For each observation, you calculate its deviation from the mean.Convert the deviation to absolute deviation.Calculate the mean of these absolute deviations.
Because the average deviation will always be zero.
There is no single function in Excel.You calculate the mean (average).For each observation, you calculate its deviation from the mean.Convert the deviation to absolute deviation.Calculate the mean (average) of these absolute deviations.
deviation 15 is better