standard deviation excel

MAD versus Standard Deviation for a Uniform Distribution

What's the difference between mean absolute deviation and standard deviation for a uniform distribution for product data? Follow these formulas to find out.

By
Dr. Robert Tenga
October 6th, 2020
Data Analysis, Supply Chain

Relationship Between MAD and Standard Deviation for a Normally Distributed Random Variable

A colleague and I were talking recently, and the conversation turned to what is the relationship between Mean Absolute Deviation (MAD) and the Standard Deviation (STDEV). In this post, I will explain to you the math behind that approximation, which by the way, only applies to normal distributions.