skewed coin toss simulator

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.

 

when i use rand() it randoms from 0-1.



i have to do randbetween(1,2)

 

Just add 1 to the rand() result.

 

ah, nevermind got it lol

 

toss this guy, he comes up tails every time, his fave position