Thank you for looking into my question. I am wondering if there is any easy way to save the quantile rank of variable to a new column in JMP. In SPSS, for example, if you want to get a new column of quantile rank of variable, you can use " rank cases" function and SPSS will evenly group rows/records into number of groups you specify and save the numeric value of the group to a new variable.
Some solutions I have found is on community:
but they don't come in a very easy way. I would love to know if there is any built-in function that I haven't got to know yet that could enable this. Thank you!
Solved! Go to Solution.
Thank you for your response. I tried this method and it seems JMP will divide the group based on the value of the variable, which will leave the group evenly distributed ( bars are not the same length/height). Say for example, if I have 1000 rows of income data, I want to save the top 250 income records as group1. In JMP, even if I make it to 5 group, as the example I show below, the first group will not have 250 observations.