I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

Distributions

Shape your own distributions. Sometimes you will need a normal distribution.

Or you want to have a histogram distribution. You can use my UDFs (user-defined-functions) redw and rww. Similar to redw is my UDF sbRandHistogrm with @RISK©-like parameters. A variance of that function is sbRandomNoRepeatBeforeN which avoids items from being re-drawn too early. An enhanced function of RandHistogrm is the UDF sbExactRandHistogrm which creates exactly the weighted distribution you define over a specified number of runs (draws, rolls).

A Cauchy distribution you can create and use with my UDF sbRandCauchy.

If you need a triangle distribution - which is often used in project management - then try my UDFs sbRandTriang or sbRandTrigen.

A step-wise linear distribution you can generate with sbRandGeneral. If you need it as a cumulative step-wise linear distribution, take sbRandCumulative.

Generally you can create almost any distribution randomly with sbRandCDFInv or sbRandPDF.

An optimized version of a high precision cumulative normal function you can find here. Please note that this was an optimizaton for Excel 2003 ©. From Excel 2007 © on the built-in function is sufficient.

Sulprobil   Get it done   Contact   Disclaimer   Download