Creating a random number generator with a defined start/end range and standard deviation
Posted on 2013-01-25
I have a sheet that creates 5 cols by 50 rows (250 numbers) using randbetween of two defined values, usually between 5 and 30. These individual rows are then averaged (5 numbers averaged to generate 1) so in total 50 numbers.
These values are then used to create a normal distribution histogram.
However, I would like to define a number in row 1 of each of the 5 columns which will act as the standard deviation expected. So once the figures are created and the average of the 5 cols is created, the overall standard deviation of the 50 figures is equal to that defined.
How could I do this?
My initial sheet attached