topic Re: How to create deciles in JMP Pro 12? in Discussions https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15718#M14388 <HTML><HEAD></HEAD><BODY><P>I just displayed the decile created into distribution and it appears the 3rd and 4th decile are missing even though they appear in the formula. Could there be no records were allocated to these two decile when I entered 10 when specifying the percentile?</P></BODY></HTML> Thu, 03 Dec 2015 16:52:03 GMT jenkins_macedo 2015-12-03T16:52:03Z How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15710#M14380 <HTML><HEAD></HEAD><BODY><P>I have a set of scores derived from a model and I want to categorize these predictive scores into decile. How do I go about doing that?</P></BODY></HTML> Thu, 03 Dec 2015 15:33:31 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15710#M14380 jenkins_macedo 2015-12-03T15:33:31Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15711#M14381 <HTML><HEAD></HEAD><BODY><P>Perhaps <A href="https://community.jmp.com/docs/DOC-6081" target="_blank">Interactive Binning</A>​ would help.</P><P></P><P>It will set cut points based on percentiles.</P><P></P><P>-Jeff</P></BODY></HTML> Fri, 28 Oct 2016 13:22:48 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15711#M14381 Jeff_Perkinson 2016-10-28T13:22:48Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15712#M14382 <HTML><HEAD></HEAD><BODY><P>Or just use distribution then from the red triangle: Display Options&gt;Set Quantile Increment and enter the increment you desire and your Quantiles output will be updated with the desired quintiles.&nbsp; You can't save the quantiles as you can with the add-in (developer nudge - but I would like the option to save the quantile group).</P></BODY></HTML> Thu, 03 Dec 2015 15:59:58 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15712#M14382 KarenC 2015-12-03T15:59:58Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15713#M14383 <HTML><HEAD></HEAD><BODY><P>I just downloaded the app and trying to follow the instructions </P></BODY></HTML> Thu, 03 Dec 2015 16:00:17 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15713#M14383 jenkins_macedo 2015-12-03T16:00:17Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15714#M14384 <HTML><HEAD></HEAD><BODY><P>Sounds good. I will try both options. I want the data to be portray into ten deciles with the 1st decile of those who contain the highest predictive score and the 10th decile with those of the lowest predictive scores. Make sense?</P></BODY></HTML> Thu, 03 Dec 2015 16:02:59 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15714#M14384 jenkins_macedo 2015-12-03T16:02:59Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15715#M14385 <HTML><HEAD></HEAD><BODY><P>See if this helps with using the add-in for quantile column creation...I attached a few screen shots below.</P><P>This is my favorite way to do quantiles as you will have a ready quantile column created for anlaysis and graphing!</P><P></P><P>Once you identify the column, use the Set Cutpoints At Percentiles option from the Interactive Binning red triangle.</P><P>Then put in 10 to get every decile and put in the labels you want to see in the column.</P><P>Then use the Save Group Column to get the formula created back to your datatable!<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="10582_Screen Shot 2015-12-03 at 9.55.26 AM.png" style="width: 922px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/2472i8263825A8A1F09CC/image-size/medium?v=v2&amp;px=400" role="button" title="10582_Screen Shot 2015-12-03 at 9.55.26 AM.png" alt="10582_Screen Shot 2015-12-03 at 9.55.26 AM.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="10583_Screen Shot 2015-12-03 at 9.59.21 AM.png" style="width: 1352px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/2473i1B341FBEE0689881/image-size/medium?v=v2&amp;px=400" role="button" title="10583_Screen Shot 2015-12-03 at 9.59.21 AM.png" alt="10583_Screen Shot 2015-12-03 at 9.59.21 AM.png" /></span></P></BODY></HTML> Wed, 19 Oct 2016 01:18:30 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15715#M14385 scwise 2016-10-19T01:18:30Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15716#M14386 <HTML><HEAD></HEAD><BODY><P>Scott, this is exactly what I needed and went bye like wind using the Interactive Binning. Perfect guys!</P></BODY></HTML> Thu, 03 Dec 2015 16:29:14 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15716#M14386 jenkins_macedo 2015-12-03T16:29:14Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15717#M14387 <HTML><HEAD></HEAD><BODY><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="10584_Decile Results on Stepwise Regression Scores.jpg" style="width: 1003px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/2474i0B56D1ADE0A7580C/image-size/medium?v=v2&amp;px=400" role="button" title="10584_Decile Results on Stepwise Regression Scores.jpg" alt="10584_Decile Results on Stepwise Regression Scores.jpg" /></span></P></BODY></HTML> Wed, 19 Oct 2016 01:18:39 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15717#M14387 jenkins_macedo 2016-10-19T01:18:39Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15718#M14388 <HTML><HEAD></HEAD><BODY><P>I just displayed the decile created into distribution and it appears the 3rd and 4th decile are missing even though they appear in the formula. Could there be no records were allocated to these two decile when I entered 10 when specifying the percentile?</P></BODY></HTML> Thu, 03 Dec 2015 16:52:03 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15718#M14388 jenkins_macedo 2015-12-03T16:52:03Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15719#M14389 <HTML><HEAD></HEAD><BODY><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="10585_3rd - 4th Decile zero.jpg" style="width: 676px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/2475iD10F5283E0046B27/image-size/medium?v=v2&amp;px=400" role="button" title="10585_3rd - 4th Decile zero.jpg" alt="10585_3rd - 4th Decile zero.jpg" /></span></P></BODY></HTML> Wed, 19 Oct 2016 01:18:49 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15719#M14389 jenkins_macedo 2016-10-19T01:18:49Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15720#M14390 <HTML><HEAD></HEAD><BODY><P>Hey folks, I was able to fix the trouble. There were few areas were there were missing values</P></BODY></HTML> Thu, 03 Dec 2015 17:48:28 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/15720#M14390 jenkins_macedo 2015-12-03T17:48:28Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/66090#M34365 <PRE><CODE class=" language-jsl">Ceiling( (Col Rank( :weight ) / Col Number( :weight )) * 10 )</CODE></PRE> <P>I think this is quite an elegant solution. An example with the big class data table is attached.</P> Thu, 02 Aug 2018 16:04:36 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/66090#M34365 Phil_Kay 2018-08-02T16:04:36Z Re: How to create deciles in JMP Pro 12? https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/84616#M37869 How do I get this add-on into my JMP problem? Tue, 27 Nov 2018 20:53:38 GMT https://community.jmp.com/t5/Discussions/How-to-create-deciles-in-JMP-Pro-12/m-p/84616#M37869 ryanstar123 2018-11-27T20:53:38Z