Create a Summary Table
To create a summary table, follow these steps:
1. Open a data table.
2. Select Tables > Summary.
3. Highlight the columns that you want to summarize.
Note: For more information about the options in the red triangle menu, see “Column Filter Menu”.
4. Add summary statistics, groups, subgroups, frequency variable, weight variable, and select any options needed:
– Use One or More Grouping Columns
– Change the Format of the Statistics Column Name
– Link to the Original Data Table
– Prompt to Save When Closing Linked Summary Tables
– Keep the Summary Window Open
– Create a Two-Way Table of Summary Statistics by Adding a Subgroup Variable
5. Name the summary table by entering a name in the box beside Output table name.
6. Click OK.
Notes:
• 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.
• When you select a column that has a Units column property, that value is included in the column header.
Add Summary Statistics
You can add columns that display summary statistics (such as mean, standard deviation, median, and so on) for any numeric column in the source table.
1. In the Summary window, highlight the column that you want to use in calculating the statistics.
2. Click the Statistics button.
3. Select one of the standard univariate descriptive statistics from the Statistics list.
The statistics are described in Explanation of Summary Statistics.
Use One or More Grouping Columns
If you want the statistics to be summarized by group, highlight the columns that you want to be your grouping variables and click Group to move the variable into the grouping variables list. For an example, see Example of Creating a Summary Table with Groups. If you add only grouping variables, the summary table shows a count for each group.
To change the order of the grouping variables
To change the order of the grouping variables (ascending or descending order), select a variable in the grouping variable list and click the ascending or descending button (
). The icon beside the variable changes to indicate the sorting order.
You can also change the order of the grouping variables by using the Value Order column property. See “Value Order”.
To include marginal statistics
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.
1. Select Help > Sample Data Folder and open Companies.jmp.
2. Select Tables > Summary.
3. Select Profits ($M) and click Statistics.
4. Select Mean.
5. Select Type and Size Co and click Group.
6. Select Include marginal statistics.
7. Click OK.
See the left side of Figure 8.2.
Figure 8.2 Summary Table with and without Marginal Statistics
Compare the summary table with marginal statistics (on the left side in Figure 8.2) to the summary table without marginal statistics (on the right side). Notice that the marginal statistics are added, along with a row that shows that there are 32 total Computer and Pharmaceutical companies.
Use Quantile Statistics
To add specific quantile statistics, follow these steps:
1. In the box under For quantile statistics, enter value (%), enter the wanted quantile value (%) for the first quantile (for example, 25).
2. Select the applicable column and click Statistics.
3. Select Quantiles.
4. (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 8.1 shows 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).
Option | Example |
|---|---|
stat (column) | Mean (Profits ($M)) |
column | Profits ($M) |
stat of column | Mean of Profits ($M) |
column stat | Profits ($M) Mean |
stat | 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, clear 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 header 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, clear the preference.
Keep the Summary Window Open
If you select the Keep dialog open option, the Summary window remains open after you click Apply. Notice that after you select this option, the OK button is replaced by an Apply button.
Create a Two-Way Table of Summary Statistics by Adding a Subgroup Variable
1. Highlight the columns that you want to be the nested variables.
These are your “subgroup variables.”
2. Click Subgroup to move the variables into the subgroup list.
3. Highlight the column for which you want statistics to be summarized by subgroup.
4. In the Statistics list, select the specific statistic that you want.
5. Click OK.
For more information about the types of statistics, see Explanation of Summary Statistics.