Outlier detection

[Wakelij2]

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?

[Qiu]

@Wakelij2 

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

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Finding-Outliers-where-to-start/td-p/2...

[MarqueeCrew · Accepted solution]

@Wakelij2 ,

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

[AnushaSannidhi]

@Marquee Crew

Could not find the macro you are talking about ( CReW-Modify-Outliers ).

[MarqueeCrew]

@AnushaSannidhi ,

The gallery has moved:  https://community.alteryx.com/t5/Public-Community-Gallery/CReW-Outlier-Detection-Beta/ta-p/888951

Cheers,

Mark