turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- How to create deciles in JMP Pro 12?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 7:33 AM
(2618 views)

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?

Jenkins Macedo

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 8:19 AM
(4664 views)

Solution

See if this helps with using the add-in for quantile column creation...I attached a few screen shots below.

This is my favorite way to do quantiles as you will have a ready quantile column created for anlaysis and graphing!

Once you identify the column, use the Set Cutpoints At Percentiles option from the Interactive Binning red triangle.

Then put in 10 to get every decile and put in the labels you want to see in the column.

Then use the Save Group Column to get the formula created back to your datatable!

10 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 7:51 AM
(2332 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 8:00 AM
(2332 views)

I just downloaded the app and trying to follow the instructions

Jenkins Macedo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 7:59 AM
(2332 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 8:02 AM
(2332 views)

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?

Jenkins Macedo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 8:19 AM
(4665 views)

See if this helps with using the add-in for quantile column creation...I attached a few screen shots below.

This is my favorite way to do quantiles as you will have a ready quantile column created for anlaysis and graphing!

Once you identify the column, use the Set Cutpoints At Percentiles option from the Interactive Binning red triangle.

Then put in 10 to get every decile and put in the labels you want to see in the column.

Then use the Save Group Column to get the formula created back to your datatable!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 8:29 AM
(2332 views)

Scott, this is exactly what I needed and went bye like wind using the Interactive Binning. Perfect guys!

Jenkins Macedo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 8:40 AM
(2332 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 8:52 AM
(2332 views)

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?

Jenkins Macedo

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 3, 2015 8:56 AM
(2332 views)