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 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