cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
qspringleaf
Level III

How to use JMP script to auto generate a new summary table, quartile by group.

Kindly suggest How to use JMP script to auto generate a new summary table, quartile by group?

To summarize quartile 90%, 75%, 25% by three combination group: BOX & Site & GOUP.

thanks a lot.

 

BOXSiteGroupValue
602H0S140ID0030.246236
602H0S140ID0050.042778
602H0S140ID0070.983971
602H0S140ID0080.119373
602H0S140ID0090.843374
602H0S1303ID0030.763462
602H0S1303ID0050.407134
602H0S1303ID0070.405919
602H0S1303ID0080.092872
602H0S1303ID0090.801965
603H0S1425ID0030.720729
603H0S1425ID0050.87095
603H0S1425ID0070.696195
603H0S1425ID0080.441715
603H0S1425ID0090.044044
606H0S1303ID0030.285454
606H0S1303ID0050.379204
606H0S1303ID0070.268712
606H0S1303ID0080.215917
606H0S1303ID0090.259207
602H0S140ID0030.58708
602H0S140ID0050.221425
602H0S140ID0070.90981
602H0S140ID0080.870092
602H0S140ID0090.669536
602H0S1303ID0030.822202
602H0S1303ID0050.829393
602H0S1303ID0070.059759
602H0S1303ID0080.845642
602H0S1303ID0090.435138
606H0S1303ID0030.998371
606H0S1303ID0050.820604
606H0S1303ID0070.076275
606H0S1303ID0080.636501
606H0S1303ID0090.782624
1 REPLY 1
ThuongLe
Level IV

Re: How to use JMP script to auto generate a new summary table, quartile by group.

here is the code:

dt << Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table(
			Analysis Columns( :Value ),
			Statistics( Quantiles( 90 ), Quantiles( 75 ), Quantiles( 25 ) )
		),
		Row Table( Grouping Columns( :BOX ) ),
		Row Table( Grouping Columns( :Site ) ),
		Row Table( Grouping Columns( :Group ) )
	)
);
Thuong Le