sinister1
sinister1
Joined: Jun 10, 2020
  • Threads: 4
  • Posts: 9
July 2nd, 2020 at 4:03:48 PM permalink
Guys, does anyone know what's the Excel formula to create random Dragon 7 decisions (Banker with three card total of 7) in 1000 random baccarat hands?

As per the odds, Dragon 7 appears about 23 times per 1,000 hands.

I am currently using =IF(INT(RAND()*40)=1,"D",IF((INT(RAND()*9048)+1)<4462,"P","B")) to create random appearances of Dragon 7 in 1,000 handsas per the odds.

But, I am not sure if I am doing it right. Can anyone correct me if i am wrong.

Thanks
Ace2
Ace2
Joined: Oct 2, 2017
  • Threads: 21
  • Posts: 679
July 2nd, 2020 at 4:29:14 PM permalink
23 in 1000 is about 1 in 43

=if(Randbetween(1,43)=1,1,0)
Itís all about making that GTA
sinister1
sinister1
Joined: Jun 10, 2020
  • Threads: 4
  • Posts: 9
July 2nd, 2020 at 5:41:21 PM permalink
Thanks Ace2. So, I was doing it right. I used 40 because 904 pure PB hands / 22.5 odds of Dragon =40.17

  • Jump to: