Generate column of 1's and 0's randomly

Hi all, I would like to add a column to my spreadsheet with randomly
generated 1's and 0's. I would like to be able to set the probability with
which these are generated, eg each time the number is generated there is a
20% probability that it will be 1, and 80% that it will be zero. Would
appreciate it STACKS if someone could help me out!

One way to do it would be to add a staging column containing formula =RAND()
On next column, enter formula =IF(A1>0.2;0;1)

HTH
--
AP

"Ian Engelbrecht" <boehmei@yahoo.com> a écrit dans le message de
news:A56AC43F-F5C5-48EC-9588-AC9DD236B5DF@microsoft.com...
> Hi all, I would like to add a column to my spreadsheet with randomly
> generated 1's and 0's. I would like to be able to set the probability
with
> which these are generated, eg each time the number is generated there is a
> 20% probability that it will be 1, and 80% that it will be zero. Would
> appreciate it STACKS if someone could help me out!

Good call. I like it!

Andy.

"Ardus Petus" <ardus.petus@laposte.net> wrote in message
news:eVDcv6NVGHA.1236@TK2MSFTNGP11.phx.gbl...
> One way to do it would be to add a staging column containing formula
> =RAND()
> On next column, enter formula =IF(A1>0.2;0;1)
>
> HTH
> --
> AP
>
> "Ian Engelbrecht" <boehmei@yahoo.com> a écrit dans le message de
> news:A56AC43F-F5C5-48EC-9588-AC9DD236B5DF@microsoft.com...
>> Hi all, I would like to add a column to my spreadsheet with randomly
>> generated 1's and 0's. I would like to be able to set the probability
> with
>> which these are generated, eg each time the number is generated there is
>> a
>> 20% probability that it will be 1, and 80% that it will be zero. Would
>> appreciate it STACKS if someone could help me out!
>
>

Even simpler (no staging column)
=IF(RAND()>0.2,0,1)

HTH
--
AP

"Ian Engelbrecht" <boehmei@yahoo.com> a écrit dans le message de
news:A56AC43F-F5C5-48EC-9588-AC9DD236B5DF@microsoft.com...
> Hi all, I would like to add a column to my spreadsheet with randomly
> generated 1's and 0's. I would like to be able to set the probability
with
> which these are generated, eg each time the number is generated there is a
> 20% probability that it will be 1, and 80% that it will be zero. Would
> appreciate it STACKS if someone could help me out!

Thanks a lot for the help folks, much appreciated!

"Ardus Petus" wrote:

> Even simpler (no staging column)
> =IF(RAND()>0.2,0,1)
>
> HTH
> --
> AP
>
> "Ian Engelbrecht" <boehmei@yahoo.com> a écrit dans le message de
> news:A56AC43F-F5C5-48EC-9588-AC9DD236B5DF@microsoft.com...
> > Hi all, I would like to add a column to my spreadsheet with randomly
> > generated 1's and 0's. I would like to be able to set the probability
> with
> > which these are generated, eg each time the number is generated there is a
> > 20% probability that it will be 1, and 80% that it will be zero. Would
> > appreciate it STACKS if someone could help me out!
>
>
>

....or even....

=(RAND()<0.2)+0

In column A:
=RANDBETWEEN(1,100)

Fill down as far as needed

In column B:
=IF(RIGHT(A1,1)>"8",0,1) (of course "8" can be something else)

Fill down

--
Kind regards,

Niek Otten

"Ian Engelbrecht" <boehmei@yahoo.com> wrote in message news:A56AC43F-F5C5-48EC-9588-AC9DD236B5DF@microsoft.com...
> Hi all, I would like to add a column to my spreadsheet with randomly
> generated 1's and 0's. I would like to be able to set the probability with
> which these are generated, eg each time the number is generated there is a
> 20% probability that it will be 1, and 80% that it will be zero. Would
> appreciate it STACKS if someone could help me out!