Hi All,

I am trying to figure out a way for Excel to generate a random number
that is based on a KNOWN distribution.

For example, I have downloaded monthly returns for the S&P and
histogramed it out to find the distribution with mean and stddev.

Now I would like Excel to generate a random monthly return based on
the historical distribution. The only way I have down this is to have
a randomly selected row get generated and use that return as my number

Is there a more elegant way?

Thanks in advance!