Home Page Icon
Home Page
Table of Contents for
Working with Your Data
Close
Working with Your Data
by SAS Institute
Discovering JMP 12
Contents
About This Book
Gallery of JMP Graphs
Learn about JMP
Documentation and Additional Resources
Formatting Conventions
JMP Documentation
JMP Documentation Library
Discovering JMP
Using JMP
Basic Analysis
Essential Graphing
Profilers
Design of Experiments Guide
Fitting Linear Models
Specialized Models
Multivariate Methods
Quality and Process Methods
Reliability and Survival Methods
Consumer Research
Scripting Guide
JSL Syntax Reference
JMP Help
Additional Resources for Learning JMP
Tutorials
Sample Data Tables
Learn about Statistical and JSL Terms
Learn JMP Tips and Tricks
Tooltips
JMP User Community
JMPer Cable
JMP Books by Users
The JMP Starter Window
Introducing JMP
Basic Concepts
Concepts That You Should Know
How Do I Get Started?
Starting JMP
Using Sample Data
Understanding Data Tables
Understanding the JMP Workflow
Step 1: Launching a Platform and Viewing Results
Step 2: Removing the Box Plot
Step 3: Requesting Additional Output
Step 4: Interacting with Platform Results
How is JMP Different from Excel?
Working with Your Data
Preparing Your Data for Graphing and Analyzing
Getting Your Data into JMP
Copying and Pasting Data
Importing Data
Transfer Data from Excel
Set JMP Add In Preferences in Excel
Transfer to JMP
Entering Data
Scenario
Entering Data in a New Data Table
Working with Data Tables
Editing Data
Changing Values
Recoding Values
Creating Patterned Data
Selecting, Deselecting, and Finding Values
Selecting and Deselecting Rows
Selecting and Deselecting Columns
Selecting and Deselecting Cells
Searching for Values
Viewing or Changing Column Information
Calculating Values with Formulas
Scenario
Creating the Formula
Filtering Data
Managing Data
Requesting Summary Statistics
Summary
Tabulate
Creating Subsets
Subsetting with the Subset Command
Subsetting with the Distribution Platform
Joining Data Tables
Sorting Tables
Visualizing Your Data
Graphing Data
Looking at Single Variables
Histograms
Scenario
Creating the Histogram
Interpreting the Histogram
Interacting with the Histogram
Bar Charts
Scenario
Creating the Bar Chart
Interpreting the Bar Charts
Interacting with the Bar Charts
Comparing Multiple Variables
Scatterplots
Scenario
Creating the Scatterplot
Interpreting the Scatterplot
Interacting with the Scatterplot
Scatterplot Matrix
Scenario
Creating the Scatterplot Matrix
Interpreting the Scatterplot Matrix
Interacting with the Scatterplot Matrix
Side-by-Side Box Plots
Scenario
Creating the Side-by-Side Box Plots
Interpreting the Side-by-Side Box Plots
Overlay Plots
Scenario
Creating the Overlay Plot of the Stock’s Price over Time
Interpreting and Interacting with the Overlay Plot
Creating the Overlay Plot of the Stock’s High and Low Prices
Answering the Questions
Variability Chart
Scenario
Creating the Variability Chart
Interpreting the Variability Chart
Graph Builder
Scenario
Creating the Graph
Interpreting the Graph
Bubble Plots
Scenario
Creating the Bubble Plot
Interpreting the Bubble Plot
Interacting with the Bubble Plot
Analyzing Your Data
Distributions, Relationships, and Models
About This Chapter
The Importance of Graphing Your Data
Understanding Modeling Types
Example: Modeling Type Results
Changing the Modeling Type
Analyzing Distributions
Distributions of Continuous Variables
Scenario
Creating the Histogram
Interpreting the Distribution Results
Drawing Conclusions
Testing Conclusions
Interpreting the t-Test
Distributions of Categorical Variables
Scenario
Creating the Distribution
Interpreting the Distribution Results
Interacting with the Distribution Results
Analyzing Relationships
Using Regression with One Predictor
Scenario
Discovering the Relationship
Fitting the Regression Model
Predicting Average Sales
Comparing Averages for One Variable
Scenario
Discovering the Relationship
Interpreting the Results
Performing the T-test
Comparing Proportions
Scenario
Discovering the Relationship
Interpreting the Results
Interpreting the Test
Comparing Averages for Multiple Variables
Scenario
Discovering the Relationship
Quantifying the Relationship
Using Effect Tests
Using Regression with Multiple Predictors
Scenario
Discovering the Relationship
Building the Multiple Regression Model
Using the Actual by Predicted Plot
Interpreting the Parameter Estimates
Using the Prediction Profiler
Conclusion
Saving and Sharing Your Work
Saving and Re-creating Results
Saving Platform Results in Journals
Example: Creating a Journal
Adding Additional Analyses
Creating Projects
Example: Creating a Project
Using Scripts
Example: Saving and Running a Script
About Scripts and JSL
Saving as Interactive HTML
Interactive HTML Contains Data
Example: Create Interactive HTML
Saving as a PowerPoint Presentation
Creating Adobe Flash Versions of the Profiler, Bubble Plot, or Distribution Platforms
Example: Saving an Adobe Flash Version of a Bubble Plot
Special Features
Automatic Updating and Integrating with SAS
Automatically Updating Analyses and Graphs
Example: Using Automatic Recalc
Changing Preferences
Example: Changing Preferences
Integrating JMP and SAS
Example: Creating SAS Code
Example: Submitting SAS Code
Index
Discovering JMP
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
V
W-Z
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Concepts That You Should Know
Next
Next Chapter
Contents
Chapter 3
Working with Your Data
Preparing Your Data for Graphing and Analyzing
Before graphing or analyzing your data, the data has to be in a data table and in the proper format. This chapter shows some basic data management tasks, including the following:
•
Creating new data tables
•
Opening existing data tables
•
Importing data from other applications into JMP
•
Managing your data
Figure 3.1
Example of a Data Table
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset