A better chance

[leo31773]

Hi

I need to create a long list of 0 and 1 randomly generated, but on
number should have a slightly better chance of showing up, say lik
0.5%.

I figured out the =RANDBETWEEN(0,1) but not how to give a better od
for one number.

Can it be done?

Thanks,

Leo

 

[Mike]

Maybe an IF statement with if even number then recalc the random?

 

[JE McGimpsey]

One way:

=IF(RAND()<0.5025, 1, 0)

should give about 49.75% 0's, 50.25% 1's.

 

[JE McGimpsey]

And of course

=--(RAND()<0.5025)

works just as well without the function call.

 

[leo31773]

Thanks! I'll try that