BookmarkSubscribeSubscribe to RSS Feed
wongpl

Community Trekker

Joined:

Jun 23, 2011

Histogram count

I have plotted a histogram and plan to extract the histogram count in each column for further data manipulation.

can i know how i can get the row count ( orange arrow) in the histogram column and extract it in a table or variable/array?

6862_distribution.png

1 ACCEPTED SOLUTION

Accepted Solutions
ms

Super User

Joined:

Jun 23, 2011

Solution

Re: Histogram count

One way is to choose Save/Level Numbers found in the red triangle menu in the distribution report. A column with level ID's is then added to the original data table. Use e.g. Summary in the Tables menu to get the counts by selecting the ID column Level N in the Group filed and N of your variable of interest in the Statistics field.

4 REPLIES
ms

Super User

Joined:

Jun 23, 2011

Solution

Re: Histogram count

One way is to choose Save/Level Numbers found in the red triangle menu in the distribution report. A column with level ID's is then added to the original data table. Use e.g. Summary in the Tables menu to get the counts by selecting the ID column Level N in the Group filed and N of your variable of interest in the Statistics field.

tjmills

Community Trekker

Joined:

Apr 23, 2015

Re: Histogram count

You can also use the Save/Midpoint to save the data value of the histogram rather than just the bin number.

theseventhhill

Occasional Contributor

Joined:

Jul 21, 2018

Re: Histogram count

If I have more than 100 such distributions, how do i do a save levels options as a save all ? I hope there is a efficient way to export for each distribution 

txnelson

Super User

Joined:

Jun 22, 2012

Re: Histogram count

Holding down the CNTL key, while selecting the Save==>Level Numbers will generate the Level Numbers for all distributions that are displayed.

The holding down of the CNTL key while selecting options, or changing the size of a graph, etc. is a universal JMP option. The feature is documented in the Using JMP book

     Help==>Books==>Using JMP

or in the 14th "Tip of the Day"

     Help==>Tip of the Day

Jim