Organizing and Getting the Most from JMP® Tables
Created:
| Last Modified:
See how to:
- Create, format and navigate rows and columns from data grid and table panel
- Use column properties to set data types (numeric, character, row state, expression) and modeling types (continuous, ordinal, nominal, multiple response, unstructured text, vector)
- Understand the way JMP analyzes data based on data and modeling types
- Use multiple response character data; hide and/or exclude rows and understand what each means
- Use red triangle hot spots to sequentially disclose analysis and formatting options
- Group table script to organize them in table panel
- Format columns
- Understand the Distribution column exception related to incorrect data or analysis type
- See how JMP graphically links multiple response data on some graphs to show relationship between values
- Use shortcuts to move between graphs and reports
- Save replayable analysis scripts to data table panel
- Add metadata (notes, list check, value labels, value ordering, formula, formula preview results) to a group of columns
- Recode in place to new column; save recode formula to auto-update column when new observations are added; group similar values to same recoded value; recode to value labels to simplify graphs
- Subset rows from graph to new unlinked data table; use data view to subset rows linked to data table; exclude data from report using local data filter; label individual rows for displaying in all graphs
Note: Q&A included at times 10:52, 34:35 and 42:21.
In this short video, Alisa Hunt-Lowery shows how to compare data tables using the JMP 16 enhanced interface:
Resources
- Accessing Databases using Query Builder (View Accessing Databases video Part 2)
Thank you @alisa_h_lowery for this instructive video!
I particularly liked your demonstration of the recode to value labels feature:
I find this much easier than using the old dialogue entry fields in the Col properties > Value labels option since this way each value label has to be added one at a time, whereas this newer way, it can all be done at once.
