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?
Since nobody came up with an elegant solution, here is my rather ugly solution
Let me know if you need the probability data (it's a bit more complicated)
Highlight the bar you are interested in. Rightclick and choose Subset - but make sure you have the column in the dataset you are interested in (the one you show the distribution of). You will have a new dataset of the values in that bar.
That's not what I need. I would like to calculate the Probability Mass Function corresponding to the histogram. So, I need to get out the number of values that are in each bin, that I will divide by the total number of bins to get the PMF.
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.
There are no labels assigned to this post.