Hi Everyone,
I need your assistance working on a large data set that I am working with. I am looking for a restrictive way of identifying the outliers in my data. I am currently using the median and an array formula to identify outliers that are two deviations from the Median Absolute Deviation. This gives me both positive and negative outliers. I used an array formula to distinguish between normal data and an outlier. However outlier shows up for both positive data and negative data. How do I distinguish between the two types of outliers?
Secondly, is there a better approach to finding outliers and how do I go about capturing the data.
Any assistance you have would be greatly appreciated.
Thanks.
Bookmarks