PDA

View Full Version : Solved: Generating a 1 or 0 randomly with frequency l



Tuneman12
03-17-2009, 05:38 PM
I want to have excel create a random variable, where it equals 1 x% of the time, and 0 (1-X)% of the time. Is there a simple way to do this?

Thanks again in advance.

mdmackillop
03-17-2009, 05:46 PM
This should give you a 60/40 split. Adjust to suit
=IF(RAND()>0.6,1,0)

Tuneman12
03-18-2009, 08:47 AM
Thanks a ton man!