JMP Tabulate is a drag-and-drop tool for flexibly creating tables of summary statistics. It is the JMP supercharged answer to Excel Pivot tables. Tabulate offers executive, supporting summary statistics and can be saved as summaries to be further analyzed using JMP statistical capabilities.
See how to:
- Understand the basic components of a tabulated table
- Grouping columns: Nominal or Ordinal columns that together specify the groups we want to summarize
- Analysis columns: Continuous columns for which we calculate summary statistics
- Statistics: One or more statistics to calculate for you analysis column, within each group
- Construct and save tabulated tables
Questions answered by Wendy Tseng @wendytseng and Clark Ledbetter @Clark_Ledbetter at the live Mastering JMP webinar.
Q: Can you add the units (for example, inches) to the table?
A: The information is being pulled from the table. You might want to add units directly in the table name or change the factor/column name (for example, Length (in inches). Or you can change labels by R-clicking.
Q: Can you format decimals, etc.?
A: Yes, at the bottom left of the control panel you will see a "Change Format" option.
Q: How do you calculate a frequency table for all variables?
A: Click and drag all the nominal / ordinal variables into either row or column drop zones and total count N will show up by default.
Q: How do you highlight cells in tabulate?
A: You can click directly in the "results" cell and cells will be highlighted. Tabulate doesn't currently support conditional formatting directly.
Q: Can you get tabulate to list by highest to lowest?
A: JMP is going to default to order alphabetically for categorical variables like NAME. So, the measurements (e.g., height and weight are going to be ordered by NAME). You can’t order by most statistics, and when you have a count column (N statistic), you can order by count. See below.
Order by Count Step 1
Order by Count Step 2
Q: Is there any document that shows how to do nested groupings better? For example, how would you get “N” and % side by side for different variables?
A: There are a few examples in the documentation that may help.
Q: Where is the Column Switcher?
A: Red triangle > Column Switcher or Redo> Column Switcher.
Q: If you use the selection tool to select the table and then copy into PowerPoint, the resolution is not good, especially when you increase the size. Can this be overcome?
A: Paste Special as "enhanced metafile gives better quality.
Q: What is the difference between "Freq" and "Weight" statistics?
A: This when the ? icon can be useful. Just grab the ? from the menu bar, hover over the field (in this case I hovered over Freq) and click. It brings you to the documentation on Freq.
There is also a general explanation. Frequency is number in the data used for calculations. Weighted frequency refers to Frequency with the weight applied which generally can be thought of as the estimated count in the population with the combination of values.
