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 accurate 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 in to the pdf file presented here:

pdf_logo02
sbRandGeneral_01_Screen

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.

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

sbRandGeneral_01_Code
sbRandGeneral_02_Code