Hi,
I'm trying to figure it out how get top 25th percentile of row values from data. basically subset the original data with top 25th percentile of values.
Tried this ;
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
top_25th_perc = dt << Summary(
Group( :sex),
Quantile( :height, .25 ),
Freq( "None" ),
Weight( "None" ),
Link to original data table( 1 ),
output table name( "top_25th_perc" )
);
which yields this table below.
What I need is that a subset of dt with only 25th percentile rows of both groups.
How to do that?
the following question how can we sample of those 25th percentile and say get some sample from that distribution. Again summary data table what I need.