Juniper-systems Allegro CX Manual Manual do Utilizador descarregar pdf (Página 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.

Conﬁ dence(alfa, standardDeviation, size)

Returns the conﬁ dence interval for a population mean.

Correl(reference1, reference2)

Returns the correlation coefﬁ 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 speciﬁ 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

1 2 ... 147 148 149 150 151 152 153 154 155 156 157 ... 303 304

Sem comentários

Juniper-systems Allegro CX Manual Manual do Utilizador Página 152