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!

 

sbRandGeneral

"It pays to be obvious, especially if you have a reputation for subtlety." [Isaac Asimov]

If you want to create a step-wise linear random number distribution - and you can approximate any distribution with a given accuracy with such one - then you can use my user defined function sbRandGeneral.

If you are interested in how I came up with the algorithm, look into this pdf file, please.

sbRandGeneral_01_Screen

The graphic shows a stratified sample of 10,000 runs.

If you are interested in downloading a
1,092 KB Excel 2010 © sample file which contains the function discussed here, go to my Download page, please.

sbRandGeneral_01_Code
sbRandGeneral_02_Code
sbRandGeneral_03_Code
Sulprobil   Get it done   Contact   Disclaimer   Impressum   Download