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!

 

sbRandCumulative

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.

sbRandCumulative_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.

sbRandCumulative_01_Code
sbRandCumulative_02_Code
sbRandCumulative_03_Code
Sulprobil   Get it done   Contact   Disclaimer   Impressum   Download