Ask Your Question
0

Calc: using Randbetween

asked 2016-05-27 17:54:05 +0100

msteph gravatar image

I want random numbers between minus 3 and plus 3. Is there any difference between:

=RANDBETWEEN(-3,3)

or

=RANDBETWEEN(0,6)-3

I've been using the latter but it seems like I'm getting more positives than negatives, in fact twice as many positives. That could be just chance but I've run 720 trials so the sample seems large enough.

Thanks for any help.

Mike S.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-05-28 00:00:14 +0100

m.a.riosv gravatar image

I can't find the differences that you mention, find attached a test file RandbetweenTest.ods, use hard recalc [Shit+Ctrl+F9] to recalculate updating Randbetween() values.

edit flag offensive delete link more

Comments

Thank you m.a.riosv, for taking the time to construct the spreadsheet comparing the two formulas. It's clear from the results that the two are identical in function and that my experience is just an outlier. Even now, running more trials, I'm seeing results more in line with what would be predicted.

Much appreciated!

Mike S.

msteph gravatar imagemsteph ( 2016-05-29 04:35:40 +0100 )edit

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2016-05-29 12:27:59 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-05-27 17:54:05 +0100

Seen: 959 times

Last updated: May 28 '16