Example of Standardizing a Formula

If you have applied a formula to a column, and you want to apply that same formula to additional columns in the data table, use the Substitute Column Reference option.

Note: This option is dependent upon the location of the column that is referenced in the original formula. For example, if your original formula is based on the previous column, then any other formulas applied to additional columns are based on their previous columns.

For example, the Blood Pressure.jmp sample data table contains blood pressure measurements taken on five subjects three times each day, over a period of three days. You want to find the log of each blood pressure (BP) column.

Select Help > Sample Data Library and open Blood Pressure.jmp.

Create nine new columns, one for each existing BP column.

Select Cols > New Columns.

Add nine columns.

Click OK.

Apply your original formula as follows:

Right-click Column 1 and select Formula.

Select BP 8M.

Select Transcendental > Log.

Click OK.

Column 1 now contains the log of the BP 8M column. You want the rest of the empty columns to contain the log of the remainder of the BP columns.

In the data table, select all of the new columns that you created, including the one with the original formula (columns 1-9).

10.

Select Cols > Standardize Attributes.

11.

In the Standardize Properties panel, click Column Properties and select Formula.

12.

Select the check box next to Substitute Column Reference.

13.

Leave BP 8M selected.

You want that column reference to be substituted in the subsequent column formulas.

14.

Click OK.

Now all of the new columns are populated with the log of the BP columns, in the order in which they appear. Column 1 contains the log for BP 8M, Column 2 contains the log for BP 12M, and so on.

See Copy a Formula to Columns on the Right in Formula Editor for more information.