User's Manual

139
CLEM Language Reference
Function
Result
Description
mean_n(LIST)
Number
Returns the mean value from a list of numeric fields or null if
all of the field values are null.
sdev_n(LIST)
Number
Returns the standard deviation from a list of numeric fields
or null if all of t he field values ar e null.
Trigonometr
ic Functions
All of the f unctions in this section either tak e an angle a s an argument or return one as a result. In
both cases, the units of the a ngle (radians or degree s) are controlled by the setting of the relevant
stream option.
Function
Result
Description
arccos(NUM)
Real
Computes the arccosine of the specified ang l e.
arccosh(NUM
)
Real
Computes the hyperbolic arccosine of the specified angle.
arcsin(NUM)
Real
Computes th e arcsine of the specified angle.
arcsinh(NUM)
Real
Computes the hyperboli c arcsine of the specified angle.
arctan(NUM)
Real
Computes the arct angent of the specified angle.
arctan2(NUM_Y,
NUM_X)
Real
Computes the arctangent of NUM_Y / NUM_X and uses the
signs of the two numbers to derive quadrant informat i on. The
result is a real in the range - pi < ANGLE <= pi (radians) – 180 <
ANGLE <= 180 (degrees)
arctanh(NUM)
Real
Computes the hyperbolic arctangent of the specified angle.
cos(NUM)
Real
Computes th e cosine of th e specified angle.
cosh(NUM)
Real
Computes the hyperboli c cosine of the specified angle.
pi
Real
This constant is the best real approximati on to pi.
sin(NUM)
Real
Computes th e sine of the specified angle.
sinh(NUM)
Real
Computes the hyperboli c sine of the specified angle.
tan(NUM)
Real
Computes th e tangent of the specified angle.
tanh(NUM)
Real
Computes the hyperboli c tangent o f the specified angle.
Probability Functions
Probability functions return probabilities based on various distributions, such as the probability
that a value from Student’s t distribution will be less than a spec ific value.
Function
Result
Description
cdf_chisq(NUM, DF)
Real
Returns the probability that a value from the chi-square
distribution with the specified degrees of freedom will
be less than the specified number.
cdf_f(NUM, DF1, DF2)
Real
Returns the probabil i t y that a value from the F
distribution, with degrees of freedom DF1 and DF2,
will be less than the specified number.