Filter

Filters a column and stores the result in a column.

Filter

All outliers

Filters all the values outside 1.5 IQR distance.

Only extreme outliers

Filters all the values outside 3 IQR distance.

Min/Max

Filters on self defined min max values.

Zero values

Filters the all the zeros.

Filter options

Copy only the filtered values or Exclude the filtered values.

Example

Tools => Filter
In the example in column B is the filtered data and in column C are the outliers and in column A is the original data. After filtering the data is normally distributed.

Data file