Random number - multiple iterations

[SvenB]

Hello. I need your advice related to the following matter. I want to generate a random number for multiple times say 100, take the average of all 100 iterations, and put it into a particular cell.
I am currently using this simple code for generating a random number.

Sub RandomNo()


Dim rng As Range


Set rng = Range("B8")
rng.Value = Rnd() * ((-1) ^ Int(Rnd() * 10)) * 0.05


End Sub

How could I do that? Thank you.

 

[Gerald Higgins]

Hi, there are probably lots of ways of doing this, but one way (maybe not the best way) would be to write a random value into 100 cells, not just one, and then have a simple formula that calculates the average of those 100 cells.
This has the advantage in that if the result is surprising, you can audit the individual values, to check.

Another thought, I'm not a statistician but if the Rnd() function is genuinely random, then presumably as the number of iterations increases, the average result will probably trend towards 0.5.