Turn on suggestions

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

Showing results for

- JMP User Community
- :
- Discussions
- :
- How to get the table of values after constructing a histogram?

- 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

How to get the table of values after constructing a histogram?

Aug 23, 2018 10:45 AM
(921 views)

After I generate a histogram of the entries in a column, I would like to get out a table of the values of the individual bars that I can list on each bar. How can I do that?

5 REPLIES 5

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

Re: How to get the table of values after constructing a histogram?

Hi,

Since nobody came up with an elegant solution, here is my rather ugly solution

- Create your distribution graph: Distribution > xyz
- In the analysis menu, choose Save > Level Midpoints (new column created at the end of your table)
- Select Tabulate > Midpoint xyz --> Drop zone for rows
- In the analysis menu, choose "Make into table" --> New table with column #1 = Midpoint values and column #2 count of items
- To check that you have the right result, go to Graph Builder > X = Midpoint values and Y = count > Bar graph

Let me know if you need the probability data (it's a bit more complicated)

Best regards,

TS

Thierry R. Sornasse

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

Re: How to get the table of values after constructing a histogram?

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

Re: How to get the table of values after constructing a histogram?

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

Re: How to get the table of values after constructing a histogram?

So, what I need is an easy way to get out the table of counts. It's possible to do it manually, by listing the counts on each bar, but looking for an easier way, especially if I have a large number of bars in the histogram.

Thanks

Thanks

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

Re: How to get the table of values after constructing a histogram?

Separately from the histogram you could use the **If()** function in a column formula to assign a bin, then use **Tables** > **Summary** or **Analyze** > **Tabulate** to obtain the counts for each bin. Have you seen the **Cols** > **Utilities **> **Make Binning Formula** command?

All of this action could be scripted.

Learn it once, use it forever!