topic Re: Ways to rank continous variable and save the quantile rank to a new column in Discussions

Ways to rank continous variable and save the quantile rank to a new column

polebear11280 — Fri, 02 Oct 2015 04:23:53 GMT

Hi there,

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:

https://community.jmp.com/message/42979#42979

https://community.jmp.com/docs/DOC-6081

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!

Re: Ways to rank continous variable and save the quantile rank to a new column

ian_jmp — Fri, 02 Oct 2015 07:37:06 GMT

'Cols > Utilities > Make Binning Formula', and the associated 'Help' is another option.

Re: Ways to rank continous variable and save the quantile rank to a new column

Jeff_Perkinson — Wed, 19 Oct 2016 00:48:35 GMT

Additionally, the Distribution platform can Save Level Numbers from the histogram.

So, you can use the grabber (hand) tool to adjust the histogram bins to your liking, setting the number and centering of the bins and then choose Save Level Numbers from the hotspot menu.

-Jeff

Re: Ways to rank continous variable and save the quantile rank to a new column

polebear11280 — Wed, 19 Oct 2016 00:48:44 GMT

Hi Jeff,

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.

Re: Ways to rank continous variable and save the quantile rank to a new column

Jordan_Hiller — Fri, 28 Oct 2016 13:21:15 GMT

Try this Interactive Binning Add-in: Interactive Binning (V2)