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
- :
- Discussions
- :
- byVar

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

Jan 20, 2016 5:42 PM
(3131 views)

Please excuse the simplicity of the request. I am trying to use a column formula to determine the quintile for a column of values that are divided into specific groups in another column. The data look something like this:

ClassYear | ClassRank | Quintile |
---|---|---|

2010 | 1 | |

2010 | 2 | |

2010 | 3 | |

2010 | 4 | |

2010 | 5 | |

2011 | 1 | |

2011 | 2 | |

2011 | 3 |

I want the formula in the quintile column to determine in what quintile the class rank is depending on the year. I cannot get the correct syntax in the formula to make the calculation. All attempts to use Quantile [;ClassRank, :ClassYear] result in only Class Rank appearing in the column formula. Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions

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

Jan 21, 2016 2:05 AM
(5311 views)

3 REPLIES

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

Jan 21, 2016 2:05 AM
(5312 views)

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

Jan 21, 2016 6:28 PM
(2969 views)

Thanks Ron. Very helpful!

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

Jan 22, 2016 7:25 AM
(2969 views)

The Summarize() function is also simple to use but quite powerful when you have a By variable to consider.

Learn it once, use it forever!