This guide provides information on the structure, components and information contained in JMP data tables along with some tools useful for cleaning and preparing data for analysis.
The Tables Menu Functions
- Summary – Calculates summary statistics for columns in the active data table.
- Subset – Creates a new table that is a subset of the active table.
- Sort – Sorts a table by one or more columns.
- Stack – Stacks separate columns into one new column.
- Split – Splits a column into multiple columns.
- Transpose – Creates a table whose columns were the rows in the original table.
- Concatenate – Combines tables end to end (bottom to top).
- Join – Combines tables side by side.
- Update – Updates a table with values from a second table.
- Missing Data Pattern – Allows you to explore patterns in missing data.
- Compare Data Tables – Identifies differences between two open data tables.
Summarizing Data with the Summary Function
- From an open JMP data table, select Tables > Summary.
- Select one or more variables from Select Columns. Then, click on Statistics and select a statistic. Repeat for each statistic desired. A Preview of the resulting data table will be displayed on the right.
- To create a row for combinations of grouping variables, select the variable(s) from Select Columns, and click Group. An option to Preview the data table that will be created is shown on the right.
-
Click OK to create the new data table.
· The summary table has three rows, one for each category of the Group variable (Size Co, in this example).
· N Rows shows the number of rows of each category that were in the original table.
· Mean (Variable), the statistic we selected, is shown in the third column - Mean(Sales ($M)).
Example from Example: Companies.jmp found in Help > Sample Data Folder:
Notes: Summary statistics can also be created using Analyze > Distribution and Analyze > Tabulate.