nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

657638_en-US

liliconcom

Re: Creating a formula to categorize values by quantile

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

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

Creating a formula to categorize values by quantile

Advice on categorizing data in quantiles as a new variable.

Solved - thanks!

Advanced Statistical Modeling

Basic Data Analysis and Modeling

Data Exploration and Visualization

Comments

There are no comments yet