Practice Preparing Your Data for Analysis - Exercises

Use this JMP journal to learn a bit about data prep and to practice preparing your data for analysis.  

  • Bringing Data Together
    • Open Excel file
    • Join Brewery Volume types with JMP Query Builder
    • Update # breweries
  • Reshaping Data
    • New Formula Column (i.e. Age Demographics)
  • Cleaning Data
    • Changing data and modeling types
  • Exercise 2 - Matched JoinExercise 2 - Matched Join 
    • Changing formatting
    • Recode
    • Recode column names
    • Text to Columns / Combine Columns
    • Handle duplicate rows
    • Finding / handling outliers
  • Handle Missing Data
    • Missing Data Pattern (Tables menu)
    • Explore Missing Data (Analyze --> Screening)
    • olumns Viewer (Columns menu)
  • Making New Columns (including formula columns)
  • Conditional statements
  • Name Selection in Column
  • Binning
  • Formula Short Cuts


Exercise 1: Stack Columns
Exercise 2: Matched Join

 

 




 

 

 

 

Article Labels

    There are no labels assigned to this post.

Article Tags