Juniper Systems Allegro CX Manual - Manual (Page 152)

152 Allegro CX Owner’s Manual
Statistical Functions
Avedev(number, number, ...)
Returns the average of the absolute deviations of data points from
their mean.
Average(number, number, ...)
Returns the average of the arguments. Example: Average(1, 2, 3)
equals 2
AverageA(number, number, ...)
Returns the average of all values in a set of values (TRUE is 1, FALSE
and texts are 0).
Betadist(x, alfa, beta, A, B)
Returns the cumulative beta probability density function.
Beatainv(probability, alfa, beta, A, B)
Returns the inverse of the cumulative beta probability density
function.
Binomdist(numOfSuccess, trials, probability, cumulative)
Returns the individual term binomial distribution probability.
Confi dence(alfa, standardDeviation, size)
Returns the confi dence interval for a population mean.
Correl(reference1, reference2)
Returns the correlation coeffi cient between two data sets.
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 specifi ed 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