cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

Sorting Data into Categories

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. 

2 REPLIES 2
jthi
Super User

Re: Sorting Data into Categories

Select your column and create binning formula

jthi_0-1710394205789.png

There you can find few different options for the binning

jthi_1-1710394234528.png

If that doesn't work you can write your own custom formula using Col Std Dev and Col Mean

-Jarmo
txnelson
Super User

Re: Sorting Data into Categories

I think this will work.

As Constant(
	theMean = Col Mean( :target column );
	theSTD = Col Std Dev( :target column );
	theBinMatrix = Matrix( -99999999 ) || Matrix( theMean - 1.5 * theSTD ) ||
	Matrix( theMean - 0.5 * theSTD ) || Matrix( theMean + 0.5 * theSTD ) ||
	Matrix( theMean + 1.5 * theSTD );
);
Loc Sorted( theBinMatrix, Matrix( :target column ) )[1];
Jim

Recommended Articles