Include rows with Percentile satisfying this expression
Use this option to include rows in which the percentile intensity meets the specified criteria.
The expression entered in this field must include the key term PCTL and have the appropriate syntax. Valid expressions include:
• | PCTL GT xx, which instructs the process to include rows in which the percentile z is greater than some number xx, |
• | PCTL LT xx, which instructs the process to include rows in which the percentile z is less than some number xx, and |
• | PCTL EQ xx, which instructs the process to include rows in which the percentile z is equal to some number xx. |
The number xx is some whole number that you specify in the statement.
The percentile z is specified using the Percentile to Compute for PCTL Statistic field/slider.
To Specify an Expression for Filtering Rows:
8 | Type the desired filtering expression in the text box. |
For example, to include only those rows in which the 80th percentile exceeds 5, type PCTL GT 5 in the text box (shown below) and specify 80 using the Percentile to Compute for PCTL Statistic field/slider.
8 | If you change your mind and would like to reset the field, click . |