The commands on the Tables menu (and Tabulate on the Analyze menu) summarize and manipulate data tables into the format that you need for graphing and analyzing. This section describes five of these commands:
Create summary tables by using either the Summary or Tabulate commands. The Summary command creates a new data table. As with any data table, you can perform analyses and create graphs from the summary table. The Tabulate command creates a report window with a table of summary data. You can also create a table from the Tabulate report.
 1 Select Help > Sample Data Library and open Companies.jmp.
 2 Select Tables > Summary.
 3 Select Type and Size Co and click Group.
 4 Select Sales (\$M) and Profits (\$M) and click Statistics > Mean.
Completed Summary Window
 5 Click OK.
JMP calculates the mean of Sales (\$M) and the mean of Profit (\$M) for each combination of Type and Size Co.
Summary Table
 • There are columns for each grouping variable (in this example, Type, and Size Co).
 • The N Rows column shows the number of rows from the original table that correspond to each combination of grouping variables. For example, the original data table contains 14 rows corresponding to small computer companies.
 • There is a column for each summary statistic requested. In this example, there is a column for the mean of Sales (\$M) and a column for the mean of Profits (\$M).
 1 Select Help > Sample Data Library and open Companies.jmp.
 2 Select Analyze > Tabulate.
Tabulate Workspace
 3 Select both Type and Size Co.
 4 Drag and drop them into the Drop zone for rows.
Dragging Columns to the Row Zone
 5 Right-click a heading and select Nest Grouping Columns.
Initial Tabulation
 6 Select both Sales (\$M) and Profits (\$M), and drag and drop them over the N in the table.
The tabulation now shows the sum of Sales (\$M) and the sum of Profits (\$M) per group.
Tabulation of Sums
 7 The final step is to change the sums to means. Right-click Sum (either of them) and select Statistics > Mean.
Final Tabulation
 1 Select Help > Sample Data Library and open Companies.jmp.
 2 Select Rows > Row Selection > Select Where.
 3 Select Size Co in the column list box on the left.
 4 Enter medium in the text enter box.
 5 Click OK.
 6 Hold down the Ctrl key and select the Type, Sales (\$M), and Profits (\$M) columns.
 7 Select Tables > Subset to launch the Subset window.
Subset Window
 8 Select Selected columns to subset only the columns that you selected. You can also customize your subset table further by selecting additional options.
 9 Click OK.
 1 Select Help > Sample Data Library and open Companies.jmp.
 2 Select Analyze > Distribution.
 3 Select Type and click Y, Columns.
 4 Click OK.
 5 Double-click on the histogram bar that represents Computer to create a subset table of the Computer companies.
Caution: This method creates a linked subset table. This means if you make any changes to the data in the subset table, the corresponding value changes in the source table.
 1 Select Help > Sample Data Library and open Trial1.jmp and Little.jmp.
 2 Click on Trial1.jmp to make it the active data table.
 3 Select Tables > Join.
 4 In the Join ‘Trial1’ With box, select Little.
 5 From the Matching Specification menu, select By Matching Columns.
 6 In the Source Columns boxes, select popcorn in both boxes, and then click Match.
 7 In the same way, match batch and oil amt to oil in both boxes.
 8 Select Include non-matches for both tables.
 9 To avoid duplicate columns, select the Select columns for joined table option.
 10 From Trial1, select all four columns and click Select.
 11 From Little, select only yield and click Select.
Completed Join Window
 12 Click OK.
Joined Table
 1 Select Help > Sample Data Library and open Companies.jmp.
 2 Select Tables > Sort.
 3 Select Type and click By to assign Type as a sorting variable.
 4 Select Profits (\$M) and click By.
Sort Ascending Icon
 5 To change Profits (\$M) to sort in descending order, select Profits (\$M) and click the descending button.
Change Profits to Descending
 6 Select the Replace Table check box.
When selected, the Replace Table option tells JMP to sort the original data table instead of creating a new table with the sorted values. This option is not available if there are any open report windows created from the original data table. Sorting a data table with open report windows might change how some of the data is displayed in the report window, especially in graphs.
 7 Click OK.