Solved

# Creating a random number generator with a defined start/end range and standard deviation

Posted on 2013-01-25

Hi,

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