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

 

"Probable impossibilities are to be preferred to improbable possibilities." [Aristotle]

Here I present some functions for random number generation.

I assume that Excel's © internal rand() function generates random numbers of sufficient quality (that is: randomness). You may want to substitute it. In this case search the web for alternatives.

Random functions:

Examples of simple distribution functions are presented here.

Cholesky - Generate correlated random numbers with a Cholesky decomposition.

sbGrowthSeries - Generate a random data series with a given compoundgrowth rate and a given maximum
                     relative change rate per step

PF_Allocate - Generate portfolio assets with a given sum and lower boundaries and upper boundaries

Random_Pick - Pick n random cells from selection

RndDecPlace - Create a random number between two borders with a given number of decimal places.

sbRandInt - Generate n non-repeating (or repeating up to r times) random integers between two given
                 borders

sbRandSum1 - Generate n random numbers which sum up to 1

UniqRandInt - Generate n unique random integer numbers in a given range 1..m (m >= n)
                   [provided just for historical purposes - I suggest to use sbRandInt now]