Formula Editor | JMP 12

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • 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

Order Expressions in Formulas

Use Formula Editor Options

Calculate Derivatives

Simplify Complex Formulas

Evaluate Formulas

View a Formula’s Values from the Formula Editor

View a Formula in JSL

Correct Mistakes

Select Expressions

Delete Functions

Cut, Copy, and Paste

Customize Formulas

Change the Font Size

Hide and Show Boxing

Change the Orientation of a Formula

Open and Close Arguments

Examples and Tutorials

Keyboard Shortcuts

Glossary of Terms