Algebraic operators

Absolute value

!ABS takes absolute values - no argument required.
  yield
  ABSyield !=yield !ABS

Arc-sine transformation

!ARCSIN v forms an ArcSin transformation using the sample size specified in the argument which may be a number or another field. In the example, for two existing fields Germ and Total containing counts, we form the ArcSin for their ratio ( ASG ) by copying the Germ field and applying the ArcSin transformation using the Total field as sample size.
  Germ Total
  ASG !=Germ !ARCSIN Total

Sine and Cosine

!COS s and !SIN s takes cosine and sine of the data variable with period s having default 2pi; omit s if data is in radians, set s to 360 if data is in degrees.
  Day
  CosDay !=Day !COS 365

Exponential

!EXP takes antilog base e - no argument required. (Use !^0 to take logarithms (base e).)
  Rate !EXP

Maximum, Minimum and Modulus

!MAX v changes the data value to the value of v if it is less than the value of v. v is either a number or another field.

!MIN v changes the data value to the value of v if it is greater than the value of v. v is either a number or another field.

!MOD v changes the data value to the modulus of v . v is either a number or another field.
  yield !MAX 9
  • Back to transformation summary

    Return to index