Create a Summary Table

To add marginal statistics (for the grouping variables) to the output columns, click the box beside Include marginal statistics. In addition to adding marginal statistics for each grouping variable, JMP adds rows at the end of the table that summarize each level of the first grouping variable.

Select Help > Sample Data Library and open Companies.jmp.

Select Tables > Summary.

Select Profits ($M) and click Statistics.

Select Mean.

Select Type and Size Co and click Group.

Select Include marginal statistics.

Click OK (or Create). See Figure 7.2 at left.

Figure 7.2 Summary Table with and without Marginal Statistics

Compare the summary table with marginal statistics (at left) to the summary table without marginal statistics (at right). You can see that the marginal statistics are added, and a row showing that there are 32 total Computer and Pharmaceutical companies.

Use Quantile Statistics

To add specific quantile statistics, follow these steps:

In the box under For quantile statistics, enter value (%) type the desired quantile value (%) for the first quantile (for example, 25).

Select the applicable column and click Statistics.

Select Quantiles.

(Optional) Repeat this process for any additional quantiles.

Change the Format of the Statistics Column Name

To change the format of the statistics column name in the summary table, select from one of the formats in the statistics column name format menu. Table 7.1 illustrates the available options. Assume that you are creating a summary table of the mean profits for a company. Your original column name is Profits ($M).

Table 7.1 Statistics Column Name Format Options and Examples
Option	Example
stat (column)	Mean (Profits ($M))
column	Profits ($M)
stat of column	Mean of Profits ($M)
column stat	Profits ($M) Mean

Link to the Original Data Table

You can select whether to link the summary table to the original data table. By default, the Link to original data table option is selected. If you want to edit the data in the summary table, deselect the Link to original data table option. When the summary table is linked to the original data table, you cannot edit the data in the summary table, because that would modify and compromise the original data. To edit the data, create a subset of the summary table or save the table, close the table, and reopen it.

Within linked tables, if you drag columns from the summary table into the column heading of a new column in the original data table, the values are expanded as if they were matched by grouping columns.

Prompt to Save When Closing Linked Summary Tables

To be prompted to save an unsaved linked summary table when you close it, select Prompt to save when closing summary tables. When you select this option in the Summary window, it is selected in the Tables preferences. If you do not want to be prompted to save linked summary tables in the future, deselect the preference.

Keep the Summary Window Open

If you select the Keep dialog open option, the Summary window remains open after you click Create. Notice that once you select this option, the OK button is replaced by a Create button.

Create a Two-Way Table of Summary Statistics by Adding a Subgroup Variable

Highlight the column(s) that you want to be the nested variable(s). These are your “subgroup variable(s).”

Click Subgroup to move the variable(s) into the subgroup list.

Highlight the column for which you want statistics summarized by subgroup.

In the Statistics list, select the specific statistic that you want.

Click OK.

For details about the types of statistics, see Explanation of Statistics.