Example of Creating a Summary Table with Groups
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.
Suppose that the researcher wants to perform the following tasks:
• Create a table that shows the average profit per employee for small, medium, and big computer and pharmaceutical companies. In other words, create a table that contains a row for each size company and a column for the mean profit per employee of each type of company.
• Create it so the cells hold the mean for the subgroup (defined by the intersection of the row and column).
To create a summary table with groups:
1. Select Help > Sample Data Folder 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 8.5 Summary Statistics for a Subgroup
Note: The summary table is named after the Group column name. If the column name contains characters that are not allowed in file names, a hyphen is substituted for the special character.