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 do I create a frequency table from a histogram...

Topic Options

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

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

May 18, 2016 2:56 PM
(2179 views)

I want to save a histogram with a defined bin size of a continuous response variable as a table with one row for each bin in the histogram. Each row would have the beginning bin value, ending bin value and count of data rows from the original data set. I have searched in the forum and via Google. I need to be able to do this today and I am hoping JMP can do this quickly.

(Sorry if this is a duplicate, but when I typed in my "Ask a Question", it lost what I typed and took me to the "Start a Discussion" screen.)

1 ACCEPTED SOLUTION

Accepted Solutions

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

Solution

I found the way to do this at another post (link below) and with help from Nate (at JMP) we used the Save/Midpoint option to save the data to the data table. Then using the tabulate funtion, you can group the data by midpoint to get the counts for each bin value.

1 REPLY

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