Hi,
I need to populate a test table with some random numbers.
Example : 0 or 1.
I fill in the table with "= Randbetween(0;1)" and that does the trick.

But now I need to bias the data so there is - for example -
twice a many chances of 0 than there is of 1.

How would I do that ?

TIA
Nurrrrthk

=IF(RANDBETWEEN(0,2)=2,1,0)

If random number is 1 or 0, returns 0. If 2, returns 1. This gives the value
of 0 a 2-1 advantage.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"nurrrthk" wrote:

Hi,
I need to populate a test table with some random numbers.
Example : 0 or 1.
I fill in the table with "= Randbetween(0;1)" and that does the trick.

But now I need to bias the data so there is - for example -
twice a many chances of 0 than there is of 1.

How would I do that ?

TIA
Nurrrrthk

On Wed, 15 Jul 2009 17:24:37 +0200, "nurrrthk"
wrote:

Hi,
I need to populate a test table with some random numbers.
Example : 0 or 1.
I fill in the table with "= Randbetween(0;1)" and that does the trick.

But now I need to bias the data so there is - for example -
twice a many chances of 0 than there is of 1.

How would I do that ?

TIA
Nurrrrthk


Try this formula:

=INT(RANDBETWEEN(0,2)/2)

Hope this helps / Lars-Åke

Thanks
I'll give that a blast.
nurrrthk


"Luke M" a écrit dans le message de news:
...
=IF(RANDBETWEEN(0,2)=2,1,0)

If random number is 1 or 0, returns 0. If 2, returns 1. This gives the
value
of 0 a 2-1 advantage.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"nurrrthk" wrote:

Hi,
I need to populate a test table with some random numbers.
Example : 0 or 1.
I fill in the table with "= Randbetween(0;1)" and that does the trick.

But now I need to bias the data so there is - for example -
twice a many chances of 0 than there is of 1.

How would I do that ?

TIA
Nurrrrthk

This works too.
Based on your idea but with an implied IF.


=(RANDBETWEEN(0;10) < 4 ) *1

Testing if RANDBETWEEN(0;10) is smaller than 4, returns TRUE or FALSE,
multiplied by 1 gives 1 or 0.

nurrrthk




"Luke M" a écrit dans le message de news:
...
=IF(RANDBETWEEN(0,2)=2,1,0)

If random number is 1 or 0, returns 0. If 2, returns 1. This gives the
value
of 0 a 2-1 advantage.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"nurrrthk" wrote:

Hi,
I need to populate a test table with some random numbers.
Example : 0 or 1.
I fill in the table with "= Randbetween(0;1)" and that does the trick.

But now I need to bias the data so there is - for example -
twice a many chances of 0 than there is of 1.

How would I do that ?

TIA
Nurrrrthk

Nurrrrthk -

=IF(RAND()<(2/3),0,1)

- Mike

http://www.MikeMiddleton.com


"nurrrthk" wrote in message
...
Hi,
I need to populate a test table with some random numbers.
Example : 0 or 1.
I fill in the table with "= Randbetween(0;1)" and that does the trick.

But now I need to bias the data so there is - for example -
twice a many chances of 0 than there is of 1.

How would I do that ?

TIA
Nurrrrthk