No textNo textNo text

Odds of likely "no hits"

lottocalgal's avatar - Lottery-043.jpg
lottocalgal

I was hoping some of you mathemeticians can help me on this one.

I'm trying to figure out the odds of  Mega Millions if I omit the "bad" sequences.  I mean numbers such as
1,2,3,4,5, 
2,3,4,5,6,...... 18,19,20,21,22, 31,32,33,34,35.....

2,4,6,8,10
3,6,9,12,15

5,10,15,20,25

I know that there are chances that these number CAN happen but the odds are pretty slim. Is there some way I can figure this out in Excel?, I don't know maybe a formula to remove them or such?  Im not the greatest in math, and i can forget coding stuff.  But if I can remove them as well as the combinations of bonuses that can be ommitted( 1,2,3,4,5, bonus 6) then maybe I can see what the "real" odds are?

Thanks in advance.

time*treat's avatar - radar
time*treat

The odds are nearly the same. There are surprisingly (relatively) few of these types of combos, unless you're also willing to include 3 of a kind gaps e.g. 1,2,3,4,6 where the gaps are 1,1,1,2.

time*treat's avatar - radar
time*treat

quad deltas for a 56 choose 5

 


ABCDE_Delta
#112345
1
#213579
2
#31471013
3
#41591317
4
#516111621
5
#617131925
6
#718152229
7
#819172533
8
#9110192837
9
#10111213141
10
#11112233445
11
#12113253749
12
#13114274053
13
#1423456
1
#15246810
2
#162581114
3
#1726101418
4
#1827121722
5
#1928142026
6
#2029162330
7
#21210182634
8
#22211202938
9
#23212223242
10
#24213243546
11
#25214263850
12
#26215284154
13
#2734567
1
#28357911
2
#293691215
3
#3037111519
4
#3138131823
5
#3239152127
6
#33310172431
7
#34311192735
8
#35312213039
9
#36313233343
10
#37314253647
11
#38315273951
12
#39316294255
13
#4045678
1
#414681012
2
#4247101316
3
#4348121620
4
#4449141924
5
#45410162228
6
#46411182532
7
#47412202836
8
#48413223140
9
#49414243444
10
#50415263748
11
#51416284052
12
#52417304356
13
#5356789
1
#545791113
2
#5558111417
3
#5659131721
4
#57510152025
5
#58511172329
6
#59512192633
7
#60513212937
8
#61514233241
9
#62515253545
10
#63516273849
11
#64517294153
12
#65678910
1
#6668101214
2
#6769121518
3
#68610141822
4
#69611162126
5
#70612182430
6
#71613202734
7
#72614223038
8
#73615243342
9
#74616263646
10
#75617283950
11
#76618304254
12
#777891011
1
#7879111315
2
#79710131619
3
#80711151923
4
#81712172227
5
#82713192531
6
#83714212835
7
#84715233139
8
#85716253443
9
#86717273747
10
#87718294051
11
#88719314355
12
#8989101112
1
#90810121416
2
#91811141720
3
#92812162024
4
#93813182328
5
#94814202632
6
#95815222936
7
#96816243240
8
#97817263544
9
#98818283848
10
#99819304152
11
#100820324456
12
#101910111213
1
#102911131517
2
#103912151821
3
#104913172125
4
#105914192429
5
#106915212733
6
#107916233037
7
#108917253341
8
#109918273645
9
#110919293949
10
#111920314253
11
#1121011121314
1
#1131012141618
2
#1141013161922
3
#1151014182226
4
#1161015202530
5
#1171016222834
6
#1181017243138
7
#1191018263442
8
#1201019283746
9
#1211020304050
10
#1221021324354
11
#1231112131415
1
#1241113151719
2
#1251114172023
3
#1261115192327
4
#1271116212631
5
#1281117232935
6
#1291118253239
7
#1301119273543
8
#1311120293847
9
#1321121314151
10
#1331122334455
11
#1341213141516
1
#1351214161820
2
#1361215182124
3
#1371216202428
4
#1381217222732
5
#1391218243036
6
#1401219263340
7
#1411220283644
8
#1421221303948
9
#1431222324252
10
#1441223344556
11
#1451314151617
1
#1461315171921
2
#1471316192225
3
#1481317212529
4
#1491318232833
5
#1501319253137
6
#1511320273441
7
#1521321293745
8
#1531322314049
9
#1541323334353
10
#1551415161718
1
#1561416182022
2
#1571417202326
3
#1581418222630
4
#1591419242934
5
#1601420263238
6
#1611421283542
7
#1621422303846
8
#1631423324150
9
#1641424344454
10
#1651516171819
1
#1661517192123
2
#1671518212427
3
#1681519232731
4
#1691520253035
5
#1701521273339
6
#1711522293643
7
#1721523313947
8
#1731524334251
9
#1741525354555
10
#1751617181920
1
#1761618202224
2
#1771619222528
3
#1781620242832
4
#1791621263136
5
#1801622283440
6
#1811623303744
7
#1821624324048
8
#1831625344352
9
#1841626364656
10
#1851718192021
1
#1861719212325
2
#1871720232629
3
#1881721252933
4
#1891722273237
5
#1901723293541
6
#1911724313845
7
#1921725334149
8
#1931726354453
9
#1941819202122
1
#1951820222426
2
#1961821242730
3
#1971822263034
4
#1981823283338
5
#1991824303642
6
#2001825323946
7
#2011826344250
8
#2021827364554
9
#2031920212223
1
#2041921232527
2
#2051922252831
3
#2061923273135
4
#2071924293439
5
#2081925313743
6
#2091926334047
7
#2101927354351
8
#2111928374655
9
#2122021222324
1
#2132022242628
2
#2142023262932
3
#2152024283236
4
#2162025303540
5
#2172026323844
6
#2182027344148
7
#2192028364452
8
#2202029384756
9
#2212122232425
1
#2222123252729
2
#2232124273033
3
#2242125293337
4
#2252126313641
5
#2262127333945
6
#2272128354249
7
#2282129374553
8
#2292223242526
1
#2302224262830
2
#2312225283134
3
#2322226303438
4
#2332227323742
5
#2342228344046
6
#2352229364350
7
#2362230384654
8
#2372324252627
1
#2382325272931
2
#2392326293235
3
#2402327313539
4
#2412328333843
5
#2422329354147
6
#2432330374451
7
#2442331394755
8
#2452425262728
1
#2462426283032
2
#2472427303336
3
#2482428323640
4
#2492429343944
5
#2502430364248
6
#2512431384552
7
#2522432404856
8
#2532526272829
1
#2542527293133
2
#2552528313437
3
#2562529333741
4
#2572530354045
5
#2582531374349
6
#2592532394653
7
#2602627282930
1
#2612628303234
2
#2622629323538
3
#2632630343842
4
#2642631364146
5
#2652632384450
6
#2662633404754
7
#2672728293031
1
#2682729313335
2
#2692730333639
3
#2702731353943
4
#2712732374247
5
#2722733394551
6
#2732734414855
7
#2742829303132
1
#2752830323436
2
#2762831343740
3
#2772832364044
4
#2782833384348
5
#2792834404652
6
#2802835424956
7
#2812930313233
1
#2822931333537
2
#2832932353841
3
#2842933374145
4
#2852934394449
5
#2862935414753
6
#2873031323334
1
#2883032343638
2
#2893033363942
3
#2903034384246
4
#2913035404550
5
#2923036424854
6
#2933132333435
1
#2943133353739
2
#2953134374043
3
#2963135394347
4
#2973136414651
5
#2983137434955
6
#2993233343536
1
#3003234363840
2
#3013235384144
3
#3023236404448
4
#3033237424752
5
#3043238445056
6
#3053334353637
1
#3063335373941
2
#3073336394245
3
#3083337414549
4
#3093338434853
5
#3103435363738
1
#3113436384042
2
#3123437404346
3
#3133438424650
4
#3143439444954
5
#3153536373839
1
#3163537394143
2
#3173538414447
3
#3183539434751
4
#3193540455055
5
#3203637383940
1
#3213638404244
2
#3223639424548
3
#3233640444852
4
#3243641465156
5
#3253738394041
1
#3263739414345
2
#3273740434649
3
#3283741454953
4
#3293839404142
1
#3303840424446
2
#3313841444750
3
#3323842465054
4
#3333940414243
1
#3343941434547
2
#3353942454851
3
#3363943475155
4
#3374041424344
1
#3384042444648
2
#3394043464952
3
#3404044485256
4
#3414142434445
1
#3424143454749
2
#3434144475053
3
#3444243444546
1
#3454244464850
2
#3464245485154
3
#3474344454647
1
#3484345474951
2
#3494346495255
3
#3504445464748
1
#3514446485052
2
#3524447505356
3
#3534546474849
1
#3544547495153
2
#3554647484950
1
#3564648505254
2
#3574748495051
1
#3584749515355
2
#3594849505152
1
#3604850525456
2
#3614950515253
1
#3625051525354
1
#3635152535455
1
#3645253545556
1
TopEnd of thread (1 page)

Log In

Log InCancel

Forgot your username?

Forgot your password?