FILTER FORGE FREE COMPARABLE SOFTWARE PLUS

CORAND(CorrelArray, RandSource), entered as an array formula in a range of cells in a row, returns RANDom values for making random variables that have correlations as in the given CorrelArray.(If W is a Weibull random variable then -LN(W) has this extreme-value distribution.)ДЇunctions for working with correlations among random variables: When the first parameter is a RAND, XTREMINV yields a random variable that may be positive or negative. XTREMINV(probability, mean, stdevn) returns inverse cumulative values for an extreme-value (or Gumbel) random variable, parameterized by its mean and standard deviation.When the first parameter is a RAND, TRIANINV yields a bounded random variable. TRIANINV(probability, lowerbound, mostlikely, upperbound) returns inverse cumulative values for a random variable with a triangular probability density.When the first parameter is a RAND, POISINV yields a nonnegative integer random variable. POISINV(probability, mean) returns inverse cumulative values for a Poisson random variable.When the first parameter is a RAND, LNORMINV yields a nonnegative random variable. LNORMINV(probability, mean, stdevn) returns inverse cumulative values for a lognormal random variable, parameterized by its mean and standard deviation.When the first parameter is a RAND, LAPLAINV yields a Laplace random variable which has more probability in the tails than a Normal with the same parameters.

LAPLAINV(probability, mean, stdevn) returns inverse cumulative values for a Laplace (or double-exponential) random variable, parameterized by its mean and standard deviation.

If optional lowest and highest values are specified (satisfying lowest < quart1 < quart2 < quart3 < highest), then values of the generalized-lognormal random variable are adjusted as necessary to keep GENLINV within these bounds (increasing to the lowest value from below it, decreasing to the highest value from above it). When the first parameter is a RAND(), GENLINV yields a random variable which could be positive or negative, but is bounded on the side of the narrower quartile range.

FILTER FORGE FREE COMPARABLE SOFTWARE PLUS

A generalized-lognormal random variable is a constant plus or minus a lognormal random variable.

GENLINV(probability, quart1, quart2, quart3, lowest, highest) returns inverse cumulative values for a generalized-lognormal random variable that has 25% probability below the quart1 value (the top of the first quartile), 50% probability below quart2, and 75% probability below quart3.

When the first parameter is a RAND, GAMINV yields a nonnegative random variable.

GAMINV(probability, mean, stdevn) returns inverse cumulative values for a gamma random variable, parameterized by its mean and standard deviation.

When the first parameter is a RAND, EXPOINV yields a nonnegative random variable (often used for random waiting times).

EXPOINV(probability, mean) returns inverse cumulative values for an exponential random variable.

When the first parameter is a RAND, DISCRINV returns a discrete random variable with possible values and corresponding probabilities in the given ranges.

DISCRINV(randprob, values, probabilities) returns inverse cumulative values for a discrete random variable.

When the first parameter is a RAND, BINOMINV yields a bounded integer random variable between 0 and n, with mean n*p.

BINOMINV(probability, n, p) returns inverse cumulative values for a binomial random variable.

(Default lower and upper bounds are 0 and 1.) When the first parameter is a RAND, BETINV yields a bounded random variable.

BETINV(probability, mean, stdevn, lowerbound, upperbound) returns inverse cumulative values for a beta random variable, parameterized by its mean and standard deviation.

These functions, along with Excel's NORMINV or NORM.INV function, can be used for generating random variables when the first parameter (called 'probability' or 'randprob') is generated by a RAND() or CORAND function: Inverse cumulative-probability functions.

Filter forge free comparable software