Excel Functions for Drawing from Random Distributions =RAND() Uniform(0, 1): =a+RAND()*(b−a) Uniform(a, b): =NORMINV(probability,mean,stdevn) Normal(μ, ): =β*(−LN(1−probability))^(1/α) Weibull(α, β): =IF(probabilityp,1,0) Bernoulli(p): =RANDBETWEEN(lbound,ubound) Discrete Uniform(a, b): Using SIMTOOLS =EXPOINV(probability,mean) Exponential(μ): =LNORMINV(probability,mean,stdevn) Lognormal(μ, ): =GAMINV(probability,mean,stdevn) Gamma(μ, ): =BETA(probability,mean,stdevn,lbound,ubound) Beta(μ, , a, b): (default lower and upper bounds are 0 and 1, respectively) =TRIANINV(prob,lbound,mostlikely,ubound) Triangular(a, b, c): =BINOMINV(probability,#trials,p) Binomial(n, p): =POISINV(probability,mean) Poisson(λ): Discrete Distribution: DISCRINV(probability,values range,probabilities range)
Excel Functions for Drawing from Random Distributions Uniform(0, 1): =RAND() Uniform(a, b): =a+RAND()*(b−a) Normal(μ, ): =NORMINV(probability,mean,stdevn) Weibull(α, β): =β*(−LN(1−probability))^(1/α) Bernoulli(p): =IF(probabilityp,1,0) Discrete Uniform(a, b): =RANDBETWEEN(lbound,ubound) Using SIMTOOLS Exponential(μ): =EXPOINV(probability,mean) Lognormal(μ, ): =LNORMINV(probability,mean,stdevn) Gamma(μ, ): =GAMINV(probability,mean,stdevn) Beta(μ, , a, b): =BETA(probability,mean,stdevn,lbound,ubound) (default lower and upper bounds are 0 and 1, respectively) Triangular(a, b, c): =TRIANINV(prob,lbound,mostlikely,ubound) Binomial(n, p): =BINOMINV(probability,#trials,p) Poisson(λ): =POISINV(probability,mean) Discrete Distribution: DISCRINV(probability,values range,probabilities range)