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. Use it to review contents of your data, provide executive-level supporting summary statistics, and summarize and aggregate data for further analysis.
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
-
Summarize key statistics
-
Aggregate data clearly
-
Show charts in alternate view with simple graphs (like bar charts) automatically added
-
Use Tabulate to create Hover Label for other graphs/reports
-
Save and share script to data table to easily recreate table
-
Export to image, Word (RTF), Powerpoint
Questions answered at the live Mastering JMP webinars on this topic:
Q: Can Tolerance Interval/Process Capability results be added to Tabulate?
A: No. Tabulate doesn't allow for new stats to be added directly, and preliminary info may be desired for Tolerance Intervals, so it's not geared toward Tabulate. Your aims for Process Capability here may be better handled by Process Screening (my guess), may be worth an exploration if you haven't already.
Q: I'm not seeing Pack Columns option on my version of JMP.
A: The Pack option is available in V17 and after, so if you have an earlier version, you won't see it.
Q: How can you make Size in order (that is, mall, medium, large)?
A: You can use "Value Order" column property to take care of that. You'll see Column Properties when you right click a column header, and from there you'll see Michael's reference to Value Order - and a lot of other great metadata you can store for use across JMP.
Q: Where did she paste the Tabulate table in Graph Builder?
A: Right click in the white space in graph. Hover Label > Paste Graphlet.
Q: Is there a way to change the tabulate formats (like color, or bold text for the summary statistics?)
A: You can modify your preferences (under File>Preferences) to change formats or right click on many tables to do this as well. But Tabulate does not have a full interactive text editor.
Q: How did you get the summaries under the column labels in the JMP table?
A: In JMP 15 or later you will see a grey horizontal histogram icon about the row name. You can toggle this on and off to see counts. See below.
Q: Are ther other ways to get summary statistics?
A: Yes, in Graph Builder 17 and later, you can also get some statistics interactively using a Caption Box. Here is how:
