Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
I have a column of data that I'd like to separated into 5 categories (well above average, above average, average, below average, well below average). Average would be the mean. The standard deviation between each category would be 1.5.