cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • We’re improving the Learn JMP page, and want your feedback! Take the survey
  • JMP monthly Newswire gives user tips and learning events. Subscribe
Choose Language Hide Translation Bar
aharro
Level II

Removing 5th percentile from a dataset

Does anyone have a jsl snippet of code that can remove the 5th percentile from a dataset? I've tried using the table summary.
Might be able to do it with the distribution chart.

2 REPLIES 2
jthi
Super User

Re: Removing 5th percentile from a dataset

You could also use Col Quantile() function

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

rows_of_interest = dt << Get Rows Where(:height > Col Quantile(:height, 0.8));

wait(1); // for demo purposes
dt << Delete Rows(rows_of_interest);

-Jarmo
AlbertoJD2000
Level II

Re: Removing 5th percentile from a dataset

@jthi Thank you appreciateblank.png for any solution..

Recommended Articles