3.1.3 Treat Outliers
In this step you will need to remove outlying values from the uploaded data based on two approaches - Inter Quartile Range (IQR) and Percentile
If you select IQR, the available options for thresholds are 1.5 IQR, 2 IQR, and 3 IQR.
If you select percentile, the available options for thresholds are 1, 5, and 10.
Select tails - Left Tails Only or Right Tails Only or Both to trim data.
Table 3-1 Outlier Combination
SL# | Approach | Tails | Thresholds | Outlier Treatment Logic |
---|---|---|---|---|
1 | Inter Quartile Range | Left Tail only | 1.5 IQR | Remove the values which are less than Q1 - 1.5 IQR. |
2 | Inter Quartile Range | Right Tail only | 1.5 IQR | Remove the values which are greater than Q3 + 1.5 IQR. |
3 | Inter Quartile Range | Both Tails | 1.5 IQR | Remove the values which are less than Q1 - 1.5 IQR and the ones which are greater than Q3 + 1.5 IQR. |
4 | Percentile | Left Tail only | 5 | Remove the values which are less than 5th percentile. |
5 | Percentile | Right Tail only | 5 | Remove the values which are greater than 95th percentile. |
6 | Percentile | Both Tails | 5 | Remove the values which are less than 5th percentile and the ones which are greater than 95th percentile. |
To remove Outliers, follow these steps: