topic Re: Script for saving histogram count and midpoint in Discussions

Script for saving histogram count and midpoint

Anonymous — Mon, 24 Sep 2018 08:39:42 GMT

Hello,

I red the "Histogram count" discussion.

I would like to write a script that does the same : saving in a table the midpoint value and the number of occurence with an adjusted binning.

It corresponds to the interactive sequence : Analyse/distribution of a column, adjust chart bin, save number of level and midpoint.

I don't need to display the chart, only record the values. I did not really found how to make it from Table/Summary.

Thank you for your help.

Re: Script for saving histogram count and midpoint

txnelson — Mon, 24 Sep 2018 10:13:11 GMT

Here is an example on how to generate a summary table with the counts from the bins from the Histogram Platform. It should give you a start on how to do this for your data

Names Default to here(1);

// Open the Big Class data table from the Sample Library
dt=open("$SAMPLE_DATA/Big Class.jmp");

// Run the Distribution Platform without visibility
dis = dt << Distribution(invisible, Continuous Distribution( Column( :height ) ) );

// Save the Midpoints to the data table
dis << save ( Level Midpoints);

// Close the invisible window
dis << close window;

// Use the Summary Platform to create the summary results
dtSum = dt << Summary(
	Group( :Midpoint height ),
	N( :height ),
	Freq( "None" ),
	Weight( "None" )
);

// Cleanup both data tables
dt << delete column("Midpoint Height");
dtSum << delete column("N Rows");

Re: Script for saving histogram count and midpoint

Anonymous — Mon, 24 Sep 2018 15:05:39 GMT

Thanks you !