Use Functions in a Formula | 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 • Formula Editor • Use Functions in a Formula

•

Use Functions in a Formula

Tip: Within JMP, tooltips are available to help you understand what each function does.

You can add many types of functions to a formula. All of these functions are organized in the Functions list. The browser groups collections of functions in lists organized by topic. The list contains functions that are commonly used in formulas. Use the Functions list to specify the type of calculation that you want to perform on the elements in a formula.

To create a formula that contains a function, follow these steps:

1.

Open the Formula Editor by right-clicking a column name in the data table and selecting Formula.

2.

Select an expression in the formula editing area by clicking it. (It is selected when there is a blue outline around it.) The function performs its action on the area that is highlighted.

3.

In the Functions list, select a group of functions to view. See Groups of Functions for details.

The functions that belong to that group are then displayed in the list below the menu. The function groups are briefly described in the following list.

4.

Click any function in the Functions list to apply it to the selected item. When you click some items, you reveal a submenu from which you should make a selection.

5.

Continue to build the formula by highlighting terms and clicking items in the formula element browser, keypad, or Functions list.

Notes:

•

Pressing Alt and selecting the function replaces the selected function in a formula with the function that you select from the Functions list or the button that you select from the keypad.

•

Pressing Alt (Option on Macintosh) and clicking a column or other element replaces the item even if it is non-empty.

•

Most functions give hints about appropriate arguments through gray words inserted in the boxes in the formula editing area. Functions also show a small caret in the argument area if additional arguments can be added.

Groups of Functions
Group	Functions Included
Row	Displays a list of functions that contains miscellaneous functions such as Lag, Dif, Subscript, Row, and NRow. See Row Functions in Formula Functions Reference.
Numeric	Displays a list of functions that are terms commonly used in formulas. See Numeric Functions in Formula Functions Reference.
Transcendental	Displays a list of functions that are functions such as natural log, common log, exponential, root, factorial, combinatorial, beta, and gamma. See Transcendental Functions in Formula Functions Reference.
Trigonometric	Displays a list of functions that are the standard trigonometric functions: sine, cosine, tangent, inverse functions, and hyperbolic functions. See Trigonometric Functions in Formula Functions Reference.
Character	Displays a list of functions that operate on character arguments such as trimming, finding the length of a string, converting between numbers and characters. See Character Functions in Formula Functions Reference.
Comparison	Displays a list of functions that are the standard logical comparisons such as less than, less than or equal to, not equal to, and so on. See Comparison Functions in Formula Functions Reference.
Conditional	Displays a list of functions that are programming-like functions, such as If, Match, and Choose. See Conditional Functions in Formula Functions Reference.
Probability	Displays a list of functions that compute probabilities and quantiles for standard statistical distributions, such as normal, Student’s t, Chi-squared, and F-distributions. See Probability Functions in Formula Functions Reference.
Discrete Probability	Displays a list of functions that compute discrete probabilities, such as Poisson, Gamma Poisson, and Hypergeometric. See Discrete Probability Functions in Formula Functions Reference.
Statistical	Displays a list of functions that calculate standard statistical quantities such as the mean or standard deviation. See Statistical Functions in Formula Functions Reference.
Random	Displays a list of functions that generate random numbers based on predefined distributions such as the uniform, normal, Cauchy, and so on. There is also a function to randomize the order of table rows. See Random Functions in Formula Functions Reference.
Date Time	Displays a list of functions that require arguments with the date data type, which is interpreted as the number of seconds since January 1, 1904. Date Time functions return values such as day, week, or month of the year. They can also compute dates and can find data intervals. See Date Time Functions in Formula Functions Reference.
Row State	Displays a list of functions that assign or detect row state status of color, marker, label, hidden, excluded, or selected. See Row State Functions in Formula Functions Reference.
Assignment	Displays a list of functions that place the value on the right side of the assignment operator into the variable on the left side of the operator. See Assignment Functions in Formula Functions Reference.
Parametric Model	Lets you construct a Linear, Interactions, or Full Quadratic model for columns that you choose. After choosing the type of model, a window appears that lets you select the variables from which to construct the model. Hold the Ctrl key and click to select more than one. See Parametric Model Functions in Formula Functions Reference.
Finance	Lets you create formulas to calculate principal payments, interest rate, rate of return, and so on. See Finance Functions in Formula Functions Reference.

•

Help created on 9/19/2017