Hello All,
I am interested in programming an Excel 2010 spreadsheet to perform an outlier assessment for a given data set using Median Absolute Deviation (MAD). If my data set is 0.913, 0.927, 0.778, 0.912, 1.387, 0.917, 0.920, 0.918, 0.916 and 0.921, how should I program my spreadsheet to calculate MAD? In addition, what is the best means in which to highlight if a value is an outlier? Thanks.
Bookmarks