topic Re: Summary statistics with multiple binning columns. in Discussions

Summary statistics with multiple binning columns.

dannyfinn11 — Sun, 24 Jun 2018 16:17:38 GMT

I'm trying to bin age data columne by range. So:

Millennials: 18-34
Generation X: 35-49 for example. Any idea how to quickly do this? I've created a copy of the data in a seperate column but I cant get jmp to bin out the data points.

Re: Summary statistics with multiple binning columns.

txnelson — Sun, 24 Jun 2018 16:56:25 GMT

You can do this a few different ways.

1. Use the "Recode" facility, which will allow you to either change the values in your existing column, or to create a new column with the binned values

2. Use the "Value Labels" column property, which will allow you to change the groupings for a column, without actually changing the stored values for the column

3. You can download the Interactive Binning Addin that Jeff Perkinson wrote

Interactive Binning

Re: Summary statistics with multiple binning columns.

dannyfinn11 — Sun, 24 Jun 2018 17:43:23 GMT

I used your second suggestion. But now some of the end range variables do not show up?

Re: Summary statistics with multiple binning columns.

txnelson — Sun, 24 Jun 2018 17:48:28 GMT

Can you attach the data table you made the changes to so I can take a look at the Value Labels you applied?

Re: Summary statistics with multiple binning columns.

dannyfinn11 — Sun, 24 Jun 2018 17:57:33 GMT

Re: Summary statistics with multiple binning columns.

txnelson — Sun, 24 Jun 2018 18:11:45 GMT

The age ranges need to have both a lower and upper range. For your last category, you only specified "65<". You need to also specify the upper boundary. Just put in 999 as the upper bound, and all should be working