Using JMP • Summarize Data • Example of Creating a Summary Table
Previous
 • 
Next
Example of Creating a Summary Table
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 the researcher wants to:
•
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).
1.
Open the Companies.jmp sample data table.
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).
Summary Statistics for a Subgroup shows the completed Summary window and the resulting summary table.
Summary Statistics for a Subgroup