Function

Explanation

AVG()

AVG( X1 ;...; Xn ) returns the mean average of X1 through Xn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as rows, columns, cells or areas from the planning table or auxiliary table.

BINOM()

BINOM( n ; k ) calculates the binomial coefficient based on the formula    n! / k!(n-k)! Use this function to determine the total number of possible combinations without repetition of k items in a set of n items. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as rows, columns or cells from the planning table or auxiliary table.

CDFB()

CDFB( X ; n ; p ) returns the probability that the value of a binomial ( n ; p ) distributed variable (see DFB() ) is less than or equal to X; thus, the cumulative probability function of the binomial distribution in a sample of size n where p is the probability that a faulty item is drawn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as rows, columns or cells from the planning table or auxiliary table.

CDFH()

CDFH( X ; n ; M ; N ) returns the probability that the value of a distributed variable (see DFH() ) is less than or equal to X; thus, the cumulative probability function of the hypergeometric distribution, where n is the size of the sample, M is the number of faulty items in the sample, and N is the size of the population. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as rows, columns or cells from the planning table or auxiliary table.

CDFN()

CDFN( X ) returns the probability that the value of a standard normal distributed variable is less than X; thus, the cumulative function of the standard normal distribution. The argument can be either a number that you enter in an Operator/function dialog box, or one of the macro elements row, column or cell from the planning table or auxiliary table.

CDFT()

CDFT( X ; n ) returns the probability that the value of a standard normal distributed variable is less than X; thus, the cumulative density function of Student's t distribution where n is the degrees of freedom (n >= 4). The arguments can be numbers that you enter in Operator/function dialog boxes, as well as rows, columns or cells from the planning table or auxiliary table.

CONSTANT()

CONSTANT( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) returns the constant A of a linear regression line Y = A + BX for a series of observed values. X1 through Xn gives the values of the explanatory variable. Y1 through Yn gives the values of the dependent variable. The number of the values Xi and Yi must be the same. The arguments of the function can be number(s) that you enter in Operator/function dialog boxes as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

COR()

COR( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) returns the correlation coefficient for a two-dimensional random variable for which the values X1 through Xn and Y1 through Yn are observed. This allows you to examine the relationship between two random variables. The number of the values Xi and Yi must be the same. The arguments of the function can be number(s) that you enter in Operator/function dialog boxes as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

COV()

COV( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) returns the covariance for the two data sets X1 through Xn and Y1 through Yn. The arguments of the function can be number(s) that you enter in Operator/function dialog boxes as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

DFB()

DFB( m ; n ; p ) returns the probability of the binomial distribution where m is the number of faulty items in a sample of size n, and p is the probability that a faulty item will be drawn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as rows, columns or cells from the planning table or auxiliary table.

DFH()

DFH( m ; n ; M ; N ) returns the probability of the hypergeometric distribution, that is, the probability of finding m faulty items in a sample of size n where M is the number of faulty items in the population and N is the size of the population. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as rows, columns or cells from the planning table or auxiliary table.

E_STDEV()

E_STDEV( X1 ; ... ; Xn ) returns the estimated value for the standard deviation of a random variable based on the observed values X1 through Xn, i.e. SQRT( E_VAR( X1 ; ... ; Xn ) ). The arguments can be number(s) that that you enter in Operator/function dialog boxes, as well as row(s), column(s), cell(s), or area(s) from the planning table or auxiliary table.

E_VAR()

E_VAR( X1 ; ... ; Xn ) returns the unbiased estimated value for the variance of a random variable based on the observed values X1 through Xn. The arguments can be number(s) that that you enter in Operator/function dialog boxes, as well as row(s), column(s), cell(s), or area(s) from the planning table or auxiliary table. The correction factor n / n-1 is the difference between the functions E_VAR() and VAR().

GAMMA()

GAMMA( X ) returns the gamma function for X. The argument can be either a number that you enter in an Operator/function dialog box, or one of the macro elements cell, row or column from the planning table or the auxiliary table.

MAD()

MAD( X1 ; ... ; Xn ) returns the mean absolute deviation of the values of the values X1 through Xn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

MAPE()

MAPE( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) returns the mean absolute percentage error for the values X1, Y1 through Xn, Yn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

MAX()

MAX( X1 ; ... ; Xn ) returns the greatest value in the range X1 through Xn. The arguments can be either numbers that you enter in Operator/function dialog boxes, or cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

MEAN()

MEAN( X1 ; ... ; Xn ) returns the mean of the values X1 through Xn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

MEDIAN()

MEDIAN( X1 ; ... ; Xn ) returns the median of the values X1 through Xn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

MIN()

MIN( X1 ; ... ; Xn ) returns the smallest value of the values X1 through Xn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

MPE()

MPE( X1 ; ... ; Xn ; Y1 ; ... ; Yn) returns the mean percentage error for the values X1, Y1 through Xn, Yn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

MSE()

MSE( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) returns the mean square error for the values X1, Y1 through Xn, Yn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

PERMUT()

PERMUT( X ; Y ) returns the number of possible permutations when X objects are selected from a set of Y objects where Y > X or Y = X. PERMUT (X ; Y ) = X! /(X - Y)! The arguments can be numbers that you enter in an Operator/function dialog box, as well as cell(s), row(s) or column(s) from the planning table or the auxiliary table.

RMSE()

RMSE( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) returns the root of the mean square error for the values X1, Y1 through Xn, Yn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

STDEV()

STDEV( X1 ; ... ; Xn ) returns the standard deviation of the values X1 through Xn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

TREND()

TREND( X1 ; ... ; Xn ; Y1 ; ... ; Yn ) returns the trend B in a linear regression line Y = A + BX for a series of observed pairs of values. X1 through Xn gives the values of the explanatory variable. Y1 through Yn gives the values of the dependent variable. The number of the values Xi and Yi must be the same. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

VAR()

VAR( X1 ; ... ; Xn ) returns the variance of the values X1 through Xn. The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.

VX()

VX( X1 ; ... ; Xn ) returns the coefficient of variation for the values X1 through Xn, calculated as the standard deviation STDEV( X1 ; ... ; Xn ) divided by the mean MEAN ( X1 ; ... ; Xn ). The arguments can be numbers that you enter in Operator/function dialog boxes, as well as cell(s), row(s), column(s) or area(s) from the planning table or the auxiliary table.