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
lwx228
Level VIII

How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

For example, according to "Big class.jMP"
1. First, categorize by age.
2. Determine the minimum "weight" >90 for each age.
3. Figure out the number of age categories that meet the second condition.

So it turns out the number of ages is 3.

 

How can I use JSL to solve it quickly?Thanks!

2020-07-22_13-32.png

3 REPLIES 3
txnelson
Super User

Re: How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

Create a new column that has the categories you want. Then use Tables==>Summary to calculate the statistics. First generate the minimum for age, grouped by the binning column. Then to get the counts, the the Summary platform again, but this time group by both Age and the binning column.
Jim
lwx228
Level VIII

Re: How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

Thank Jim!

Looks like can only add auxiliary columns.
txnelson
Super User

Re: How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

?????
Jim