PC Review


Reply
Thread Tools Rate Thread

A better chance

 
 
leo31773
Guest
Posts: n/a
 
      12th Sep 2005

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

 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWlrZQ==?=
Guest
Posts: n/a
 
      12th Sep 2005
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
>
>

 
Reply With Quote
 
JE McGimpsey
Guest
Posts: n/a
 
      12th Sep 2005
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.

 
Reply With Quote
 
JE McGimpsey
Guest
Posts: n/a
 
      12th Sep 2005
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.

 
Reply With Quote
 
leo31773
Guest
Posts: n/a
 
      13th Sep 2005

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Last Chance measekite Windows Vista General Discussion 4 20th Apr 2009 06:43 PM
by any chance... =?Utf-8?B?cm9kY2hhcg==?= Microsoft ASP .NET 0 23rd Sep 2005 05:29 AM
First chance AV in IE Jon P Windows XP Internet Explorer 1 20th Sep 2005 03:20 AM
by any chance... =?Utf-8?B?cm9kY2hhcg==?= Microsoft ASP .NET 2 16th Sep 2005 07:32 PM
Re: 'This is your chance to... Wesley Vogel Windows XP Customization 0 29th May 2004 05:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:16 AM.