468803_en-US

liliconcom

Prepare data for analysis

Learn when and how to reorganize data tables to meet your analysis needs. Understand and use the column and row settings and attributes used by JMP to optimize the information created and displayed in graphical reports. 

 

 

In this webinar you will learn:

 

• Examining data from three different tables:
  • Table 1: Morning results for April and May
  • Table 2: Afternoon results for April and May
  • Table 3: All June results
• Joining tables (Tables>Join)
• Apply modeling types
• Unify Attributes (Columns>Unify Attributes>Column Properties)
• Stack table (Tables>Stack)
• Concatenate tables (Tables>Concatenation)
• Use text in columns
• Adding a formula column
• Recode
• Use value order to determine the order of variables in all charts
• Hide lines
  • When you hide rows, they are hidden in all charts, including all open charts.
  • Hiding rows does not exclude them from calculations and analysis.
• Exclude columns
  • Excluded columns are not included in your analysis.
  • Excluded columns remain visible in the data table.

Data Blending and Cleanup