cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
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