skewed coin toss simulator

hilmy83

hilmy83

i'm trying to simulate skewed coin toss on google sheets.

heads=95%
tails =5%

i was trying this but it gives error.

=PROB(1,2,{0.95,0.05})
 
Just use =Rand() in one of the cells and then use =If([cell reference]<0.05, 0, 1) to create a boolean for the heads result. If the second cell is 1 then its heads. You can hold the F9 key to simulate trials.
 
Real Money said:
Just use =Rand() in one of the cells and then use =If([cell reference]<0.05, 0, 1) to create a boolean for the heads result. If the second cell is 1 then its heads. You can hold the F9 key to simulate trials.
More...
when i use rand() it randoms from 0-1.
upload_2022-8-21_17-25-3.png

upload_2022-8-21_17-25-33.png


i have to do randbetween(1,2)
 
You must log in or register to reply here.
Back
Top