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.

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

Figure 7.1 The Formula Editor 

Contents

Formula Overview

Create a Formula

Refer to Values in Columns and Table Variables

Use Local Variables

Incorporate Parameters

Insert Constants

Add Operators

Keypad Reference

Use Functions in a Formula

Customize the Functions List

Copy a Formula to Columns on the Right

Order Expressions in Formulas

Build a Formula in Order of Precedence

Use Formula Editor Options

Calculate Derivatives

Simplify Complex Formulas

Evaluate Formulas

Ignore Errors

View a Formula in JSL

Edit Formulas

Correct Mistakes

Select Expressions

Delete Functions

Cut, Copy, and Paste

Click and Drag

Customize Formulas

Hide and Show Boxing

Change the Font Size

Specify the Matrix Size

Change the Orientation of a Formula

Open and Close Arguments

Examples and Tutorials

Use Basic Formula Editor Features

Use Local Variables in a Formula

Use the Munger Function

Use the Match Conditional Function

Use the Delete Expression Button

Keyboard Shortcuts

Glossary of Terms