Complete the following steps to create a formula.
The following examples demonstrate a few uses of the Calculator.
To store a value in a column or a constant, enter the storage column or the storage constant and the value. For example, if you enter K1 in Store result in variable and 5 in Expression, then Minitab sets K1=5.
When you enter a text value, enclose it in double quotation marks, for example, "green".
Formulas can consist of functions, arithmetic operations, comparison operations, logical operations, and column operations. Formulas can include columns, stored constants, numbers, and text, but not matrices. Follow these guidelines when you build formulas.
If the comparison is true, the result is set to 1. If it is false, the result is set to 0.
You can use either the symbols (& | ~) or the words (And, Or, Not) in an expression.
If the comparison is true, the result is set to 1. If it is false, the result is set to 0.
Use an asterisk (*) to represent a string of one or more characters. Use a question mark (?) to represent only one character.
To reference a "*" character or a "?" character in a text string, use a tilde (~) before the symbol.
For examples, go to Find function and Search function.
Operations of equal order are performed from left to right.
You can override the default order by using parentheses. Minitab runs expressions within the parentheses first.
Consider the following information about calculator output when you build formulas.
If the last operation that is evaluated in an expression is a numeric operation, such as minus or MEAN, then Minitab stores the result as a number. For example, the result of TODAY() - 30 is a number because the last operation that is evaluated is minus, which is a numeric operation.
If the last operation that is evaluated is a date/time function, such as NOW or WHEN, then Minitab stores the result as a date/time value. For example, the result of DATE(TODAY() - 30) is a date value, because the last operation that is evaluated is DATE, which is a date/time function.
In Minitab, as with most spreadsheet applications, if you operate on a date/time variable with a number, for example, NOW() + 30, Minitab assumes the number is in units of days.