Formula Editor Adventures
Overview
Each column has access to the Formula Editor. The JMP Formula Editor is a powerful tool for building formulas that calculates values for each cell in a column. The Formula Editor window operates like a pocket calculator with buttons, displays, and an extensive list of easy-to-use features for building formulas.
JMP formulas can be built using other columns in the data table, built-in functions, and constants. Formulas can be simple expressions of numeric, character, or row state constants or can contain complex evaluations based on conditional clauses. Once created, the formula remains with the column until the formula is deleted. It is visible in both the Column Info dialog and in the formula editor itself.
A column whose values are computed using a formula is both linked and locked. It is linked to (or dependent on) all other columns that its formula refers to. Its values are automatically recomputed whenever you edit the values in these columns. It is also locked, so its data values cannot be edited, which would invali­date its formula.
This chapter describes Formula Editor features and gives a variety of examples. See the online Using JMP for a complete list of Formula Editor functions.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset