beautypg.com

Juniper Systems Allegro DOS Manual User Manual

Page 136

background image

Page 4-70 Windows CE

Tanh(number) Returns the hyperbolic tangent of the number.
Example: Tanh(1) equals 0.76159.

Trunc(number, numDigits) Truncates the number to an integer. The
argument numDigits is the precision of the truncation. The default value
for the numDigits is 0.
Example: Trunc(-7.8) equals -7.

Statistical Functions
Average(number, number, ...) Returns the average of the arguments.
Example: Average(1, 2, 3) equals 2.

Count(number, number, ...) Counts how many numbers are in the list of
arguments.
Example: B1 contains 5, B2 contains 3, Count(B1:B2) equals 2.

CountA(number, number, ...) Counts the number of nonblank values in
the list of arguments.
Example: A1 contains 2, A2 is blank, CountA(A1:A2) equals 1.

CountBlank(range) Counts empty cells in the specified range of cells.

CountIf(range, criteria) Counts the number of cells within the range that
meets the given criteria.
Example: A1 contains 6, A2 contains3, CountIf(A1:A2,”>5") equals 1.

Max(number, number, ...) Returns the maximum value in the list of
arguments.
Example: Max(1, 2, 3) equals 3.

Min(number, number, ...) Returns the minimum value in the list of
arguments.
Example: Min(1, 2, 3) equals 1.

Permut(number, numberChosen) Returns the number of permutations.
Number is the number of objects, numberChosen is the number of
objects in each permutation.
Example: Permut(10, 2) equals 90.

Stdev(number, number, ...) Estimates the standard deviation based on a
sample.

StdevP(number, number, ...) Calculates the standard deviation of the
entire population.

Var(number, number, ...) Estimates the variance based on a sample.

VarP(number, number, ...) Calculates the variance of the entire
population.