Random predictions based on small number result (8 results predicted 125 numbers)

[PhilipJOB]

Hello all
I wanted to find out if anyone has a solution to this conundrum i think based on rand or randbetween,
I am trying to predict or see a random set of numbers 125 based on 8 real result numbers I've got.
so is there a particular formula where I can return 125 numbers based on the 8 real results I have, so if i continue the pattern
of the 8 results where will by result spread go. the prediction will hopefully tell me this pattern will fit between 3.8 and 4.5 limits

the 8 results are:

4.2489
4.1900
4.0532
4.0747
4.3423
4.2599
4.0855
4.0607

 

[Joe4]

Welcome to the Board!

I don't understand. If they TRULY are random, there should be no discernable pattern!
That would violate the basic definition of what "random" means!

 

[MikeVol]

Try:
=ROUND(3.8 + RAND() * (4.5 - 3.8), 2)

 

[PhilipJOB]

Thanks for the reply, yes you are quite right in terms of random, however what i meant was that the results gathered (8) is real data.

 

[PhilipJOB]

Try:
=ROUND(3.8 + RAND() * (4.5 - 3.8), 2)

Thanks MikeVol this did the trick for me. thanks so much.

 

[Joe4]

Thanks for the reply, yes you are quite right in terms of random, however what i meant was that the results gathered (8) is real data.

OK, I guess I wasn't clear on what you were asking.
I am glad that you were able to get the answer that you need.