You don't need to and probably shouldn't remove the outliers from your dataset. ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		moehm on Jan 12, 2021 \| parent \| context \| favorite \| on: Simple Anomaly Detection Using Plain SQL You don't need to and probably shouldn't remove the outliers from your dataset. You can easily query it with: `SELECT * FROM series WHERE is_anomaly = f;` If you want you can wrap a (materialized) view around this.

pelliphant on Jan 12, 2021 [–]

Thnx, but my point was that if there are no outliers, there will still be values that are located more than one stdev from the average.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact