Delete rows with Interquartile Range satisfying this expression (use keyword IQR)
Use this option to delete rows in which the interquartile range meets the specified criteria.
The expression entered in this field must include the key term IQR and have the appropriate syntax. Valid expressions include:
• | IQR GT xx, which instructs the process to eliminate rows in which the interquartile range is greater than some number xx, |
• | IQR LT xx, which instructs the process to eliminate rows in which the interquartile range is less than some number xx, and |
• | IQR EQ xx, which instructs the process to eliminate rows in which the interquartile range is equal to some number xx. |
The number xx is some whole number that you specify in the statement.
To Specify an Expression for Filtering Rows:
8 | Type the desired filtering expression in the text box. |
Example: To eliminate rows in which the interquartile range exceeds 5, type IQR GT 5 in the text box, as shown below:
8 | If you change your mind and would like to reset the field, click . |