- Contents
- Learn about JMP
- Get Started
- Introduction to Basic Features
- Anatomy of a JMP Session
- Data Tables
- Platforms
- Manage JMP Files and Open Windows
- JMP Starter Window
- Import Your Data
- Create Data Tables
- About Importing Data to JMP
- Import Microsoft Excel Files
- Import Data from SAS
- Build SQL Queries in Query Builder
- Connect to a SQL Database
- Select Tables from a SQL Database
- Build the SQL Query
- Select Columns from the Database Table
- Maintain Compatibility with JMP 12
- Create a Computed Column
- Group the Common Values
- Import a Sample of the Data
- Select Filters to Import a Subset of the Data
- Import Matching Data from an Existing Data Table
- Write a Custom Expression to Import a Subset of the Data
- Sort the Selected Data
- View the Query Status
- Write a Post-Query Script
- Save and Run the Query
- Open the Selected Data in JMP
- Query Builder Red Triangle Options
- Write SQL Statements in Query Builder
- Import Data from a Database
- Import Text Files
- Import Data from the Internet or a Remote Computer
- Import SPSS Files
- Import Triple-S Survey Data
- Import HDF5 Data
- Import JSON Files
- Import Data from MATLAB
- Import Data from R
- Import Data Using the Excel Add-In
- Create New Data Tables
- Enter and Edit Data
- Perform Basic Data Table Tasks
- Enter Data
- Select Rows
- Select Columns
- Select Cells
- Resize Rows and Columns
- Organize Data
- Delete Rows and Columns
- Rearrange Columns
- Group Columns
- Move Values
- Color Cells
- Edit or Delete Cells
- Edit Column Names
- Hide and Exclude Rows
- Exclude Rows
- Hide Rows
- Exclude Columns
- Hide Columns
- View Patterns of Missing Data
- Find and Replace Cell Values
- Use the Row Editor to Edit Cells in a Row
- Context Menus for Rows and Columns
- Compare Data Tables
- Assign Characteristics to Rows and Columns
- Restructure Data
- Edit the Data Table
- The Column Info Window
- Set Column Attributes and Properties
- About the Column Info Window
- Column Properties
- Basic Column Properties
- Properties That Validate Column Values
- Properties That Attach Information to Column Values
- Properties That Control the Display of Columns
- Properties Used in Modeling and DOE
- Properties Associated with Control Charts and Capability
- Properties That Control How Columns Are Used in Platforms
- Virtual Join Properties
- Additional Properties
- Properties Assigned and Controlled by JMP
- Standardize Attributes and Properties Across Columns
- Assign a Preselected Analysis Role
- Reshape Data
- Formula Editor
- Construct Formulas
- Formula Overview
- Create a Formula
- Refer to Values in Columns and Table Variables
- Use Local Variables
- Insert Constants
- Add Operators
- Use Functions in a Formula
- Order Expressions in Formulas
- Use Formula Editor Options
- Edit Formulas
- Customize Formulas
- Examples and Tutorials
- Keyboard Shortcuts
- Glossary of Terms
- Summarize Data
- JMP Reports
- Navigate and Customize Report Windows
- Navigate Reports
- Red Triangle Options in a Report
- The Data Filter
- Reformat Report Tables
- Select Points in Graphs
- Use Markers
- Change the Appearance of Graphs
- Resize Graphs
- Zoom In and Out
- Pin Hover Labels on a Graph
- Change Line Widths
- Change the Background Color in a Graph
- Change the Color of Histogram Bars
- Display Coordinates and Temporary Reference Lines
- Scroll and Scale Axes
- Customize Axes and Axis Labels in the Axis Settings Window
- Customize Axes and Axis Labels Using the Right-Click Menu
- Change the Order of Values
- Change the Pattern and Format of Selected Objects
- Add a Graph to a Data Table
- Customize Graphical Elements
- Add Images to a Graph or Report
- Add Annotations and Shapes to a Report
- Save and Share Data
- Get Your Data Out of JMP
- Save and Share Data Tables
- Save and Share Reports
- Save Your Analysis as a Script
- Print Reports
- Copy and Paste Reports
- JMP Journals
- Create a New Journal
- Prevent Modifications
- Append Reports to a Journal
- Add and Edit Outline Levels
- Control the Display of Outline Levels
- Add a Graph or Graphic
- Customize Journal Items
- Save the Journal in Another Format
- Print a Journal
- Delete Items from a Journal
- Example of Making a Journal for a Presentation
- Save JMP Sessions
- JMP Projects (Windows Only)
- Save a Log Window
- Extend JMP
- Create Dashboards
- Combine Reports by Creating a Dashboard
- Example of Creating a Dashboard with Two Reports
- Details about Using the Dashboard Builder
- Dashboard Builder Red Triangle Options
- Sample Dashboards
- Edit a Dashboard
- View a Running Dashboard
- Example of Combining Windows to Create a Dashboard
- Example of Adding a Selection Filter to a Dashboard
- Example of Creating a JMP Query Dashboard and Add-In
- Personalize JMP
- Customize Menus and Toolbars
- Personalize Toolbars and Menus on Windows
- Change Customization Sets
- Create Toolbars
- Create Main Menus
- Create Menu Items and Toolbar Buttons
- Rearrange Toolbars
- Copy and Paste Menus, Menu Items, Toolbars, and Buttons
- Rearrange Custom Menus, Menu Items, and Buttons
- Delete Custom Items
- Show and Hide Items
- Import Customizations
- Remove Customizations
- Personalize Toolbars on Macintosh
- Personalize Menu Items on Macintosh
- JMP Preferences
- Formula Functions Reference
- Descriptions of Functions in the Formula Editor
- Row Functions
- Numeric Functions
- Transcendental Functions
- Trigonometric Functions
- Character Functions
- Character Pattern Functions
- Comparison Functions
- Conditional Functions
- Probability Functions
- Discrete Probability Functions
- Statistical Functions
- Random Functions
- Date Time Functions
- Row State Functions
- Assignment Functions
- Parametric Model Functions
- Finance Functions
- JMP Technical Details
- Index
Appendix A
Formula Functions Reference
Descriptions of Functions in the Formula Editor
You can add functions to a formula. All of these functions are organized in the function browser, which groups collections of functions and features in lists organized both alphabetically (Functions (all)) and by topic (Functions (grouped)). This chapter gives a description of functions in the Formula Editor.
More information about functions is available in the following resources:
• The Scripting Index describes all functions and their arguments, demonstrates how the functions work, and links to online Help. In JMP, select Help > Scripting Index to view this interactive resource.
• The JSL Syntax Reference also provides the arguments for JMP functions, not just those available in the Formula Editor. In JMP, select Help > Books > JSL Syntax Reference to open a PDF of the book.
Figure A.1 Functions in the Formula Editor
For instructions on how to create a formula that contains a function, see “Create a Formula” in the “Formula Editor” chapter.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.