{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Binomial","Hypergeometrisch","Vergleich"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Binomial","index":0,"n_rows":104,"n_cols":5,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,4]],"flags":["formulas_cached_only"]}
["Binomialverteilung B(n;p)"]
[]
["n",100,null,"k","B(n;p;k)"]
["p",0.5,null,0,7.888609052210105e-31]
[null,null,null,1,7.88860905221012e-29]
[null,null,null,2,3.904861480844016e-27]
[null,null,null,3,1.2755880837423814e-25]
[null,null,null,4,3.09330110307528e-24]
[null,null,null,5,5.939138117904548e-23]
[null,null,null,6,9.403635353348757e-22]
[null,null,null,7,1.2627738903068348e-20]
[null,null,null,8,1.4679746474816984e-19]
[null,null,null,9,1.5005963063146276e-18]
[null,null,null,10,1.3655426387463141e-17]
[null,null,null,11,1.1172621589742587e-16]
[null,null,null,12,8.286361012392381e-16]
[null,null,null,13,5.6092289930040825e-15]
[null,null,null,14,3.4857351599382574e-14]
[null,null,null,15,1.998488158364605e-13]
[null,null,null,16,1.0616968341311914e-12]
[null,null,null,17,5.2460314157070665e-12]
[null,null,null,18,2.4190033750204864e-11]
[null,null,null,19,1.0439909302720012e-10]
[null,null,null,20,4.2281632676015826e-10]
[null,null,null,21,1.6107288638482251e-09]
[null,null,null,22,5.783980920182273e-09]
[null,null,null,23,1.9615239642357154e-08]
[null,null,null,24,6.293222718589614e-08]
[null,null,null,25,1.9131397064512415e-07]
[null,null,null,26,5.518672230147834e-07]
[null,null,null,27,1.5125249815960618e-06]
[null,null,null,28,3.94336870201832e-06]
[null,null,null,29,9.79043263949376e-06]
[null,null,null,30,2.3170690580135303e-05]
[null,null,null,31,5.232091421320834e-05]
[null,null,null,32,0.00011281697127223096]
[null,null,null,33,0.00023247133474278003]
[null,null,null,34,0.00045810527728724264]
[null,null,null,35,0.0008638556657416539]
[null,null,null,36,0.0015597393964779877]
[null,null,null,37,0.0026979276047186924]
[null,null,null,38,0.004472879976244109]
[null,null,null,39,0.007110732269926565]
[null,null,null,40,0.010843866711638011]
[null,null,null,41,0.01586907323654348]
[null,null,null,42,0.022292269546572825]
[null,null,null,43,0.030068642644214626]
[null,null,null,44,0.03895255978909621]
[null,null,null,45,0.048474296626431046]
[null,null,null,46,0.05795839814029755]
[null,null,null,47,0.06659049999098011]
[null,null,null,48,0.07352701040670781]
[null,null,null,49,0.07802866410507764]
[null,null,null,50,0.07958923738717857]
[null,null,null,51,0.07802866410507764]
[null,null,null,52,0.07352701040670781]
[null,null,null,53,0.06659049999098011]
[null,null,null,54,0.05795839814029755]
[null,null,null,55,0.048474296626431046]
[null,null,null,56,0.03895255978909621]
[null,null,null,57,0.030068642644214626]
[null,null,null,58,0.022292269546572825]
[null,null,null,59,0.01586907323654348]
[null,null,null,60,0.010843866711638011]
[null,null,null,61,0.007110732269926565]
[null,null,null,62,0.004472879976244109]
[null,null,null,63,0.0026979276047186924]
[null,null,null,64,0.0015597393964779877]
[null,null,null,65,0.0008638556657416539]
[null,null,null,66,0.00045810527728724264]
[null,null,null,67,0.00023247133474278003]
[null,null,null,68,0.00011281697127223096]
[null,null,null,69,5.232091421320834e-05]
[null,null,null,70,2.3170690580135303e-05]
[null,null,null,71,9.79043263949376e-06]
[null,null,null,72,3.94336870201832e-06]
[null,null,null,73,1.5125249815960618e-06]
[null,null,null,74,5.518672230147834e-07]
[null,null,null,75,1.9131397064512415e-07]
[null,null,null,76,6.293222718589614e-08]
[null,null,null,77,1.9615239642357154e-08]
[null,null,null,78,5.783980920182273e-09]
[null,null,null,79,1.6107288638482251e-09]
[null,null,null,80,4.2281632676015826e-10]
[null,null,null,81,1.0439909302720012e-10]
[null,null,null,82,2.4190033750204864e-11]
[null,null,null,83,5.2460314157070665e-12]
[null,null,null,84,1.0616968341311914e-12]
[null,null,null,85,1.998488158364605e-13]
[null,null,null,86,3.4857351599382574e-14]
[null,null,null,87,5.6092289930040825e-15]
[null,null,null,88,8.286361012392381e-16]
[null,null,null,89,1.1172621589742587e-16]
[null,null,null,90,1.3655426387463141e-17]
[null,null,null,91,1.5005963063146276e-18]
[null,null,null,92,1.4679746474816984e-19]
[null,null,null,93,1.2627738903068348e-20]
[null,null,null,94,9.403635353348757e-22]
[null,null,null,95,5.939138117904548e-23]
[null,null,null,96,3.09330110307528e-24]
[null,null,null,97,1.2755880837423814e-25]
[null,null,null,98,3.904861480844016e-27]
[null,null,null,99,7.88860905221012e-29]
[null,null,null,100,7.888609052210105e-31]

