Additional functions for summary table via JSL

FN

I would like to know how I can obtain summary tables but with additional statistics.

For example, Mode() is a function that one can use in a formula, but this does not work:

 

 

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

dt << Summary( Group( :Age ),
             subgroup( :sex ),
             Mode( :Height ));&nbsp;&nbsp;//&nbsp;Mode&nbsp;isntead&nbsp;of&nbsp;mean

I would also like to summarize the table by getting the last or first number of the group.

 

ian_jmp

FWIW (and if you know a little JSL), you can do this kind of thing:

Names Default To Here( 1 );

// Sample data
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

// Invisible Distribution with 'By' group(s)
dist = dt << Distribution(Continuous Distribution(Column( :height ),Customize Summary Statistics(Mode(1))), By(:age, :sex), Invisible);

// Get the Summary Stats
dt2 = Report(dist[1])[TableBox(2)] << makeCombinedDataTable;
Report(dist[1]) << closeWindow;

// Retain only the Mode
dt3 = dt2 << Subset(Rows(dt2 << getRowsWhere(:Column 1 == "Mode")));
dt3 << setName("Mode Values");
Column(dt3, "Column 1") << setName("Statistic");
Column(dt3, "Column 2") << setName("Value");
Close(dt2, NoSave);

I would also consider the JMP Wish List.