Ok, here's a run for full ring 9-player, minimum 7 dealt in, with a filter for BB of $0.25 to $4.00. I went ahead and stopped at 51 million flops as the stats aren't going to change. The average final pot size is shown in BBs. This counts the final pot size after the last bet went in, even if the last bet was not called (which is a lot of the time).
Note that I'm only showing the calculated frequency of each flop type here, not the actual frequency. I don't want to spoil the surprise when I publish a full analysis of the actuals soon on my web site. But this answers the question you posed. Notice at the bottom I added the wheel card flops you asked for, and a few others.
Code:
Site #0, 9-player NLHE, min 7 dealt in, BB $ 0.25 to $ 4.00
Number of hands analysed: 90,000,000
Flops seen: 51,073,435 (56.7%)
FLOP TYPES FREQUENCY
-----------------------------------------------------------
Calculated Avg. Final
[ Flop Type ] Frequency Example Pot in BBs
[ Rainbow ] 39.76471% 9s-3h-5c 24.3
[ Monotone ] 5.17647% 7c-2c-6c 25.5
[ Two-suited ] 55.05882% 3s-Qs-2c 25.9
[---check suit types---] 100.00000%
[ Paired flop ] 16.94118% 6h-Ts-6s 23.8
[ Triplet flop ] 0.23529% 5c-5s-5h 25.4
[ Unpaired flop ] 82.82353% 9s-3h-5c 25.5
[--check match types---] 100.00000%
[ Pair & connector ] 2.82353% 8d-9d-9h 24.4
[ Pair & 1gap ] 2.60633% Jh-9h-Jd 24.3
[ Pair & 2+gap ] 11.51131% 6h-Ts-6s 23.5
[ Triplets ] 0.23529% 5c-5s-5h 25.4
[ 3-Straight ] 3.47511% 2c-3c-4s 29.1
[ Connector & 1gap ] 6.95023% 9c-Jh-8s 27.6
[ Connector & 2+gap ] 26.93213% 3s-Qs-2c 25.5
[ KA2 double connector ] 0.28959% 2d-Kh-Ad 21.3
[ Double gutshot ] 3.18552% Ah-3h-Qd 26.5
[ Other 1gaps ] 21.42986% 9s-3h-5c 25.1
[ No cnct no 1gap no pr] 20.56109% Jd-4s-As 24.5
[-check connect types--] 100.00000%
Calculated Avg. Final
[ Flop Combinations ] Frequency Example Pot in BBs
[ Pair & cnctr rainbow] 1.41176% 4h-5c-4d 23.7
[ Pair & cnctr 2-suited] 1.41176% 8d-9d-9h 25.2
[ Pair & 1gap rainbow] 1.30317% Qd-Qs-Ac 23.6
[ Pair & 1gap 2-suited] 1.30317% Jh-9h-Jd 25.1
[ Pair & 2+gap rainbow] 5.75566% Jh-Jd-4s 22.8
[ Pair & 2+gap 2-suited] 5.75566% 6h-Ts-6s 24.3
[ Triplets ] 0.23529% 5c-5s-5h 25.4
[ 3-Straight rainbow] 1.30317% 2d-As-3c 28.2
[ 3-Straight 2-suited] 1.95475% 2c-3c-4s 29.7
[ 3-Straight-Flush ] 0.21719% 9d-8d-Td 28.3
[ Cnctr & 1gap rainbow] 2.60633% 9c-Jh-8s 26.8
[ Cnctr & 1gap monotone] 0.43439% 6h-3h-4h 27.2
[ Cnctr & 1gap 2-suited] 3.90950% Th-Jh-8c 28.2
[ Cnctr & 2+gap rainbow] 10.09955% Kd-Qc-4h 24.7
[ Cnctr & 2+gp monotone] 1.68326% 7c-2c-6c 25.5
[ Cnctr & 2+gp 2-suited] 15.14932% 3s-Qs-2c 26.1
[ KA2 dbl-cnct rainbow] 0.10860% 2h-Ad-Kc 20.4
[ KA2 dbl-cnct monotone] 0.01810% 2d-Kd-Ad 22.7
[ KA2 dbl-cnct 2-suited] 0.16290% 2d-Kh-Ad 21.8
[ Dbl gutshot rainbow] 1.19457% 6c-4s-8h 25.7
[ Dbl gutshot monotone] 0.19910% Js-9s-7s 26.3
[ Dbl gutshot 2-suited] 1.79186% Ah-3h-Qd 27.1
[ Other 1-gaps rainbow] 8.03620% 9s-3h-5c 24.2
[ Other 1-gaps monotone] 1.33937% 6h-2h-8h 25.1
[ Other 1-gaps 2-suited] 12.05430% 8c-3h-5c 25.7
[ No cnt/gp/pr rainbow] 7.71041% Jc-8h-5d 23.6
[ No cnt/gp/pr monotone] 1.28507% 4h-9h-Qh 24.9
[ No cnt/gp/pr 2-suited] 11.56561% Jd-4s-As 25.1
[--check combinations--] 100.00000%
Calculated Avg. Final
[More Interesting flops] Frequency Example Pot in BBs
[ Any A or K or both ] 40.07240% 5s-Ac-Qd 23.0
[ Triple-BWay unpaired ] 2.89593% Qd-Ad-Kd 24.9
[ Triple-BWay paired ] 2.26244% Ac-Jc-Ah 21.6
[ Double-BWay unpaired ] 23.16742% 5s-Ac-Qd 24.2
[ Double-BWay paired ] 4.34389% Qc-Qs-6c 22.3
[ 3 to a Wheel no pr ] 2.89593% 2c-3c-4s 26.5
.
So the biggest pots result from 3-straight flops, and next biggest are when there are lots of straight possibilities like connector+1gap and double-gut flops. Hoff's theory about wheel draw flops making the biggest pots, is wrong for low stakes anyway. It's smack in the middle. And the smallest pots happen when 2 or 3 broadway cards flop, which isn't surprising.
I'll do one for heads-up next, and maybe for 6-max.
EDIT - maybe you wanted "2 to a Wheel" and not 3? That may be more interesting.
Last edited by spadebidder; 11-15-2009 at 03:49 PM.