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

--
leo3177
-----------------------------------------------------------------------
leo31773's Profile: http://www.excelforum.com/member.php...fo&userid=2717
View this thread: http://www.excelforum.com/showthread.php?threadid=46682

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 <(E-Mail Removed)>,
leo31773 <(E-Mail Removed)>
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 <jemcgimpsey-(E-Mail Removed)>,
JE McGimpsey <(E-Mail Removed)> 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

--
leo3177
-----------------------------------------------------------------------
leo31773's Profile: http://www.excelforum.com/member.php...fo&userid=2717
View this thread: http://www.excelforum.com/showthread.php?threadid=46682