JMP
^{®}
Statistical Discovery™. From SAS.
US
China
France
DACH
Italy
Japan
UK
JMP Software
JMP
JMP Graph Builder for the iPad
JMP Pro
JMP Clinical
JMP Genomics
JMP and SAS
Try JMP
Buy JMP
Using JMP
Customer Stories
Application Areas
White Papers
Capabilities
Feature Index
Academic
Life Sciences
Government
News and Events
Seminars
Live Webcasts
On-Demand Webcasts
Users Groups
Conferences
JMP in the News
JMP Blog
JMP in Social Media
Resources for Users
JMP User Community
Support
Training
Online Documentation
Learning Library
JMP Blog
File Exchange
Discussion Forum
Users Groups
Newsletters
About Us
About JMP
Careers at SAS
Contact Us
JMP 11 Online Documentation (English)
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 iPad Help
Capabilities Index
Using JMP
• Formula Editor
Previous
•
Next
Formula Editor
Construct Formulas
Use the JMP Formula Editor to create a column whose values are computed by a formula and store that formula as part of a column’s information. Formulas can be simple assignments of numeric, character, or row state constants, or they can contain complex evaluations based on conditional clauses. The Formula Editor window operates like a calculator with buttons, displays, and a list of functions.
The Formula Editor
Formulas are an integral part of a data table for the following reasons:
•
They are stored as part of a column’s information when you save the data table.
•
You can examine or change them at any time by opening the Formula Editor.
•
Their values can be linked to, or dependent on, the values in other columns. Their values are automatically recomputed whenever you edit the values in the columns to which the formula is linked.
•
Their values are locked in the data table so they cannot be manually edited.
This chapter describes the Formula Editor and shows how to build formulas. For details about each function, see the
Formula Functions Reference section
.
Contents
Create a Formula
Reference Columns and Table Variables
Use Local Variables
Insert Constants
Add Operators
Use Functions
Order Expressions in Formulas
Use Formula Editor Options
Calculate Derivatives
Simplify Complex Formulas
Evaluate Formulas
Ignore Errors
View a Formula’s Values from the Formula Editor
View a Formula in JSL
Edit Formulas
Correct Mistakes
Select Expressions
Delete Functions
Cut, Copy, and Paste
Click and Drag
Customize Formulas
Change the Font Size
Hide and Show Boxing
Change a Formula’s Orientation
Open and Close Arguments
Examples and Tutorials
Keyboard Shortcuts
Glossary of Terms