Choose Language Hide Translation Bar
Highlighted
midori555
Level II

Exclude rows in Col Quantile Calculation

Hi,

I was trying to get Col Quantile( :height, 0.5, :class) but it looks like the calculation would still take the excluded rows into consideration. 

Is there a way to reject the excluded rows into Col Quantile calculation?

 

Thanks,

Midori

 

1 REPLY 1
Highlighted
txnelson
Super User

Re: Exclude rows in Col Quantile Calculation

You can check for the row being excluded within the Col Quantile() function.  Below is an example

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "Col Quantile Height by Age",
	numeric,
	continuous,
	formula( Col Quantile(If(excluded(rowstate(Row())),., :height), 0.5, :age ) )
);

Whenever the excluded rowstate changes for the rows in the data table, the formula will calculate new values

Jim
Article Labels