Thread
:
Random numbers but with a bias
View Single Post
#
4
Posted to microsoft.public.excel.misc
nurrrthk
external usenet poster
Posts: 5
Random numbers but with a bias
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
Reply With Quote
nurrrthk
View Public Profile
Find all posts by nurrrthk