12.1 Arithmetic Functions
These are the arithmetic functions which are available in TreeAge Pro. You use the function (in the left hand column) and the right hand column will explain the output. Two things to note:
-
Where the argument in the function is listed as "x" this could be a numerical value, or a variable or other input (such as the value from a table) in TreeAge Pro.
| Function | Explanation |
|---|---|
| Abs(x) | Returns the absolute value of x |
| Average(LIST) |
Arithmetic mean of a LIST of values/expressions. |
| Ceiling(x) | Smallest integer greater than or equal x. e.g. Ceiling(4.8) = 5 |
| Exp(x) | Exponential to the power of x. e^x |
| Floor(x) | Greatest integer smaller than x. e.g. Floor(4.8) = 4 |
| GammaFn(x) | (n-1)! for integers less than 19; Stirling's approximation otherwise.
For factorial use GammaFn(x+1) |
| Int(x) | Integer component of x. e.g. Int(4.8) = 4 |
| Ln(x) | Natural (base “e”) logarithm of x |
| Log(x) | Base 10 logarithm of x |
| Max(LIST) | Maximum, or highest value, of a LIST. e.g. Max(1;10;100) = 100 |
| Min(LIST) | Minimum, or lowest value, of a LIST e.g. Min(1;10;100) = 100 |
| Modulo(x: y) | Remainder of x divided by y. e.g. Modulo(7 ; 3) = 1 (because 7/3 = 2 with remainder 1) |
| Prod(LIST) | Product of a LIST. Prod(2;3;4) = 24 ( = 2 x 3 x 4) |
| Root(x; y) | yth root of x |
| Round(x) |
x rounded to the nearest integer |
| Round(x; y) |
x rounded to the number of decimal places specified by y. e.g. Round(4.8765; 2) = 4.88 |
| Sqrt(x) | Square root of x |
| Stdev(LIST) | Standard deviation of a LIST of numbers |
| Sum(LIST) | Sum of a LIST of numbers. e.g. Sum(1; 2; 3) = 6 |
