Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Community Manager Community Manager

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

Use Videos and Resources to Practice JMP, JMP Pro, JMP Clinical and JMP Genomics.

1-hour live Mastering JMP webinars occur most Fridays from January through October. After each session, we hope you will use the video and resources shared by the presenting JMP Systems Engineers to practice what you saw.

Mastering JMP Videos are available here.