On Sep 13, 2:48 am, Bernd P wrote:
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.

Excellent, with David's corrections! I would use STDEVP() in this
context instead of STDEV(). But no matter, as long as the OP is
consistent in his usage.