Random Within Certain Parameters

[TheDenouement]

I'm trying to create a sequence of random returns that will always have a specific standard deviation.

I've tried "=NORMINV(RAND(),HypotheticalAVG,HypotheticalStDev)"

and it gives pretty decent results, but the Standard Deviation is generally between 0 to 5% off of the desired result.

Is it possible to do this?