|DataLab is a compact statistics package aimed at exploratory data analysis. Please visit the DataLab Web site for more information....|
|Home Features of DataLab Mathematical/Statistical Analysis Transformation Math Formulas|
|See also: Math Formulas - Constants, Variables, Operators, Scaling, Guided Tour: Transforming Data, DataLab Scripts, List of Script Commands
Clicking the command Math/Apply Math Formula... (or the toolbar button ) allows almost arbitrary mathematical transformations to be entered. The intended transformation can be input either by typing a mathematical equation, or by retrieving a previously entered formula from the formula select box.
After starting the command, a window is opened which shows the available operators and operands in its upper part and allows the user to enter and edit a mathematical formula in its lower part. The formula which has been entered most recently is shown as the default formula. This formula can be edited or deleted and replaced by a completely different one.
When the formula is ready for execution, the user has to click Execute. Thereafter the formula is applied to the data matrix. In case of a syntax error, the formula is not executed at all and the data remain unchanged. If the result of a formula is not defined or infinite, the value is replaced by the place holder for indefinite values (see command Setup/Preferences/Indef.Values).
The transformation should be written in standard notation (very much the same as in common programming languages), having the result at the left side and the arguments at the right side of the equation. Lower case and upper case letters may be mixed arbitrarily and any number of spaces may be inserted into the equation. The assignment can be performed by the sign '=' or alternatively by ':='.