I have a data set and I need to delete outliers from it (as you normally would) however the process I have followed seems to delete far more than the outliers. Attached is my data and the below image is the process I have done to detect outliers
My data has ~4900 rows of data, however this outlier detection is cutting that number down to ~390 rows. The formulas I have in the formula tool are:
and in the filter I have the following custom filter:
Does anyone have any idea where I have gone wrong and how I can improve this for a more accurate outlier detection?
Solved! Go to Solution.
Honestly, maybe you are not in the right track.
Take look at these threads, and maybe they can help.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Outlier-and-Correlation/td-p/665310
i built an outlier macro that will allow you to pick an outlier method and identify, modify or delete the outliers.
https://gallery.alteryx.com/#!app/CReW-Modify-Outliers/5a80861feffc2a2658b0ad96
cheers,
mark
@Marquee Crew
Could not find the macro you are talking about ( CReW-Modify-Outliers ).
The gallery has moved: https://community.alteryx.com/t5/Public-Community-Gallery/CReW-Outlier-Detection-Beta/ta-p/888951
Cheers,
Mark