Create Formulas in JMP

Formula Editor

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.

For more information about the functions that are available in the Formula Editor, see Reference for JMP Functions in Formulas.

Figure 7.1 The Formula Editor 

Contents

Overview of Formulas in JMP

Create Formulas in JMP

Refer to Data Table Values in Formulas

Use Local Variables in Formulas

Incorporate Parameters in Formulas

Insert Constants in Formulas

Add Operators to JMP Formulas

Keypad Reference for the Formula Editor

Use Functions in Formulas

Find Frequently Used Functions in the Formula Editor

Copy and Replicate Formulas

Order Expressions in Formulas

Build a Formula in Order of Precedence

JMP Formula Editor Options

Calculate Derivatives of JMP Functions

Simplify Complex Formulas

Evaluate Formulas

Ignore Errors in Formulas

View Formulas in JSL

Edit Formulas

Correct Mistakes in Formulas

Select Expressions in Formulas

Delete Functions from Formulas

Cut, Copy, and Paste Formulas

Click and Drag Formulas

Customize Formulas in the JMP Formula Editor

Hide and Show Outlines in Formulas

Change the Font Size in Formulas

Specify the Matrix Size in Formulas

Change the Orientation of a Formula

Open and Close Arguments in Formulas

Examples of Building Formulas in the JMP Formula Editor

Use Basic Features in the JMP Formula Editor

Use Local Variables in Formulas

Use the Munger Function in Formulas

Use the Match Conditional Function in Formulas

Use the Delete Expression Button in Formulas

Keyboard Shortcuts for the JMP Formula Editor

Glossary of Terms for the JMP Formula Editor