The following example uses the Big Class.jmp sample data table to walk you through using the basic features of the Formula Editor. You can find Big Class.jmp in the sample data folder, which was installed when you installed JMP.
Big Class.jmp has a column called weight. Suppose you want a new column that computes standardized weight values.
1.
Select Help > Sample Data Library and open Big Class.jmp.
2.
Select Cols > New Columns.
3.
Type the new name, standard weight, in the box beside Column Name.
4.
Select Formula from the Column Properties menu.
When you create a formula and Show Boxing is checked, the selected portion of the formula is outlined with a thin blue line. See Hide and Show Boxing. All terms within the smallest nesting box relative to the place that you clicked become selected, and the subsequent action applies to those combined elements.
3.
Click weight again.
5.
Select Col Mean from the Statistical list.
8.
Click weight again from the column selector list.
9.
Select Col Std Dev from the Statistical list.
Figure 6.19 shows the completed formula.
Figure 6.19 Building a Formula
In the data table, the new Standard Weight column fills with values. When a weight value changes, the calculated Standard Weight value automatically recalculates.

Help created on 7/12/2018