{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Anwendung"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":6,"defined_names":27,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"Stochastik"]
[]
[]
[null,"Kapitel",5]
[null,"Thema","Wahrscheinlichkeitsrechnung"]
[]
[null,"Inhalt","Die Hypergeometrische Verteilung"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2021-10-15"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Anwendung","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["N_G",49,"Kugeln in der Trommel",null,"k","P(X=k)","P(X<=k)"]
["M_G",6,"richtige Zahlen in der Trommel",null,0,{"$f":"_xlfn.HYPGEOM.DIST(E2,n_S,M_G,N_G,FALSE)","v":0.43596497551169155},{"$f":"_xlfn.HYPGEOM.DIST(E2,n_S,M_G,N_G,TRUE)","v":0.43596497551169155}]
["n_S",6,"zu ziehende Kugeln",null,1,0.41301945048476041,0.84898442599645185]
[null,null,null,null,2,0.13237802900152582,0.9813624549979777]
[null,null,null,null,3,1.7650403866870088E-2,0.99901285886484781]
[null,null,null,null,4,9.6861972440140832E-4,0.99998147858924913]
[null,null,null,null,5,1.8449899512407789E-5,0.99999992848876162]
[null,null,null,null,6,7.1511238420185226E-8,1]