cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
camlesse
Level I

byVar

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:

ClassYearClassRankQuintile

2010

1
20102
20103
20104
20105
20111
20112
20113

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
ron_horne
Super User (Alumni)

Re: byVar

3 REPLIES 3
ron_horne
Super User (Alumni)

Re: byVar

hi camlesse

follow this path:

Calculating Col Quantile by columns

Best,

ron

camlesse
Level I

Re: byVar

Thanks Ron.  Very helpful!

Re: byVar

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