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