You are previewing Using JMP 10.
O'Reilly logo
Using JMP 10

Book Description

Using JMP for JMP 10 includes instructions for performing common tasks such as manipulating files, entering and managing data, transforming data table columns, exporting graphical reports, saving analyses as scripts, integrating with SAS, and more. This book also includes a reference for functions available in the Formula Editor.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Contents
  5. Learn About JMP
    1. Book Conventions
    2. JMP Documentation
      1. JMP Documentation Suite
      2. JMP Help
      3. JMP Books by Users
      4. JMPer Cable
    3. Additional Resources for Learning JMP
      1. Tutorials
      2. The JMP Starter Window
      3. Sample Data Tables
      4. Learn about Statistical and JSL Terms
      5. Learn JMP Tips and Tricks
      6. Tooltips
      7. Access Resources on the Web
  6. Get Started
    1. JMP Home Window
      1. JMP Home Window Buttons
      2. Recent Files
      3. Window List
      4. Projects
      5. Rearrange Panels in the Home Window
    2. JMP Starter Window
    3. JMP Personalization Window
    4. Data Tables
      1. Data Table Panels
      2. Data Grid
    5. Open Data Files
    6. Display and Arrange Open Windows
      1. Using the Reveal Feature
    7. Anatomy of a JMP Session
  7. Import Your Data
    1. About Importing Data to JMP
    2. Import Text Files
      1. Text Import Preview Options
      2. Open a Text File in a Text Editing Window
      3. Import Text from the Script Window
    3. Import Remote Files and Web Pages
    4. Import SPSS Files
    5. Import Excel Files
    6. Import Data from SAS
      1. Import SAS Data Sets
      2. Create SAS Transport Files in SAS
      3. Connect to SAS
      4. Open SAS Data Sets through a SAS Server
      5. Run Stored Processes
      6. Submit SAS Code
      7. Generate ODS Results
      8. Retrieve Generated SAS Data Sets
    7. Import Data from R
    8. Import Data Using the Excel Add-In
      1. Transfer Excel Data to a JMP Data Table
      2. Uninstall the Excel Add-In
      3. Uninstall Previous Versions of the Excel Add-In
      4. About the JMP Add-In for Excel
    9. Import Data from a Database
      1. Open Data from a Database
      2. Retrieve Data Using SQL Statements
      3. Structured Query Language (SQL): A Reference
      4. Use the WHERE Clause Editor
    10. Read in Real-Time Data
    11. Create New Data Tables
  8. Enter and Edit Data
    1. Enter Data
      1. Add Rows
      2. Add Columns
      3. Fill Columns with Sequential Data
      4. Enter Cell Formulas
    2. Select Rows
    3. Select Columns
    4. Select Cells
    5. Edit Data
      1. Delete Rows and Columns
      2. Edit or Delete Cells
      3. Edit Column Names
      4. Recode Data
      5. View Patterns of Missing Data
      6. Find and Replace Cell Values
      7. Reorder Columns
      8. Group Columns
      9. Use the Row Editor
      10. Context Menus for Rows and Columns
    6. Edit Data Tables
      1. Change Table Names
      2. Lock Tables
      3. Use Table Variables
      4. Create and Save Scripts
      5. Compare Data Tables
    7. Assign Characteristics to Rows and Columns
      1. Exclude Rows and Columns
      2. Hide Rows and Columns
      3. Label Rows and Columns
      4. Assign Colors or Markers to Rows
      5. Create Color Themes
      6. Delete All Row Characteristics
      7. Lock Columns in Place
  9. Set Column Properties
    1. The Column Info Window
      1. About Data Types and Modeling Types
      2. The Short-Integer Format
      3. Numeric Formats
      4. Row State Columns
      5. Fill in Initial Data Values
    2. Assign Column Properties
      1. Formula
      2. Notes
      3. Range Check
      4. List Check
      5. Missing Value Codes
      6. Value Labels
      7. Value Ordering
      8. Value Colors
      9. Color Gradient
      10. Axis
      11. Coding
      12. Row Order Levels
      13. Spec, Control, and Response Limits
      14. Sigma
      15. Units
      16. Distribution
      17. Time Frequency
      18. Map Role
      19. Create Your Own Column Property
    3. Standardize Attributes and Properties across Columns
    4. Assign a Preselected Analysis Role
    5. Compress Selected Columns
  10. Reshape Data
    1. Create a Subset Data Table
      1. Stratified Subsets
      2. Create a Subset Data Table from a Report
    2. Sort Data Tables
    3. Stack Columns
      1. Example of Stacking into One Column
      2. Example of Stacking into More than One Column
    4. Split Columns
      1. Examples of Splitting Columns
    5. Transpose Rows and Columns
      1. Examples of Transposing Rows and Columns
    6. Concatenate Data Tables
      1. Example of Concatenating Data Tables
      2. Example of Concatenating Data Tables and Table Variables
    7. Join Data Tables
      1. Examples of Joining Data Tables
    8. Update Data Tables
      1. Example of Updating a Data Table
  11. Formula Editor
    1. Create a Formula
    2. Reference Columns and Table Variables
    3. Use Local Variables
    4. Insert Constants
    5. Add Operators
    6. Use Functions
    7. Order Expressions in Formulas
    8. Use Formula Editor Options
      1. Calculate Derivatives
      2. Simplify Complex Formulas
      3. Evaluate Formulas
      4. Ignore Errors
      5. View a Formula’s Values from the Formula Editor
      6. View a Formula in JSL
    9. Edit Formulas
      1. Correct Mistakes
      2. Select Expressions
      3. Delete Functions
      4. Cut, Copy, and Paste
      5. Click and Drag
    10. Customize Formulas
      1. Change the Font Size
      2. Hide and Show Boxing
      3. Change a Formula’s Orientation
      4. Open and Close Arguments
    11. Examples and Tutorials
    12. Keyboard Shortcuts
    13. Glossary of Terms
  12. Summarize Data
    1. Summarize Columns
      1. Create a Summary Table
      2. Add a Statistics Column to an Existing Summary Table
      3. Explanation of Statistics
      4. Example of Creating a Summary Table
    2. Tabulate Data
      1. Create a Table in Tabulate
      2. Elements of a Table in Tabulate
      3. Click and Drag Items
      4. Insert a Grouping Column
      5. Insert an Analysis Column
      6. Use the Dialog
      7. Edit Tables in Tabulate
      8. Additional Tabulate Options
      9. Example of Tabulating Data
  13. JMP Platforms
    1. Launch Windows
    2. Navigating Reports
      1. Use the Hand Tool
      2. Access Report Display Options
      3. Show and Hide Parts of a Report
      4. Combine Several Reports
      5. Rename a Title
      6. Increase Font Sizes
    3. How to Access Analysis Options
      1. Script Menus
    4. The Data Filter
    5. Format Report Tables
    6. Select Points in Plots
    7. Use Markers
    8. Alter Plot and Chart Appearances
      1. Resize Plots and Graphs
      2. Change Line Widths
      3. Change the Background Color in a Graph
      4. Change the Color of Histogram Bars
      5. Display Coordinates and Temporary Reference Lines
      6. Scroll and Scale Axes
      7. Customize Axes and Axis Labels
      8. Change the Order of Values
      9. Customize Tick Marks and Tick Mark Labels
      10. Add Reference Lines
      11. Add Geographical Images and Boundaries
      12. Drag and Drop an Image into a Graph
      13. Extract Data from an Image
    9. Add Graphics Elements to a Report
      1. Customize Graphical Elements
  14. Save and Share Data
    1. Save and Share Data Tables
      1. Save a Data Table to Open in JMP 5.1.2 or Earlier
      2. Save as a Text File
      3. Save as a SAS Transport File
      4. Save as a SAS Data Set
      5. Save as a Microsoft Excel File
      6. Save Data Tables to a Database
      7. E-mail a Data Table
    2. Save and Share Reports
      1. E-mail a Report
      2. Save as Flash
      3. Setting the DPI
    3. Save Your Analysis as a Script
    4. Print Reports
    5. Copy and Paste Reports
    6. JMP Journals
      1. Create a New Journal
      2. Prevent Modifications
      3. Append Reports to a Journal
      4. Add and Edit Outline Levels
      5. Control the Display of Outline Levels
      6. Add a Graph or Graphic
      7. Customize Journal Items
      8. Save the Journal in Another Format
      9. Print a Journal
      10. Delete Items from a Journal
      11. Example of Making a Journal for a Presentation
    7. Save JMP Sessions
    8. JMP Projects (Windows Only)
    9. Save a Log Window
  15. Personalize JMP
    1. Personalize Toolbars and Menus on Windows
      1. Create Toolbars
      2. Create Main Menus
      3. Create Menu Items and Toolbar Buttons
      4. Rearrange Toolbars
      5. Copy and Paste Menus, Menu Items, Toolbars, and Buttons
      6. Rearrange Custom Menus, Menu Items, and Buttons
      7. Delete Custom Items
      8. Show and Hide Items
      9. Import Customizations
      10. Remove Customizations
    2. Personalize Toolbars on Macintosh
    3. JMP Add-Ins
      1. Manage JMP Add-Ins
  16. JMP Preferences
    1. Overview
    2. General
    3. Reports
    4. Graphs
    5. Tables
    6. Platforms
      1. Graph Builder Preferences
    7. Text Data Files
    8. Windows Specific
    9. Mac OS Settings
    10. Fonts
    11. Communications
    12. File Locations
    13. Script Editor
    14. SAS Integration
    15. JMP Updates
    16. JSL Debugger
    17. Menu Preferences
    18. Scripting-Only Preferences
  17. Formula Functions Reference
    1. Row Functions
    2. Numeric Functions
    3. Transcendental Functions
    4. Trigonometric Functions
    5. Character Functions
    6. Character Pattern Functions
    7. Comparison Functions
    8. Conditional Functions
    9. Probability Functions
    10. Discrete Probability Functions
    11. Statistical Functions
    12. Random Functions
    13. Date Time Functions
    14. Row State Functions
    15. Assignment Functions
    16. Parametric Model Functions
    17. Finance Functions
  18. Index