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). 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.A generalized-lognormal random variable is a constant plus or minus a lognormal random variable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |