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.
If you want to create a step-wise cumulative linear random number distribution then you can use my user defined function sbRandCumulative.
If you are interested in how I came up with the algorithm, look at the page for my UDF sbRandGeneral, please.
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.
[Sulprobil] [Get it done] [Organisation] [IT] [Controlling] [Human Resources] [Family] [Contact] [Download] [Disclaimer]