I have table with outliers, and I want to decide outliers by Z-Score method,
The table is
col1 col2
0 1 12
1 120 17
2 3 31
3 5 53
4 2 22
5 12 32
6 13 43
At first, compute the Z-Score by each column
Then, if the absolute value of computed Z-Score > 2.2 ,consider it as outlier and set it NULL.
My expected result is
col1 col2
0 1 12
1 NULL 17
2 3 31
3 5 53
4 2 22
5 12 32
6 13 43
Many thanks