3.1.5 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-2 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:

  1. Select an Outlier Removal Approach – Inter Quartile Range or Percentile.
  2. Select Tails - Left Tails Only or Right Tails Only or Both.
  3. From the Thresholds drop-down, select a threshold.
  4. Click Continue to view the recommended Threshold values. The system calculates the initial thresholds.

    Or click Discard to discard the current activity.

    Click Download to the data and review. You can also edit the data and upload again.