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

tjmills — Wed, 18 May 2016 21:56:59 GMT

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

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

tjmills — Fri, 28 Oct 2016 13:26:46 GMT

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

topic How do I create a frequency table from a histogram distribution? in Discussions

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

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