Outlier detection

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?

winequality-white.csv

Reporting

Preparation

Data Investigation

Accepted answers

MarqueeCrew

@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

All comments

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/25493

MarqueeCrew

@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

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235