topic Re: Sorting Data into Categories in Discussions

Sorting Data into Categories

OrdinaryOcelot7 — Wed, 13 Mar 2024 23:35:58 GMT

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.

Re: Sorting Data into Categories

jthi — Thu, 14 Mar 2024 05:31:21 GMT

Select your column and create binning formula

There you can find few different options for the binning

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

Re: Sorting Data into Categories

txnelson — Thu, 14 Mar 2024 05:49:12 GMT

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];