topic Histogram count in Discussions

Histogram count

wongpl — Tue, 18 Oct 2016 21:12:26 GMT

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?

Re: Histogram count

ms — Mon, 16 Jun 2014 10:52:29 GMT

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.

Re: Histogram count

tjmills — Wed, 18 May 2016 22:08:53 GMT

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

Re: Histogram count

theseventhhill — Sun, 29 Jul 2018 03:07:50 GMT

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

Re: Histogram count

txnelson — Sun, 29 Jul 2018 03:17:51 GMT

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