Delete rows with Interquartile Range satisfying this expression
Specify one or more filtering expressions to filter by IQR value. The IQR is the difference between the 75th percentile (sometimes referred to as Q3) and the 25th percentile (sometimes referred to as Q1). Use the keyword IQR.
Valid expressions include:
• | IQR GT xx (Greater Than) |
• | IQR LT xx (Less Than) |
• | IQR EQ xx (Equal to) |
where xx is an integer that you specify.
Important: Do not use double quotation marks.
Example: To delete rows in which the interquartile range exceeds 10, specify IQR GT 10 in this field.
To Specify Rows to Delete:
8 | Specify an option other than none for the Delete rows: parameter. |
8 | Type a valid expression into the text field. |
8 | If you change your mind and would like to reset the field, click . |