Notice
You are now leaving support.minitab.com.
Click Continue to proceed to:
To use this function, choose .
Converts negative numbers, zero, and positive numbers to −1, 0, and +1, respectively. You can use the Signs function to code the numbers in a column. This function is useful in macros, formulas, and nonparametric analyses.
SIGN(number)
For number, specify the number or column of numbers you want to convert.
| Calculate expression | Result |
|---|---|
| SIGN(452) | 1 |
| SIGN(-0.66) | −1 |
| SIGN(0) | 0 |
In a different example, you want to code the column Days from expected arrival to early (−1), late (+1), or on time (0). In the Calculator enter the expression: SIGN (C2). Store the results in C3.
| C2 | C3 |
|---|---|
| Days from expected arrival | SIGNS values |
| −2 | −1 |
| −1 | −1 |
| 3 | 1 |
| 0 | 0 |
| 2 | 1 |
| −3 | −1 |
| 0 | 0 |
| −5 | −1 |
| −2 | −1 |
| 1 | 1 |
You are now leaving support.minitab.com.
Click Continue to proceed to: