Spreadsheet: 39580d1237866459-limit-on-number-of-random-numbers-in-prob-function-etf-tracker-problem-isolated
Sheet: Prob () with 62 random numbers

Prob () with 62 random numbers – Use C11:C72
 |  | Standard normally distributed random numbers (SNDRN)
 |  |  |  |  |  |  |  |  | Sum of probabilities |  | 0.9999999999999992 | #N/A | #N/A
 |  | smallest [NAME] |  | -2.4524075765064
 |  | largest [NAME] |  | 2.932298833251754
 |  |  |  |  |  |  | Single probability for each number |  |  |  | 0.01612903225806452
 |  | Prob() fct seems to work for no more than 61 SNDRNs
 |  | Standard normally distributed random numbers |  |  |  | Limits |  | [NAME] limit |  |  | Prob of SNDRN in being betw limits | Distribution of random numbers
 |  | 1.824564118767083 |  |  |  | -3.5 | -3.4 | -3.45 |  |  | 0.01612903225806452 | #N/A
 |  | -0.8337622069195101 |  |  |  | -3.4 | -3.3 | -3.35 |  |  | 0.01612903225806452 | #N/A
 |  | 0.994594311893944 |  |  |  | -3.3 | -3.2 | -3.25 |  |  | 0.01612903225806452 | #N/A
 |  | -1.534253081819241 |  |  |  | -3.2 | -3.1 | -3.149999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | 1.478896005014539 |  |  |  | -3.1 | -3 | -3.05 |  |  | 0.01612903225806452 | #N/A
 |  | -0.3607003672603319 |  |  |  | -3 | -2.899999999999999 | -2.949999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | 1.820918098655049 |  |  |  | -2.899999999999999 | -2.799999999999999 | -2.85 |  |  | 0.01612903225806452 | #N/A
 |  | 0.006544168513410645 |  |  |  | -2.799999999999999 | -2.699999999999999 | -2.749999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -0.1151211726902747 |  |  |  | -2.699999999999999 | -2.599999999999999 | -2.649999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -0.3057548716075119 |  |  |  | -2.599999999999999 | -2.499999999999999 | -2.549999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | 0.02560108440001289 |  |  |  | -2.499999999999999 | -2.399999999999999 | -2.449999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -0.3157478338498587 |  |  |  | -2.399999999999999 | -2.299999999999999 | -2.349999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -1.885588297242086 |  |  |  | -2.299999999999999 | -2.199999999999999 | -2.249999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -0.7308628555939056 |  |  |  | -2.199999999999999 | -2.099999999999999 | -2.149999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -0.7093799358002724 |  |  |  | -2.099999999999999 | -1.999999999999999 | -2.049999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -0.3339447920855624 |  |  |  | -1.999999999999999 | -1.899999999999999 | -1.949999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -1.020289870941646 |  |  |  | -1.899999999999999 | -1.799999999999998 | -1.849999999999999 |  |  | 0.01612903225806452 | #N/A
 |  | -0.3677677848943318 |  |  |  | -1.799999999999998 | -1.699999999999998 | -1.749999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | -1.274229146551886 |  |  |  | -1.699999999999998 | -1.599999999999998 | -1.649999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | -0.3179598703141558 |  |  |  | -1.599999999999998 | -1.499999999999998 | -1.549999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | 1.159441977632339 |  |  |  | -1.499999999999998 | -1.399999999999998 | -1.449999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | 0.1485582363373464 |  |  |  | -1.399999999999998 | -1.299999999999998 | -1.349999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | 0.08567103566092628 |  |  |  | -1.299999999999998 | -1.199999999999998 | -1.249999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | 0.3151071539268986 |  |  |  | -1.199999999999998 | -1.099999999999998 | -1.149999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | -0.5043119196889019 |  |  |  | -1.099999999999998 | -0.9999999999999979 | -1.049999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | 0.6779498025123476 |  |  |  | -0.9999999999999979 | -0.8999999999999979 | -0.949999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | -0.1077825957782222 |  |  |  | -0.8999999999999979 | -0.7999999999999979 | -0.8499999999999979 |  |  | 0.01612903225806452 | #N/A
 |  | 0.1302290605420658 |  |  |  | -0.7999999999999979 | -0.699999999999998 | -0.749999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | 0.2138412787863548 |  |  |  | -0.699999999999998 | -0.599999999999998 | -0.6499999999999979 |  |  | 0.01612903225806452 | #N/A
 |  | -0.05798800895291063 |  |  |  | -0.599999999999998 | -0.499999999999998 | -0.549999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | -0.1575258044990238 |  |  |  | -0.499999999999998 | -0.399999999999998 | -0.449999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | 0.5410363244231385 |  |  |  | -0.399999999999998 | -0.299999999999998 | -0.349999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | 0.62093585867924 |  |  |  | -0.299999999999998 | -0.199999999999998 | -0.2499999999999981 |  |  | 0.01612903225806452 | #N/A
 |  | -1.88794296831487 |  |  |  | -0.199999999999998 | -0.09999999999999803 | -0.149999999999998 |  |  | 0.01612903225806452 | #N/A
 |  | -1.07392299359058 |  |  |  | -0.09999999999999803 | 1.970645868709653e-15 | -0.04999999999999803 |  |  | 0.01612903225806452 | #N/A
 |  | -0.5667651639557132 |  |  |  | 1.970645868709653e-15 | 0.100000000000002 | 0.05000000000000197 |  |  | 0.01612903225806452 | #N/A
 |  | 0.5841459007761503 |  |  |  | 0.100000000000002 | 0.200000000000002 | 0.150000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | 0.2857188555203809 |  |  |  | 0.200000000000002 | 0.300000000000002 | 0.250000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -0.7114832739021273 |  |  |  | 0.300000000000002 | 0.400000000000002 | 0.350000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | 1.18265597028068 |  |  |  | 0.400000000000002 | 0.500000000000002 | 0.450000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | 0.7798592741131828 |  |  |  | 0.500000000000002 | 0.600000000000002 | 0.550000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -1.784892695146417 |  |  |  | 0.600000000000002 | 0.700000000000002 | 0.6500000000000019 |  |  | 0.01612903225806452 | #N/A
 |  | -0.2096293869598572 |  |  |  | 0.700000000000002 | 0.8000000000000019 | 0.750000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | 1.202395440029392 |  |  |  | 0.8000000000000019 | 0.9000000000000019 | 0.8500000000000019 |  |  | 0.01612903225806452 | #N/A
 |  | 0.4889642884679711 |  |  |  | 0.9000000000000019 | 1.000000000000002 | 0.950000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | 1.352028059706502 |  |  |  | 1.000000000000002 | 1.100000000000002 | 1.050000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -1.62552257892561 |  |  |  | 1.100000000000002 | 1.200000000000002 | 1.150000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -0.9767700895777397 |  |  |  | 1.200000000000002 | 1.300000000000002 | 1.250000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -0.02462661010592353 |  |  |  | 1.300000000000002 | 1.400000000000002 | 1.350000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -0.907689411880711 |  |  |  | 1.400000000000002 | 1.500000000000002 | 1.450000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -0.5021666449591824 |  |  |  | 1.500000000000002 | 1.600000000000003 | 1.550000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -0.9412238555199561 |  |  |  | 1.600000000000003 | 1.700000000000003 | 1.650000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | 0.3086224272832382 |  |  |  | 1.700000000000003 | 1.800000000000003 | 1.750000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | -0.8754492162628023 |  |  |  | 1.800000000000003 | 1.900000000000003 | 1.850000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | -0.0556697713298048 |  |  |  | 1.900000000000003 | 2.000000000000003 | 1.950000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | 0.6629761272180604 |  |  |  | 2.000000000000003 | 2.100000000000003 | 2.050000000000002 |  |  | 0.01612903225806452 | #N/A
 |  | -0.07619862842201608 |  |  |  | 2.100000000000003 | 2.200000000000003 | 2.150000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | -2.030676763895444 |  |  |  | 2.200000000000003 | 2.300000000000003 | 2.250000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | 0.5473932181704305 |  |  |  | 2.300000000000003 | 2.400000000000003 | 2.350000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | -1.431399906398668 |  |  |  | 2.400000000000003 | 2.500000000000003 | 2.450000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | 1.295936400741128 |  |  |  | 2.500000000000003 | 2.600000000000003 | 2.550000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | 1.06010580612171 |  |  |  | 2.600000000000003 | 2.700000000000003 | 2.650000000000003 |  |  | 0.01612903225806452 | #N/A
 |  | -0.5622375721840484 |  |  |  | 2.700000000000003 | 2.800000000000003 | 2.750000000000004 |  |  |  | #N/A
 |  | 0.1494944332474799 |  |  |  | 2.800000000000003 | 2.900000000000003 | 2.850000000000003 |  |  |  | #N/A
 |  | -1.983555132541473 |  |  |  | 2.900000000000003 | 3.000000000000004 | 2.950000000000004 |  |  |  | #N/A
 |  | 0.498879953907215 |  |  |  | 3.000000000000004 | 3.100000000000004 | 3.050000000000003 |  |  |  | #N/A
 |  | -0.6120652808895217 |  |  |  | 3.100000000000004 | 3.200000000000004 | 3.150000000000004 |  |  |  | #N/A
 |  | 0.128558316866534 |  |  |  | 3.200000000000004 | 3.300000000000004 | 3.250000000000004 |  |  |  | #N/A
 |  | 0.6300077462903683 |  |  |  | 3.300000000000004 | 3.400000000000004 | 3.350000000000004 |  |  |  | #N/A
 |  | 0.1829046205753742 |  |  |  | 3.400000000000004 | 3.500000000000004 | 3.450000000000004 |  |  |  | #N/A
 |  | 0.5618178847208293
 |  | -0.9958550914726461
 |  | 0.1246063547159163
 |  | 1.039529884883288
 |  | 0.3643348914698843
 |  | 1.7030025817787
 |  | 0.04646612521777013
 |  | 0.2415971628090745
 |  | 1.21003818539321
 |  | -1.23323826383335
 |  | -1.287108147169352
 |  | 0.3675403674576134
 |  | -0.9506441471113193
 |  | -0.2212303806103839
 |  | 0.2754294049790915
 |  | -0.8154376303695844
 |  | 0.9194816415902063
 |  | -1.559632954723494
 |  | -0.6460522955569244
 |  | 1.112337343964572
 |  | 1.403152589400662
 |  | -0.7929020101224962
 |  | 0.3567279258539462
 |  | -2.4524075765064
 |  | 1.52495202569069
 |  | 2.311585220535287
 |  | -0.1659998238674605
 |  | 0.9321734954287186
 |  | 0.810421338635419
 |  | 0.9178607109481954
 |  | -0.7948361038707233
 |  | -0.551104964368494
 |  | 0.8534117496746899
 |  | -0.5336804883112839
 |  | -1.287623442856882
 |  | 0.1318674712684236
 |  | 0.4955489122477361
 |  | 0.5456972406752004
 |  | -1.109081776382277
 |  | -1.368983112827994
 |  | -0.1502729609923499
 |  | 0.3503416437827863
 |  | 1.02419861982686
 |  | 0.1730982068275388
 |  | 0.09657229944523148
 |  | 0.3357951306670367
 |  | -0.04031703831087924
 |  | 0.2385383232833727
 |  | 0.2211820417473657
 |  | 0.6512550260625873
 |  | -0.6877788574817801
 |  | -0.006394350780741805
 |  | -0.565142142506392
 |  | 0.4185417015295881
 |  | 0.811993464587389
 |  | 1.132690899208774
 |  | -0.4685599942065641
 |  | -0.5837036073219152
 |  | 0.4474122037438502
 |  | -0.6633211820150293
 |  | 0.2524620317206867
 |  | -1.924778798266869
 |  | 0.8329006946242173
 |  | 0.370328707730277
 |  | -1.10167414492259
 |  | 0.1383252537352938
 |  | -1.241105689970753
 |  | -0.7979525964510604
 |  | -1.717426166435235
 |  | 0.07743530025281836
 |  | -0.1106113571094824
 |  | -0.1224773899432378
 |  | -0.4173140386460364
 |  | -0.4131368168572476
 |  | 0.2716407681054657
 |  | -0.2931425208226284
 |  | -1.303724430712187
 |  | 0.9170140661595491
 |  | -0.8574031784528198
 |  | -0.6355122801515113
 |  | 0.6457054797155579
 |  | -0.03172440207163659
 |  | -1.222638153730796
 |  | -2.004787670962367
 |  | -1.127663539016779
 |  | -0.4532213197312984
 |  | 0.7637069236159257
 |  | 0.7623754699803924
 |  | 0.9568046436882561
 |  | -0.8166198792644119
 |  | 0.1727726784033616
 |  | -1.369302816593244
 |  | 1.127858567666129
 |  | 0.7595932801571934
 |  | -1.306985168359017
 |  | 0.2736107215417609
 |  | -1.014913434885982
 |  | 0.1950120337272736
 |  | -0.9326091460664356
 |  | 0.1236454257548413
 |  | 1.434576543879087
 |  | 0.6205581799124756
 |  | -1.192573273074043
 |  | -0.4342004892735425
 |  | -1.005931944830461
 |  | -0.7611163822004514
 |  | -1.403172282863434
 |  | -0.2877923509776959
 |  | 0.2022803369213026
 |  | 0.3323648916082468
 |  | -0.3930694033091388
 |  | 1.309450189195678
 |  | 0.2024215775513566
 |  | 0.4223501502899393
 |  | -1.35001960765313
 |  | 0.9562880836955556
 |  | 0.1952284006214561
 |  | 1.105342112306114
 |  | -2.333801210324504
 |  | 0.6269544066454471
 |  | -0.1300450129576249
 |  | -0.06011421645137578
 |  | -0.9130637122839316
 |  | -0.07221647390842006
 |  | 0.6896383214921735
 |  | -0.4862211687081755
 |  | -0.113895943191483
 |  | 0.0799479301701915
 |  | 0.9001743992802024
 |  | -1.910037426538536
 |  | 0.5422573517309638
 |  | -1.702100786721022
 |  | 2.735731841786924
 |  | 0.7893222703865793
 |  | 0.4322262277571524
 |  | -0.222512076009476
 |  | 0.9344814472431988
 |  | -1.60098451216413
 |  | -0.7043405744834069
 |  | 0.4704331219594338
 |  | -0.2839654624231508
 |  | -0.01157265769806588
 |  | -0.6039168092916899
 |  | -0.2000075100935247
 |  | 0.7921218216705237
 |  | 0.0837607504251386
 |  | 0.172168593894138
 |  | -0.6127215002408621
 |  | 0.7419225044950438
 |  | -0.7739565899054722
 |  | 0.8896198457377043
 |  | 1.167662394962606
 |  | -0.4416029353472642
 |  | 0.1207073347066186
 |  | -0.3640258865623817
 |  | 1.960823046463682
 |  | 0.8967115296112996
 |  | -0.8922442285818922
 |  | 0.9212669661128586
 |  | -0.1850290841884553
 |  | -1.217521265790642
 |  | 0.464594394318014
 |  | -0.4924262811971811
 |  | 0.2911921275828296
 |  | -0.1190955833132294
 |  | 0.4253186643615965
 |  | 0.1835722130879937
 |  | 0.004333012188436638
 |  | -0.3918055461280314
 |  | -0.2769309842486913
 |  | 0.8903640018156189
 |  | -0.5000562196508445
 |  | -0.07527953787590912
 |  | 2.157512906250543
 |  | -1.096343870110571
 |  | -1.193087747664178
 |  | 1.126351965538975
 |  | -2.074505853055331
 |  | -0.1599210602392089
 |  | -0.4141436581810209
 |  | 0.2799997088596922
 |  | -0.3950788351541402
 |  | 1.663274846145509
 |  | -0.07372722700174802
 |  | -0.4420012711504195
 |  | 0.7051908679421366
 |  | 2.932298833251754
 |  | -0.6768686775717189
 |  | 2.47652733795124
 |  | -0.7809091947797799
 |  | -0.7066332020217875
 |  | -0.3709215259600919
 |  | 0.4225747560708617
 |  | -1.445325480601217
 |  | -1.576594885859527
 |  | 1.246591767981236
 |  | -0.1584913082763801
 |  | 0.3278240607520505
 |  | -0.1871757778383793
 |  | 0.1020537340165816
 |  | -1.047452670894395
 |  | 0.1289524140119509
 |  | -0.4545234971375313
 |  | -0.2456540707760439
 |  | -1.579991733773959
 |  | -1.212751905545549
 |  | 1.588030984120046
 |  | 0.1934157900739457
 |  | -0.7884938403303359
 |  | 1.82309782779264
 |  | -0.06895221858262023
 |  | -0.8687443525400785
 |  | 0.2528632859086354
 |  | -0.7556034139591289
 |  | 1.283001862964713
 |  | -0.5939328549896226
 |  | -0.3514457465930312
 |  | -1.056738178879251
 |  | 0.4198137266468785
 |  | -0.5293161174796864
 |  | -0.3518159829739209
 |  | -1.052911388674413
 |  | -0.2475939367383075
 |  | -0.4033189939435253
 |  | 0.01078580982353213
 |  | 0.907464153445892
 |  | -0.2210609111045148
 |  | -1.175097647925164
 |  | -1.131437476571858
 |  | -1.652234641902026
 |  | -0.09086542932924786
 |  | 0.06140925750518986
 |  | -0.5992824580965711
 |  | -2.230119361506909
 |  | -2.253602810218996
 |  | 1.44757610191503
 |  | 1.204510430359806
 |  | -0.03857910661669781
 |  | -0.1216433306641482
 |  | -0.2231362217892584
 |  | 0.8123779173450956
 |  | -0.8557265662877318
 |  | -1.382665081546303
 |  | -1.129848015070012
 |  | 0.3587154045669861
 |  | 0.2748107437433915
 |  | 0.4821158588372174
 |  | 0.2955156590769135
 |  | -0.7716651562189533
 |  | -0.2133484718431436
 |  | -0.4844640839213882
 |  | 1.143277357723803
 |  | 1.308103919605696
 |  | -0.7842635868507067
 |  | 0.2352047051705938
 |  | 0.5714883907215671
 |  | -1.008256423312254
 |  | 0.7709244360592875
 |  | 0.3444140138317218
 |  | -0.7741347199581805
 |  | -0.1556287572952622
 |  | 0.5977179033981753
 |  | 1.501087533520624
 |  | 0.8468172549102734
 |  | -0.3056021121290021
 |  | 0.9251909307943949
 |  | -1.282486536386479
 |  | 0.1563468383439514
 |  | 0.8276971727546097
 |  | 0.2848619489032144
 |  | -0.9208665794413028
 |  | -0.5415672195508373
 |  | 1.10781275751159
 |  | 0.7169644168361267
 |  | -0.02123589121673177
 |  | 1.072755829584324
 |  | 0.1565047855234463
 |  | 0.1700282776628438
 |  | 0.2212290771473707
 |  | -0.5057886274267336
 |  | -0.2096717049582641
 |  | -0.1498228910685579
 |  | 0.6677563581385793
 |  | 0.290418656141767
 |  | -0.6743297636358974
 |  | 1.23544744844369
 |  | -0.4159814475386109
 |  | -2.167442717769301
 |  | -1.029050611428941
 |  | 1.245484794286207
 |  | 0.5686742374827634
 |  | 0.6732486581213187
 |  | 0.10527406411247
 |  | -1.380513472514811
 |  | -1.111581220510869
 |  | -0.505403062651141
 |  | -1.494230102893897
 |  | -1.117034799492197
 |  | -0.04466729673382348
 |  | -0.2978904353419486
 |  | 0.1639434634879676
 |  | -0.1804673745484498
 |  | -1.236628699224994
 |  | 0.01484187470427703
 |  | 0.5277026963162684
 |  | 0.4079474733530991
 |  | 0.3534915179654691
 |  | -0.7383980265831043
 |  | 1.694255543669781
 |  | 0.5242836680286539
 |  | 0.9426041019942097
 |  | 0.2299416244099775
 |  | -1.443750484703618
 |  | 0.6061344593539179
 |  | -0.3288006403578648
 |  | 0.08673462017483685
 |  | 1.085234484822246
 |  | 0.6992764781629394
 |  | 1.133218557037516
 |  | -1.815149872206993
 |  | -0.1652111318606311
 |  | -0.9399179309598481
 |  | -1.419416598712692
 |  | 0.9901673584337183
 |  | -0.05889119073798785
 |  | 0.6817025339547828
 |  | 0.8079275880272867
 |  | -1.058161856475871
 |  | 0.03607408798406179
 |  | 1.324288845961834