Copy a Formula to Columns on the Right

JMP Support 800.450.0135 (US)

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

Using JMP • Formula Editor • Copy a Formula to Columns on the Right

•

Copy a Formula to Columns on the Right

The Standardize Attributes option in the Cols menu provides a way to replicate a column formula while incrementing each column reference in the formula. This option is an alternative to manually creating new column formulas whose columns increment by one in each of the subsequent columns. For example, if column B contains the formula Ax2, then the standardized column C would contain the formula Bx2, and the standardized column D would contain the formula Cx2.

1.

Select Help > Sample Data Library and open Semiconductor Capability.jmp.

2.

Select Cols > New Columns.

3.

Type 3 next to Number of columns to add and click OK.

4.

Select the first new column, select Cols, and then select Formula.

5.

Create the formula NPN1/PNP1 and click OK.

Figure 6.11 Create the Formula NPN1/PNP1

6.

Select the three new columns and then select Cols > Standardize Attributes.

7.

In the Standardize Properties section, select Formula from the list.

8.

Select Substitute Column Reference and leave NPN1 and PNP1 selected.

Figure 6.12 Standardize Properties Options

Note: In this example, we want to change both NPN1 and PNP1. You can deselect the column that you do not want to change in the subsequent formulas.

9.

A formula that is relative to the formula in the first new column is copied to the second and third selected columns.

The formulas in the second and third selected columns increment by one column.

–

Original formula in the first column: NPN1/PNP1

–

Relative formula in the second column: PNP1/PNP2

In the data table, PNP2 comes after PNP1.

–

Relative formula in the third column: PNP2/NPN2

In the data table, NPN2 comes after PNP2.

Figure 6.13 Resulting Data Table

Note: Some columns in Semiconductor Capability.jmp were deleted to show the new columns X, Y, and Z in Figure 6.13.

See Example of Standardizing a Formula in The Column Info Window for another example.

•

Help created on 7/12/2018