Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
antonio-domenic
Level III

JMP15 Column Quantile bug?

In the following example I found that Col Quantile function (in JMP15) returns wrong data. Attached table test.jmp contains 3 columns. For each of them 75 and 25 quantiles are calculated using Col Quantile and Quantile. Results are different (JMP13 works correctly)

 

 

dt=current data table();
cols={"A","B","C"};

quant = function({dt2, c},{xx,p75,p25},
	xx=column(dt2,c) << get values;
	show(quantile(0.75,xx));
	show(quantile(0.25,xx));
	p75= col quantile(column(dt2,c),0.75); show(p75);
	p25 =col quantile(column(dt2,c),0.25); show(p25);
);			

sub_set = function({dt,c},{dt2}, 
		
		dt << select columns(c) << select all rows;
		dt2=dt << subset(invisible, selected columns, selected rows, linked to original data table(0));
		return(dt2);
);

for(i=1, i<=nitems(cols), i++,
	c=cols[i];
	dt2= sub_set(dt, c); 
	quant(dt2,c);
);

 

 

 

 

 

1 REPLY 1
Highlighted
txnelson
Super User

Re: JMP15 Column Quantile bug?

If you believe this calculation is incorrect please submit the issue to the JMP Support team

     support@JMP.com

Jim
Article Labels

    There are no labels assigned to this post.