New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register
for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Practice JMP using these webinar videos and resources. We hold live Mastering JMP Zoom webinars with Q&A most Fridays at 2 pm US Eastern Time. See the list and register. Local-language live Zoom webinars occur in the UK, Western Europe and Asia. See your country jmp.com/mastering site.
Created:
Oct 3, 2023 01:30 PM
| Last Modified: Oct 24, 2023 1:43 PM
Cooper Organizing Tables.zip
Making sense of data, and using it to make decisions, often means accessing it from different places and preparing it for integrated analysis. These two case studies give examples of how to access, massage, graph, analyze, and get reports from data. At the end of the video, see how to use JMP Workflow Builder to repeat data access and reporting when data sources are updated.
See how to:
Import data
Clean and reorganize data
Change column modeling type
Create a formula column to re-organize data to give week year in correct order
Create and re-order states using Value Order
Create regions for states
Graph Data by state on a heat map and explore using data filter
Consolidate, prepare and graph information from multiple sources
Save a JMP workflow to capture your work and update reports
Understand the benefits of organizing your data and saving your cleanup and analysis steps
Q: Is there a visual way of looking at the differences between two tables, for example, when combining them, so we can understand why the number of rows, or column names, are different.
A: One way is to compare tables using Tables > Compare Data Tables.
Q: How would I find specific data like all cell values between 2 and 5?
A: You can select a column and create a Local Data Filter for that column.