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

qspringleaf

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.

 

BOX	Site	Group	Value
602	H0S140	ID003	0.246236
602	H0S140	ID005	0.042778
602	H0S140	ID007	0.983971
602	H0S140	ID008	0.119373
602	H0S140	ID009	0.843374
602	H0S1303	ID003	0.763462
602	H0S1303	ID005	0.407134
602	H0S1303	ID007	0.405919
602	H0S1303	ID008	0.092872
602	H0S1303	ID009	0.801965
603	H0S1425	ID003	0.720729
603	H0S1425	ID005	0.87095
603	H0S1425	ID007	0.696195
603	H0S1425	ID008	0.441715
603	H0S1425	ID009	0.044044
606	H0S1303	ID003	0.285454
606	H0S1303	ID005	0.379204
606	H0S1303	ID007	0.268712
606	H0S1303	ID008	0.215917
606	H0S1303	ID009	0.259207
602	H0S140	ID003	0.58708
602	H0S140	ID005	0.221425
602	H0S140	ID007	0.90981
602	H0S140	ID008	0.870092
602	H0S140	ID009	0.669536
602	H0S1303	ID003	0.822202
602	H0S1303	ID005	0.829393
602	H0S1303	ID007	0.059759
602	H0S1303	ID008	0.845642
602	H0S1303	ID009	0.435138
606	H0S1303	ID003	0.998371
606	H0S1303	ID005	0.820604
606	H0S1303	ID007	0.076275
606	H0S1303	ID008	0.636501
606	H0S1303	ID009	0.782624

ThuongLe

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 ) )
	)
);