{"sheet":"Hypergeometrisch","index":1,"n_rows":104,"n_cols":5,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["Hypergeometrische Verteilung H(N;K;n)"]
[]
["N",100,null,"k","H(N;K;n;k)"]
["K",50,null,0,{"$error":"#NUM!"}]
["n ",60,null,1,{"$error":"#NUM!"}]
[null,null,null,2,{"$error":"#NUM!"}]
[null,null,null,3,{"$error":"#NUM!"}]
[null,null,null,4,{"$error":"#NUM!"}]
[null,null,null,5,{"$error":"#NUM!"}]
[null,null,null,6,{"$error":"#NUM!"}]
[null,null,null,7,{"$error":"#NUM!"}]
[null,null,null,8,{"$error":"#NUM!"}]
[null,null,null,9,{"$error":"#NUM!"}]
[null,null,null,10,7.472794411214411e-19]
[null,null,null,11,1.3586898929480742e-16]
[null,null,null,12,1.0818568272599046e-14]
[null,null,null,13,5.059761161338629e-13]
[null,null,null,14,1.5712365463514067e-11]
[null,null,null,15,3.4692902943439073e-10]
[null,null,null,16,5.691804389157971e-09]
[null,null,null,17,7.155411232084307e-08]
[null,null,null,18,7.051061484949746e-07]
[null,null,null,19,5.541886921504359e-06]
[null,null,null,20,3.521869138616021e-05]
[null,null,null,21,0.00018295424096706595]
[null,null,null,22,0.0007837926005066348]
[null,null,null,23,0.002789148250632307]
[null,null,null,24,0.008292735423754988]
[null,null,null,25,0.020698667617692443]
[null,null,null,26,0.04353686097471368]
[null,null,null,27,0.07739886395504654]
[null,null,null,28,0.11655900345611174]
[null,null,null,29,0.1489247521471917]
[null,null,null,30,0.16158335607970303]
[null,null,null,31,0.1489247521471917]
[null,null,null,32,0.11655900345611174]
[null,null,null,33,0.07739886395504654]
[null,null,null,34,0.04353686097471368]
[null,null,null,35,0.020698667617692443]
[null,null,null,36,0.008292735423754988]
[null,null,null,37,0.002789148250632307]
[null,null,null,38,0.0007837926005066348]
[null,null,null,39,0.00018295424096706595]
[null,null,null,40,3.521869138616021e-05]
[null,null,null,41,5.541886921504359e-06]
[null,null,null,42,7.051061484949746e-07]
[null,null,null,43,7.155411232084307e-08]
[null,null,null,44,5.691804389157971e-09]
[null,null,null,45,3.4692902943439073e-10]
[null,null,null,46,1.5712365463514067e-11]
[null,null,null,47,5.059761161338629e-13]
[null,null,null,48,1.0818568272599046e-14]
[null,null,null,49,1.3586898929480742e-16]
[null,null,null,50,7.472794411214411e-19]
[null,null,null,51,{"$error":"#NUM!"}]
[null,null,null,52,{"$error":"#NUM!"}]
[null,null,null,53,{"$error":"#NUM!"}]
[null,null,null,54,{"$error":"#NUM!"}]
[null,null,null,55,{"$error":"#NUM!"}]
[null,null,null,56,{"$error":"#NUM!"}]
[null,null,null,57,{"$error":"#NUM!"}]
[null,null,null,58,{"$error":"#NUM!"}]
[null,null,null,59,{"$error":"#NUM!"}]
[null,null,null,60,{"$error":"#NUM!"}]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]

{"sheet":"Vergleich","index":2,"n_rows":104,"n_cols":6,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["Vergleich Binomialverteilung und Hypergeometrische Verteilung"]
[]
["N ",10000,null,"k","B(n;p;k)","H(N;K;n;k)"]
["K ",2000,null,0,0.10737418240000005,0.10725336832767719]
[null,null,null,1,0.2684354560000001,0.2684354106561814]
["n  ",10,null,2,0.30198988800000015,0.3021409830527626]
["p ",0.2,null,3,0.20132659200000017,0.20140212156951326]
[null,null,null,4,0.08808038400000005,0.08804729351451793]
[null,null,null,5,0.02642411520000001,0.026377845831891594]
[null,null,null,6,0.005505024000000006,0.005484388281080513]
[null,null,null,7,0.0007864320000000002,0.0007814266230175275]
[null,null,null,8,7.372800000000005e-05,7.302059544607709e-05]
[null,null,null,9,4.096000000000006e-06,4.040978070275051e-06]
[null,null,null,10,1.0240000000000004e-07,1.0056984172397035e-07]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]
[null,null,null,"","",""]