topic Re: get values of 5 number summary from boxplot graph in graph builder in Discussions

get values of 5 number summary from boxplot graph in graph builder

sebbeyer — Sun, 11 Jun 2023 11:23:50 GMT

Hey JMP-community,

I need help with a JSL script. I would like to work with multible values from the "5 number summary" of boxplot graphs in the graph builder. Do you know how to get these values - f.e. in a list or a matrix? to work with these after the graph is build?

BR and thank you in advance

Re: get values of 5 number summary from boxplot graph in graph builder

Mark_Bailey — Wed, 20 Apr 2022 12:12:25 GMT

I would not try to extract this information from Graph Builder. I would use another platform instead. The Distribution platform computes these quantiles for you. You can open it as an invisible platform, extract the values, and then close it. See this example:

Names Default to Here( 1 );

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

dist = dt << Distribution( Y( :weight ), Invisible );
rpt = dist << Report;

five pt summary = { min, q1, med, q3, max } = rpt["Quantiles"][NumberColBox(1)] << Get( { 11, 7, 6, 5, 1 });

dist << Close Window;

Re: get values of 5 number summary from boxplot graph in graph builder

sebbeyer — Mon, 25 Apr 2022 07:44:33 GMT

Thanks alot for you reply, that did in fact help me. I have just one open question left: When I create the distribution all values from all Boxes are put together. Is there an option to create the distribution for different X values? I try to explain it in my example above your post. There are 5 Boxes for different x values (here EC1, EC2, LS20,...) Is it possible to create these distributions for each different X value?

Re: get values of 5 number summary from boxplot graph in graph builder

ian_jmp — Mon, 25 Apr 2022 09:27:31 GMT

Adding in a grouping or a 'by' variable makes the method of @Mark_Bailey a little more complex (but perfectly doable). As an alternative, though, you could build on this:

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Big Class.jmp" );
Summarize( exg = By( :sex ), exm = Mean( :height ), exMax = Max(:height) );
Print(exg, exm, exMax);

Re: get values of 5 number summary from boxplot graph in graph builder

sebbeyer — Tue, 26 Apr 2022 07:02:34 GMT

Thank you. I have tested the Group by function in the script, but it did not turn out as expected... I have adapted @markbailey s script with: dist << Group By (X (:sex));

Any suggestions what might be the problem here?

BR and thank you in advance

Names Default to Here( 1 );

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

dist = dt << Distribution( Y( :weight ), Invisible );
dist << Group By (X( :Sex));
rpt = dist << Report;

five pt summary = { min, q1, med, q3, max } = rpt["Quantiles"][NumberColBox(1)] << Get( { 11, 7, 6, 5, 1 });

dist << Close Window;

Re: get values of 5 number summary from boxplot graph in graph builder

Mark_Bailey — Tue, 26 Apr 2022 14:54:23 GMT

This example should give you the essential ideas and approach:

Names Default to Here( 1 );

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

// launch platform and analyze separately by :sex and save reference to analysis layer
dist = dt << Distribution( Y( :weight ), By( :sex ) );

// get reference to report layer
rpt = dist << Report;

// get reference to all Qunatiles outline boxes
quantile table = rpt << XPath( "//OutlineBox[text()='Quantiles']" );
n rpts = N Items( quantile table );

// prepare empty container for all five-point summaries
summary = J( 5, n rpts, . );

// iterate over all Quantile reports
For( r = 1, r <= n rpts, r++,
	summary[0,r] = Matrix( (quantile table[r])[1][NumberColBox(1)] << Get( { 11, 7, 6, 5, 1 } ) );
);

// survace matrix as a new data table
As Table( summary );

dist << Close Window;