falojar.blogg.se

Matrix.xla excel 2016 download
Matrix.xla excel 2016 download







(Default lower and upper bounds are 0 and 1.) When the first parameter is a RAND, BETINV yields a bounded random variable. BINOMINV(probability, n, p) returns inverse cumulative values for a binomial random variable.When the first parameter is a RAND, BINOMINV yields a bounded integer random variable between 0 and n, with mean n*p. DISCRINV(randprob, values, probabilities) returns inverse cumulative values for a discrete 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. EXPOINV(probability, mean) returns inverse cumulative values for an exponential random variable.When the first parameter is a RAND, EXPOINV yields a nonnegative random variable (often used for random waiting times).

matrix.xla excel 2016 download

  • 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, GAMINV yields a nonnegative 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.
  • matrix.xla excel 2016 download

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









    Matrix.xla excel 2016 download