PSRumbagh -

What kind of distribution does the RAND() function generate, e.g. uniform,
normal, discrete etc? <

Uniform, between zero and one.

Can it's distribution type be changed? <

No.

But, if you have a function for the inverse cumulative for a specific
distribution of interest, you can use RAND() to generate values from that
specific distribution. For example, NORMINV is the inverse cumulative
function for the normal distribution, so you can generate normal random
numbers using =NORMINV(RAND(),mean,stdev).

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"PSRumbagh" wrote in message
...
What kind of distribution does the RAND() function generate, e.g. uniform,
normal, discrete etc? Can it's distribution type be changed? I know how
to
use the "random number generation tool".