cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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