Suppose a researcher is working with Companies.jmp, which groups companies by Type and Size. Follow along with this next example by opening Companies.jmp from the sample data folder that was installed when you installed JMP.
1.
Select Help > Sample Data Library and open Companies.jmp.
2.
Select Tables > Summary.
3.
Select Size Co and click Group.
The researcher selects Size Co as the grouping variable because he wants the values in that column to become rows in the new table.
4.
Select profit/emp and click Statistics.
5.
Select Mean.
6.
Select Type and click Subgroup.
This tells JMP to create a column for the average profit per employee (Mean(profit/emp)) for each level (computer, pharmaceutical) of subgroup variable (type).
Figure 7.5 shows the completed Summary window and the resulting summary table.
Figure 7.5 Summary Statistics for a Subgroup

Help created on 7/12/2018