topic Re: Creating a formula to categorize values by quantile in Discussions

Creating a formula to categorize values by quantile

NewbietoJMP — Wed, 12 Jul 2023 17:12:02 GMT

Advice on categorizing data in quantiles as a new variable.

Solved - thanks!

Re: Creating a formula to categorize values by quantile

Thierry_S — Wed, 12 Jul 2023 13:26:21 GMT

Hi,

I am not aware of a built-in function that would yield what you need. Instead, I use the formula below to classify my data dynamically into quartiles.

If(
	:DATA <= Col Quantile( :DATA, 0.25 ), 1,
	Col Quantile( :DATA, 0.25 ) < :DATA <= 	Col Quantile( :DATA, 0.5 ), 2,
	Col Quantile( :DATA, 0.5 ) < :DATA <= 	Col Quantile( :DATA, 0.75 ), 3,
	4
)

I hope it helps.

Best,

Re: Creating a formula to categorize values by quantile

Mark_Bailey — Wed, 12 Jul 2023 14:38:06 GMT

My approach is the same as @Thierry_S, but I used temporary variables in the formula for efficiency.