Hey, David! Good to see you again! How are you?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"David J. Braden" wrote in message
...
Jerry,
It's worse yet with ATP, because it uses its own rng. It is SO bad that I
would like to know the algorithm. I think I posted some VBA code a while
back to show how lousy it is; you can use it to generate 10000 values;
then sort them and do a frequency count. You'll find some mighty strange
stuff; quite a few numbers get repeated, and some values get repeated 7 or
8 times, depending on the seed. Suggest to the good folks at MS to
eviscerate the thing, please.

Regards,
Dave B

"Jerry W. Lewis" wrote in message
...
And similarly, you can use other INV functions with RAND() generate
random numbers that follow other distributions. Unfortunately, Pre-2003
INV functions are too crude to do this well (which also means that ATP
does it poorly).

Jerry

barrfly wrote:

unfortunately no. The rand() function only delivers a random number
that is uniformly distributed between 0 and 1. You can use the
norminv(rand()) function combination to create a normally distributed
random number with a mean and stdev of your choosing.