277745_en-US

liliconcom

Preparing Your Data for Analysis

 

See how to:

• Understand how thinking about the questions you want to answer helps determine how to shape your data to prepare it for analysis
• Example 1 aims to understand, for an event held multiple years, if/how attendance varies by day
• Example 2 compares profits from different countries
• Example 3 tries to understand the relationship between the amount of time customers wait at different stores that have different numbers of check-out lines
• Use stack, split and multiple series stack to help prepare data

 

See how to:

• Merge and update data
• Add rows of data from one table to an existing table using Concatenate
• Add columns of data to a table based on common values in one column of cells using Tables Join
• Replace data in cells using Update

 

See how to:

• Summarize and subset
• Grab summary statistics from reports and then make them into a data table
• Make a combined data table for reported statistics of like types
• Summarize by a selected variable at the onset of analysis before any reports are run
• Use Tabulate to make a chart that can be exported using copy and paste or saved to a third-part format such as PowerPoint.
• Create subsets that are unlinked or linked to the original data table
• Save subsets to the data table or to a new table

16-30 minBasicData PreparationMastering JMPVideo