Scribd
Upload
3 views1 page

SimVoi Random Functions

SimVoi introduces fifteen random number generator functions to Excel, including RANDBINOMIAL, RANDNORMAL, and RANDUNIFORM. These functions can be utilized as inputs in worksheet cells or through the Insert Function option in the Formulas ribbon. The functions cover a variety of statistical distributions and sampling methods.

Uploaded by

Andy Vo
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views1 page

SimVoi Random Functions

SimVoi introduces fifteen random number generator functions to Excel, including RANDBINOMIAL, RANDNORMAL, and RANDUNIFORM. These functions can be utilized as inputs in worksheet cells or through the Insert Function option in the Formulas ribbon. The functions cover a variety of statistical distributions and sampling methods.

Uploaded by

Andy Vo
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SimVoi random functions:

SimVoi adds fifteen random number generator functions to Excel. The fifteen functions are:

 RANDBINOMIAL(trials,probability_s)
 RANDBIVARNORMAL(mean1,stdev1,mean2,stdev2,correl12)
 RANDCUMULATIVE(value_cumulative_table)
 RANDDISCRETE(value_discrete_table)
 RANDEXPONENTIAL(lambda)
 RANDINTEGER(bottom,top)
 RANDLOGNORMAL(Mean,StDev)
 RANDNORMAL(mean,standard_dev)
 RANDPOISSON(mean)
 RANDSAMPLE(population)
 RANDTRIANGULAR(minimum,most_likely,maximum)
 RANDTRUNCBIVARNORMAL(mean1,stdev1,mean2,stdev2,correl12, min1,max1,min2,max2)
 RANDTRUNCLOGNORMAL(Mean,StDev,MinValue,MaxValue))
 RANDTRUNCNORMAL(Mean,StDev,MinValue,MaxValue))
 RANDUNIFORM(minimum,maximum)

You can use these functions as inputs to your model by typing in a worksheet cell. Or, in Windows Excel,
from the Formulas ribbon, choose Insert Function and select the User Defined category.

You might also like