I appreciate the help André but my issue is more complex than a random
number between two values. I have a known distribution and would like
to select a value randomly based on the probabilities inherent within
the distribution. Your solution would work great if i had a uniform
distribution betwe
Hello!
If you have your distribution 1 to 1000 for exemple.
So, do =*RANDBETWEEN*(1:1000)
Sorry if I posibly understand wrong
Best Regards
André Luiz D´Avila - Auditor
Moore Stephens Audit
2010/10/27 busboy10
> Hi All,
>
> Trying to do some modeling where I would like Excel to create a random
>
Hi All,
Trying to do some modeling where I would like Excel to create a random
number that is picked from a known distribution.
For example, I downloaded all S&P monthly data. Created a histogram
and know the distribution. Now I would like Excel to randomly
generate a number that follows the di