cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Organizing and Getting the Most from JMP® Tables

Published on ‎11-07-2024 03:29 PM by Community Manager Community Manager | Updated on ‎11-07-2024 05:39 PM

 

 

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:

Compare Data Tabels in JMP 16
Video Player is loading.
Current Time 0:00
Duration 0:00
Loaded: 0%
Stream Type LIVE
Remaining Time 0:00
 
1x
    • Chapters
    • descriptions off, selected
    • captions off, selected
      (view in My Videos)

       

       

      JMP Data Table.JPG

       

       

       

       

       

       

       

       

       

       

       

       

       

      Data Types.JPG

       

       

       

       

       

       

       

       

       

       

      Icons.JPG

       

       

       

       

       

       

       

       

       

      Organizing Recode.JPG

       

       

       

       

       

       

       

       

       

       

      Resources



      Attachments
      0 Kudos
      0 Comments