cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Script for saving histogram count and midpoint

 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.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Script for saving histogram count and midpoint

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

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Script for saving histogram count and midpoint

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

Re: Script for saving histogram count and midpoint

Thanks you !