cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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