Products | Versions |
---|---|
Spotfire Statistica | 13.0 and above |
How to apply formulas to variables.
Variables in Statistica Spreadsheets can be defined by formulas that support a wide selection of mathematical, logical, and statistical functions.
When entering a long variable name (in the Long name field on the Variable dialog) that starts with an equal sign, Statistica will assume that it is a formula and will verify it for formal correctness. If the formula is formally correct, a choice will be given to recalculate the variable now or later. It's possible to use variable formulas to verify data, transform a variable, recode a variable or create values of the variable based on logical conditions (e.g., =(v0<=100)*1 + (v0>100)*2 will assign a value of 1 to cases number 1 through 100 and 2 to cases above 100). Refer to variables by their names (e.g., Test1, Income) or numbers (e.g., v1, v2, v3, ...); v0 is the case number. A comment may be added to a formula following a semicolon.