Summary statistics with multiple binning columns.

[#1]

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

1. Millennials: 18-34
2. 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. 

[#2]

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

[#3]

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

[#4]

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

[#5 · Accepted solution]

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