Apply function

Menu location: Data_Apply Function.

This applies an algebraic expression to any selection of data. The workbook column(s) you select are given the variable names V1, V2 ... Vn in the order that they are selected from left to right across the workbook. You can then create a new column as a function of those selected. You do this by entering an algebraic expression that can use any of the functions, operators and constants below. For example V1/SQR(V2) would produce a column where each row entry was that of the first selected column divided by the square root of the corresponding row entry in the second selected column. A maximum of 9 variables/columns can be selected.

The same results can be achieved using intrinsic functions within a StatsDirect workbook. Large complex functions may be handled faster by the intrinsic workbook functions of StatsDirect.

Please note that the largest factorial allowed is 170.569398315538748, but you can work with Log factorials via the LOG! function, e.g. LOG!(171).

Calculations give an order of priority to arithmetic operators; this must be considered when entering expressions. For example, the result of the expression "6 - 3/2" is 4.5 and not 1.5 because division takes priority over subtraction.

Priority of arithmetic operators in descending order

1. Exponentiation (^)

2. Negation (-X) (Exception = x^-y; i.e. 4^-2 is 0.0625 and not -16)

3. Multiplication and Division (*, /)

4. Integer Division (\)

5. Addition and Subtraction (+, -)

To convert degrees to radians, multiply degrees by pi/180. To convert radians to degrees, multiply radians by 180/pi.