Ladee_bird -

How do you generate 100 random numbers with a normal distribution between
0 and 90? <

The normal distribution is determined by its mean and standard deviation,
not by a range "between 0 and 90."

Theoretically, the possible values from a normal distribution range from
minus infinity to plus infinity. But most values are within three or four
standard deviations from the mean.

One way to get normal distribution values with mean 45 and standard
deviation 5 is to use the worksheet functions =NORMINV(RAND(),45,5). Copy to
100 cells for 100 such random numbers.

And when this is done how do you stop the random numbers changing each
time you do something else? <

Edit Copy. Edit Paste Special Values.

- Mike
www.mikemiddleton.com