Yes, though I think you probably intended your STDEV formulae to refer to
rows 3:38, not 4:38?

And of course if you change B3:B38 from =RAND() to the previously suggested
=NORMINV(RAND(), 6, 10) then you can see the difference between the original
"random sample from a distribution" approach and the revised version.
--
David Biddulph

"Bernd P" wrote in message
ps.com...
Put into A1:C3:
Mean =AVERAGE(B3:B38) =AVERAGE(C3:C38)
STDEV =STDEV(B4:B38) =STDEV(C4:C38)
Data =RAND() =6+(B3-$B$1)*10/$B$2

Then copy B3:C3 down to B38:C38.

In column C you will have your 36 random numbers which show exactly a
mean of 6 and a stdev of 10.

Regards,
Bernd