Subscribe Bookmark RSS Feed

How do I create a frequency table from a histogram distribution?

tjmills

Community Trekker

Joined:

Apr 23, 2015

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
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.

Histogram count

1 REPLY
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.

Histogram count