Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Script for saving histogram count and midpoint

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Sep 24, 2018 1:39 AM
(4703 views)

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

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

2 REPLIES 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Script for saving histogram count and midpoint

Thanks you !

Article Labels

There are no labels assigned to this post.