A better chance

Hi

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

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

Can it be done?

Thanks,

Leo.

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

"leo31773" wrote:

>
> Hi
>
> I need to create a long list of 0 and 1 randomly generated, but one
> number should have a slightly better chance of showing up, say like
> 0.5%.
>
> I figured out the =RANDBETWEEN(0,1) but not how to give a better odd
> for one number.
>
> Can it be done?
>
> Thanks,
>
> Leo.
>
>
> --
> leo31773
> ------------------------------------------------------------------------
> leo31773's Profile: http://www.excelforum.com/member.php...o&userid=27179
> View this thread: http://www.excelforum.com/showthread...hreadid=466820
>
>

One way:

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

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

In article <[email protected]>,
leo31773 <[email protected]>
wrote:

> Hi
>
> I need to create a long list of 0 and 1 randomly generated, but one
> number should have a slightly better chance of showing up, say like
> 0.5%.
>
> I figured out the =RANDBETWEEN(0,1) but not how to give a better odd
> for one number.
>
> Can it be done?
>
> Thanks,
>
> Leo.

And of course

=--(RAND()<0.5025)

works just as well without the function call.

In article <[email protected]>,
JE McGimpsey <[email protected]> wrote:

> One way:
>
> =IF(RAND()<0.5025, 1, 0)
>
> should give about 49.75% 0's, 50.25% 1's.

Thanks! I'll try that.