Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 29 May 2016 12:27:59 +0200Calc: using Randbetweenhttps://ask.libreoffice.org/en/question/70576/calc-using-randbetween/ 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.Fri, 27 May 2016 17:54:05 +0200https://ask.libreoffice.org/en/question/70576/calc-using-randbetween/Answer by m.a.riosv for <p>I want random numbers between minus 3 and plus 3. Is there any difference between:</p>
<p>=RANDBETWEEN(-3,3)</p>
<p>or</p>
<p>=RANDBETWEEN(0,6)-3</p>
<p>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.</p>
<p>Thanks for any help.</p>
<p>Mike S.</p>
https://ask.libreoffice.org/en/question/70576/calc-using-randbetween/?answer=70594#post-id-70594I can't find the differences that you mention, find attached a test file [RandbetweenTest.ods](/upfiles/14643863574536822.ods), use hard recalc [Shit+Ctrl+F9] to recalculate updating Randbetween() values.
Sat, 28 May 2016 00:00:14 +0200https://ask.libreoffice.org/en/question/70576/calc-using-randbetween/?answer=70594#post-id-70594Comment by msteph for <p>I can't find the differences that you mention, find attached a test file <a href="/upfiles/14643863574536822.ods">RandbetweenTest.ods</a>, use hard recalc [Shit+Ctrl+F9] to recalculate updating Randbetween() values.</p>
https://ask.libreoffice.org/en/question/70576/calc-using-randbetween/?comment=70638#post-id-70638Thank 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.Sun, 29 May 2016 04:35:40 +0200https://ask.libreoffice.org/en/question/70576/calc-using-randbetween/?comment=70638#post-id-70638Comment by m.a.riosv for <p>I can't find the differences that you mention, find attached a test file <a href="/upfiles/14643863574536822.ods">RandbetweenTest.ods</a>, use hard recalc [Shit+Ctrl+F9] to recalculate updating Randbetween() values.</p>
https://ask.libreoffice.org/en/question/70576/calc-using-randbetween/?comment=70645#post-id-70645If the answer solves your question please tick the ✔.Sun, 29 May 2016 12:27:59 +0200https://ask.libreoffice.org/en/question/70576/calc-using-randbetween/?comment=70645#post-id-70645