This session uses a case study on Medical Treatment Types to show how you examine your data, determine a goal for the analysis, and then prepare the data table to accomplish that goal.
See how to:
- Examine 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
- Join Tables(Tables>Join) and select common Variable ID and an inner join to capture overlapping/common data from both tables
- Apply Modeling Types
- Standardize Attributes (Cols>Standardize Attributes>Column Properties)
- Stack Table (Tables>Stack)
- Concatenate Tables (Tables>Concatenate)
- Use Text to Columns
- Add a Formula Column
- Recode
- Use Value Ordering to define order of variables on all charts
- Hide Rows
- When you Hide rows, they are hidden in all plots, including all open plots
- Hiding rows does not exclude them from calculations and analyses
- Exclude Columns
- Excluded columns are not considered in your analysis
- Excluded columns remain visible in the data grid
Tip: When preparing JMP data (join, concatenate, stack, split, etc.) check Keep Dialog Open. If you want to check your work, check Create Source Column to give info to help you during checking. You can delete the Source Column from final table later.
Check Create Source Column to add column to table; check Keep Dialog Open in case you want to check your work.Check Create Source Column to add column to table; check Keep Dialog Open in case you want to check your work.
Final Prepared Data TableFinal Prepared Data Table
Questions answered by Alisa @alisa_h_lowery and Olivia @O_Lippincott during the live webinar:
Q: If you merge columns with the same name and their contents are different, will the resulting column just have a comma between the two values and treat it as unstructured text?
A: In the example, she created a column ID and joined by the column ID. Basic joining by columns will not merge text from two different tables into the same column.
Resources
