Make a New Formula Column | JMP 13.2

JMP Support 800.450.0135 (US)

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

Using JMP • Enter and Edit Data • Restructure Data • Make a New Formula Column

•

Make a New Formula Column

To perform further analyses on your data, use the New Formula Column menu options from your existing data table. Formula columns use formulas or calculations to define column values.

Right‐click a column heading in your data table and select New Formula Column. Choose from Transform, Character, Combine, Aggregate, Distributional, Date Time, or Row to calculate column values. A new formula column is added to the data table. See Transform Columns for a description of these options.

Note: The same options exist in both the New Formula Column menu, and the right-click column menu in the launch window. However, performing these tasks in a launch window results in a temporary column, and New Formula Column adds a new column to the original data table.

Right-click options depend on the selected column’s data type and the number of columns selected. If the selected column is a Character column, Character and Row options appear. See Character Menu and Row Menu for more information.

•

Help created on 9/19/2017