Spreadsheet: 587969d1535412332-creating-drop-down-that-will-select-the-correct-data-excel-distribution-list
Sheet: Sheet2

 | Team A | Team B | Team C | Team D | Team E | Team F | Team G | Team H | Team I | Team J | Team K | Team L
Poisson | 8.011463788653334 | 5.810353147808573 | 6.081772073518652 | 2.498170081109685 | 7.468644936732789 | 5.339692784988535 | 4.542676983546576 | 11.13682484739913 | 3.875262560343502 | 2.484508502808797 | 2.256879852010908 | 3.864071288229892
Zero Inflated Poisson | 4.346898805960739 | 31.39334065390853 | 10.99656670967748 | 7.056213821014481 | 13.51028159525491 | 11.45084159968444 | 10.58829004899588 | 6.985092667724879 | 7.136536382339436 | 10.38278954351317 | 6.193302216465323 | 6.590095668053306
Negative Binomial | 4.166215366419319 | 5.355561001115187 | 3.205948236856166 | 2.530884753598429 | 6.24495938599723 | 5.462591836726473 | 6.118420217325623 | 9.966608896340768 | 3.405476016077289 | 2.262019077034702 | 1.821980722615686 | 3.115573320575676
Negative Binomial, Corrected | 4.132783042409561 | 5.35200166202265 | 3.179832436360936 | 2.531664974528192 | 6.233340231724572 | 5.470549432835334 | 6.19601090501051 | 9.945295418844262 | 3.402589081526901 | 2.261370211790116 | 1.817797660204763 | 3.112141158622441
Negative Binomial 2 | 2.521951664795664 | 3.648007419464462 | 3.270834239645367 | 4.824489961225209 | 7.012280007076683 | 9.38819182813927 | 10.12811557656053 | 9.384315023537058 | 8.45080966519589 | 6.374648120525369 | 3.313206037472846 | 9.272785277786495
Geometric | 6.838196147062067 | 17.11722033955465 | 6.76786373027303 | 11.32088785908407 | 11.9557837926548 | 24.10069844781 | 22.1622195059579 | 12.27446078857744 | 16.75809945807163 | 24.20230444803125 | 10.30790964357615 | 25.83568669876423
Uniform | 6.263157894736842 | 2.982456140350878 | 5.157894736842105 | 5.789473684210527 | 10.07272727272727 | 11.62745098039216 | 4.052631578947368 | 3.580645161290323 | 0.4210526315789473 | 12.60377358490566 | 3.263157894736842 | 3.631578947368421
 |  |  |  |  |  |  |  | HOME | TEAM A | TYPE | NEGATIVE BINOMIAL 2
 |  |  |  |  |  |  |  | AWAY | TEAM E | TYPE | POISSON
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.2098413502516336 | 0.2836649550065412 | 0.2400925805591296 | 0.2405192360332789 | 0.2785991080832659 | 0.3904109589041096 | 0.25 |  |  | Away Goals
1 | 0.3276470205683402 | 0.2698630282318365 | 0.3138274731876519 | 0.3136257952004409 | 0.2950918566736561 | 0.2379902420716832 | 0.25 |  | Home Goals | 0 | 1 | 2 | 3 | 4 | 5+
2 | 0.2557946037770376 | 0.231206786122809 | 0.2306588345144285 | 0.2303325950660733 | 0.2037366622009827 | 0.1450762434546562 | 0.25 |  | 0
3 | 0.1331328639541307 | 0.1320585441671156 | 0.1255425444488263 | 0.1254330696057126 | 0.1156186699684055 | 0.08843688813331783 | 0.25 |  | 1
4 | 0.05196853022770889 | 0.05657097931678398 | 0.05635906666731527 | 0.0564011378106046 | 0.05850619526657059 | 0.05391015783469374 | 0 |  | 2
5+ | 0.01622876908865295 | 0.01938701185019977 | 0.02207650184294647 | 0.02214860309808483 | 0.02744813009768237 | 0.03286304141977906 | 0 |  | 3
 |  |  |  |  |  |  |  |  | 4
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM |  | 5+
0 | 0.1077361415001028 | 0.2836649550065412 | 0.1115548951300211 | 0.1115872598339809 | 0.1614376293348738 | 0.3097826086956522 | 0.2
1 | 0.2400436836932116 | 0.2698630282318365 | 0.2408614144195241 | 0.240867899663709 | 0.2440034623708898 | 0.2138173440453686 | 0.2
2 | 0.2674170862196305 | 0.231206786122809 | 0.2637518148224708 | 0.2637212044410868 | 0.2236386591681823 | 0.1475804494226186 | 0.2
3 | 0.1986080114028834 | 0.1320585441671156 | 0.1952654215872971 | 0.1952376474682701 | 0.16062581606144 | 0.101862592808003 | 0.2
4 | 0.1106281467024833 | 0.05657097931678398 | 0.1099322498122019 | 0.1099262203053656 | 0.09944148016436555 | 0.07030733307943687 | 0.2
5+ | 0.04929745484636974 | 0.01938701185019977 | 0.0501928088389718 | 0.05019998898824841 | 0.05564720995425318 | 0.0485273440276548 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.3877601032963249 | 0.2836649550065412 | 0.4110040205154834 | 0.4114724352621498 | 0.4605174840318252 | 0.5135135135135136 | 0.3333333333333333
1 | 0.3673516768070447 | 0.2698630282318365 | 0.3434390267904717 | 0.3429682749374903 | 0.295956157207801 | 0.2498173849525201 | 0.3333333333333333
2 | 0.1740086890138632 | 0.231206786122809 | 0.1637478175780532 | 0.163543330291801 | 0.142694768099574 | 0.1215327818687935 | 0.3333333333333333
3 | 0.05495011232016733 | 0.1320585441671156 | 0.05848769438630244 | 0.05854157182079601 | 0.06116532063922033 | 0.05912405604427792 | 0
4 | 0.01301450028635542 | 0.05657097931678398 | 0.01739295200574612 | 0.01747541640483144 | 0.02458188427825097 | 0.02876305429181088 | 0
5+ | 0.002465905317414711 | 0.01938701185019977 | 0.004548184679618929 | 0.004593346064602913 | 0.009484707318118398 | 0.01399283722304313 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.3197068243005924 | 0.2836649550065412 | 0.3144284332731058 | 0.3143477941753036 | 0.393231329276253 | 0.4672131147540984 | 0.3333333333333333
1 | 0.3645779575357632 | 0.2698630282318365 | 0.3691302814867253 | 0.3692000574172746 | 0.3041928239028324 | 0.2489250201558721 | 0.3333333333333333
2 | 0.2078733968405668 | 0.231206786122809 | 0.2112327553817371 | 0.2112845697312578 | 0.1665773418930147 | 0.1326239861486204 | 0.3333333333333333
3 | 0.07901620347740841 | 0.1320585441671156 | 0.07850855935583294 | 0.07850004321700763 | 0.0786714564992308 | 0.07066032048901906 | 0
4 | 0.02252654923698047 | 0.05657097931678398 | 0.02130569289638701 | 0.02128663967853077 | 0.03419223289128608 | 0.03764689206382164 | 0
5+ | 0.005137634036504318 | 0.01938701185019977 | 0.004499926863004651 | 0.004490317730393874 | 0.01408801337352622 | 0.02005777036187218 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.3547423114369882 | 0.2836649550065412 | 0.3753236663026558 | 0.3757178844168499 | 0.4281654977244477 | 0.4910714285714286 | 0.3333333333333333
1 | 0.3676420318528787 | 0.2698630282318365 | 0.3481458338772238 | 0.3477788697924316 | 0.301013647719594 | 0.2499202806122449 | 0.3333333333333333
2 | 0.1905054165055826 | 0.231206786122809 | 0.1797384607115501 | 0.179537109411076 | 0.1542194895903612 | 0.1271915713830175 | 0.3333333333333333
3 | 0.0658109620655649 | 0.1320585441671156 | 0.06815117062021064 | 0.06818333222249123 | 0.06920879474429852 | 0.06473142472171424 | 0
4 | 0.01705102198971454 | 0.05657097931678398 | 0.02116884933847761 | 0.02124181794003534 | 0.02885904885868813 | 0.03294367151015815 | 0
5+ | 0.003534211830595378 | 0.01938701185019977 | 0.005704678855088283 | 0.005748032543718288 | 0.01148346469881754 | 0.01676597567927691 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.1926155927738401 | 0.2836649550065412 | 0.1732847342903573 | 0.1730917559959989 | 0.2597361960384781 | 0.3777777777777778 | 0.25
1 | 0.3172492116275014 | 0.2698630282318365 | 0.3236666702996701 | 0.3237262568724679 | 0.2902043633608175 | 0.2350617283950617 | 0.25
2 | 0.2612640566344129 | 0.231206786122809 | 0.2805851658548249 | 0.2807911312503988 | 0.2087934736101656 | 0.1462606310013717 | 0.25
3 | 0.1434390899169326 | 0.1320585441671156 | 0.1496220781560265 | 0.1496832385950435 | 0.1225323746745127 | 0.09100661484529797 | 0.25
4 | 0.05906315467167811 | 0.05657097931678398 | 0.05482564066982767 | 0.05477345912183675 | 0.06378466697308255 | 0.05662633812596318 | 0
5+ | 0.01945609800949396 | 0.01938701185019977 | 0.01460192569476289 | 0.01455005158004342 | 0.03066576747216225 | 0.03523416594504376 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.2877641565813683 | 0.2836649550065412 | 0.2566809608460677 | 0.2563057295863035 | 0.3607704963889952 | 0.4453125 | 0.3333333333333333
1 | 0.3584430722329324 | 0.2698630282318365 | 0.3821090039237725 | 0.3823970798925762 | 0.3048434438299076 | 0.24700927734375 | 0.3333333333333333
2 | 0.2232408607766509 | 0.231206786122809 | 0.2471361255028434 | 0.2474469836753236 | 0.1778175510113908 | 0.1370129585266113 | 0.3333333333333333
3 | 0.09269064979615332 | 0.1320585441671156 | 0.09048651455876988 | 0.09043531689557659 | 0.08821245607822477 | 0.07599937543272972 | 0
4 | 0.02886419357687231 | 0.05657097931678398 | 0.02043422951224548 | 0.02031747804905835 | 0.03991368683462516 | 0.04215590356034227 | 0
5+ | 0.00719072892616819 | 0.01938701185019977 | 0.002894258488151449 | 0.002848039978339025 | 0.01701540915850565 | 0.02338335275612735 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.2267582135427993 | 0.2836649550065412 | 0.2543059923309414 | 0.2550408380843259 | 0.296851759081333 | 0.4025974025974026 | 0.25
1 | 0.336479929773186 | 0.2698630282318365 | 0.3219709686462605 | 0.3215772225506557 | 0.2988120567880531 | 0.2405127340192275 | 0.25
2 | 0.249646399509138 | 0.231206786122809 | 0.2274485341724559 | 0.2268981709716508 | 0.1984471098449685 | 0.1436829320114866 | 0.25
3 | 0.1234810148109715 | 0.1320585441671156 | 0.1182448362877825 | 0.1180952966347084 | 0.1091377740825193 | 0.08583655678608289 | 0.25
4 | 0.04580747323632814 | 0.05657097931678398 | 0.0504432348560146 | 0.05053605483070165 | 0.05379165385588251 | 0.05127898197610147 | 0
5+ | 0.01359447592820061 | 0.01938701185019977 | 0.01869601601562464 | 0.01881939678100443 | 0.02467047024173473 | 0.030634197024684 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.3253652057493628 | 0.2836649550065412 | 0.3044980739101485 | 0.3041948868616993 | 0.3989186073983333 | 0.4710743801652893 | 0.3333333333333333
1 | 0.3653223362799863 | 0.2698630282318365 | 0.3838793815746285 | 0.384152750516429 | 0.303844769617867 | 0.2491633085171778 | 0.3333333333333333
2 | 0.2050932414203432 | 0.231206786122809 | 0.2184059824071101 | 0.2186067909432333 | 0.1645787006937637 | 0.1317888573975156 | 0.3333333333333333
3 | 0.07676004357252611 | 0.1320585441671156 | 0.07389996203741142 | 0.07384521564896251 | 0.07707464473941301 | 0.06970650308628921 | 0
4 | 0.02154667889755119 | 0.05657097931678398 | 0.0164847637693487 | 0.01640603187317971 | 0.03326890719097798 | 0.03686955535142571 | 0
5+ | 0.004838552454186933 | 0.01938701185019977 | 0.002536898087003494 | 0.002506660787564024 | 0.01362839382959983 | 0.01950125241728302 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.1459445824066642 | 0.2836649550065412 | 0.134101421959133 | 0.1340015415633869 | 0.2069676659694179 | 0.3419354838709677 | 0.2
1 | 0.2808744793486745 | 0.2698630282318365 | 0.2814554443938286 | 0.2814575228466475 | 0.2702023715115932 | 0.2250156087408949 | 0.2
2 | 0.2702754423921207 | 0.231206786122809 | 0.2826177381478223 | 0.2827266347713695 | 0.219832067017016 | 0.1480747876875567 | 0.2
3 | 0.1733842460628699 | 0.1320585441671156 | 0.1806580315479636 | 0.1807218026733728 | 0.1428031136294584 | 0.09744276351052115 | 0.2
4 | 0.0834207221623242 | 0.05657097931678398 | 0.08252129593420866 | 0.08251053609511931 | 0.08105645591833048 | 0.06412362501982682 | 0.2
5+ | 0.03210910815304554 | 0.01938701185019977 | 0.02866065372496047 | 0.02862880006391135 | 0.04202090113777788 | 0.04219748227111185 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.3033152891764075 | 0.2836649550065412 | 0.3139579360237167 | 0.3141246365949931 | 0.3766513797382113 | 0.456 | 0.3333333333333333
1 | 0.3618498186665914 | 0.2698630282318365 | 0.353305209258696 | 0.3531720782316458 | 0.3048147452365295 | 0.248064 | 0.3333333333333333
2 | 0.2158402427134054 | 0.231206786122809 | 0.2088101131359624 | 0.208702264685212 | 0.1723593598386345 | 0.134946816 | 0.3333333333333333
3 | 0.0858312076287226 | 0.1320585441671156 | 0.08622115284019634 | 0.0862246693634978 | 0.08345346650605734 | 0.07341106790400001 | 0
4 | 0.02559878122260147 | 0.05657097931678398 | 0.02792403985981901 | 0.02795851591441706 | 0.03701548449366433 | 0.03993562093977601 | 0
5+ | 0.006107779379427719 | 0.01938701185019977 | 0.007551625218262061 | 0.007574382077930051 | 0.01551557542612642 | 0.02172497779123815 | 0
 | POISSON | ZERO INFLATED POISSON | NEGATIVE BINOMIAL | [NAME], CORRECTED | NEGATIVE BINOMIAL 2 | GEOMETRIC | UNIFORM
0 | 0.1990826751101795 | 0.2836649550065412 | 0.1783977404661031 | 0.1782103263137 | 0.2668524368252418 | 0.3825503355704699 | 0.25
1 | 0.321326422984851 | 0.2698630282318365 | 0.3288968907073629 | 0.3289613097976215 | 0.2921773171212175 | 0.2362055763253908 | 0.25
2 | 0.2593160606544412 | 0.231206786122809 | 0.2797885676435567 | 0.2799873080722046 | 0.2069402642097534 | 0.1458450538384963 | 0.25
3 | 0.1395150735684713 | 0.1320585441671156 | 0.1454094159366169 | 0.1454613657815224 | 0.1198995034573116 | 0.09005197955128633 | 0.25
4 | 0.05629555600131295 | 0.05657097931678398 | 0.05150747366345393 | 0.05145404434222489 | 0.06174261652957553 | 0.05560256455515666 | 0
5+ | 0.01817260053375716 | 0.01938701185019977 | 0.01313085097948987 | 0.0130822367423746 | 0.0294073777194931 | 0.03433178482600277 | 0