Statistical Functions

Avg

Avg(Argument1, Argument2 ...)

Arguments - any numeric expressions.

Returns the arithmetic mean of arguments.

DKhi2

DKhi2(Degrees_of_freedom, Argument)

Degrees_of_freedom - number of degrees of freedom.
Argument - value for which it is required to calculate the distribution density.

Density function of gamma distribution of Chi-square.

FKhi2

FKhi2(Degrees_of_freedom, Argument)

Degrees_of_freedom - number of degrees of freedom.
Argument - value for which it is required to calculate the distribution density.

Integral function of gamma distribution equal to (1 - one-sided probability of Chi-square distribution) with n degrees of freedom.

InvKhi2

InvKhi2(Degrees_of_freedom, Probability)

Degrees_of_freedom - number of degrees of freedom.
Probability - the probability connected with gamma distribution.

Returns inverse gamma distribution for the integral function equal to (1 - one-sided probability of Chi-square distribution). If p=FKhi2(N, X), then InvKhi2(N, P) = X

Max

Max(Argument1, Argument2 ...)

Argument1.
Argument2.
... - numeric expressions.

Returns the maximum argument.

Min

Min(Argument1, Argument2 ...)

Argument1.
Argument2.
... - numeric expressions.

Returns the minimum argument.

PKhi2

PKhi2(Degrees_of_freedom, Argument)

Degrees_of_freedom - number of degrees of freedom.
Argument - value for which it is required to calculate the distribution density.

Returns one-sided probability of Chi-square distribution.

StdDev

StdDev(Argument1, Argument2 ...)

Arguments - any numeric expressions.

Returns the standard deviation of arguments.

Sum

Sum(Argument1, Argument2 ...)

Arguments - any numeric expressions.

Returns the sum of arguments.

SumSq

SumSq(Argument1, Argument2 ...)

Arguments - any numeric expressions.

Returns the sum of squared arguments.