topic 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? in Discussions

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

lwx228 — Fri, 09 Jun 2023 23:32:54 GMT

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!

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?

txnelson — Wed, 22 Jul 2020 06:28:27 GMT

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.

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?

lwx228 — Wed, 22 Jul 2020 06:36:48 GMT

Thank Jim!

Looks like can only add auxiliary columns.

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?

txnelson — Wed, 22 Jul 2020 10:25:25 GMT

?????