{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["stochast. Funktionen"],"not_rendered":{"charts":1,"images":22,"macros":1,"external_links":0,"defined_names":26,"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":"stochast. Funktionen","index":0,"n_rows":142,"n_cols":55,"rows_kept":142,"cut":false,"hidden":false,"merged":[[35,18,35,19],[35,32,35,33],[35,39,35,40],[35,46,35,47],[35,11,35,12],[5,23,5,24],[7,16,7,17],[5,44,5,45],[5,37,5,38],[5,30,5,31],[6,16,6,17],[5,16,5,17],[5,51,5,52],[6,51,6,52],[9,33,9,34],[9,26,9,27],[8,37,8,38],[9,54,9,55],[9,40,9,41],[9,47,9,48],[9,19,9,20],[6,30,6,31],[6,37,6,38],[7,51,7,52],[6,44,6,45],[7,44,7,45],[6,23,6,24],[7,37,7,38],[7,30,7,31],[8,30,8,31],[38,1,39,1],[5,2,5,3],[6,2,6,3],[7,2,7,3],[9,5,9,6],[8,10,8,11],[9,12,9,13],[5,10,5,11],[6,10,6,11],[7,10,7,11]]}
[]
[]
[]
[]
[]
[null,"x",30,null,null,null,null,null,null,"x",10,null,null,null,null,"x",41,null,null,null,null,null,"x",30,null,null,null,null,null,"x",41,null,null,null,null,null,"x",11,null,null,null,null,null,"x",3.8014201180000047,null,null,null,null,null,"x",8.2200000000000006]
[null,"n",82,null,null,null,null,null,null,"n",31,null,null,null,null,"μ",43,null,null,null,null,null,"μ",25,null,null,null,null,null,"μ",43,null,null,null,null,null,"n",5,null,null,null,null,null,"n1",99,null,null,null,null,null,"α",2]
[null,"π",0.4,null,null,null,null,null,null,"T",30,null,null,null,null,"σ",3.34,null,null,null,null,null,null,null,null,null,null,null,null,"σ",3.34,null,null,null,null,null,null,null,null,null,null,null,null,"n2",99,null,null,null,null,null,"β",2]
[null,null,null,null,null,null,null,null,null,"N",109,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n",3]
[null," Binn,π(X ≤ x) = ",null,null,null,{"$f":"_xlfn.BINOM.DIST(xBin,nBin,pBin,TRUE)","v":0.30414583417267538},null,"     Hypn,T,N(X ≤ x)= ",null,null,null,null,{"$f":"_xlfn.HYPGEOM.DIST(xHyp,nHyp,RHyp,gNHyp,TRUE)","v":0.82575189699089968},null,null,"Norμ,σ(X ≤ x) = ",null,null,null,{"$f":"_xlfn.NORM.DIST(xNor,müNor,sigNor,TRUE)","v":0.2746523324486233},null,null,"  Poiμ(X ≤ x) = ",null,null,null,{"$f":"_xlfn.POISSON.DIST(xPoi,müPoi,TRUE)","v":0.8633088691526638},null,null,"Stuµ,σ,υ(X ≤ x) = ",null,null,null,{"$f":"_xlfn.T.DIST((xStu-müStu)/sigStu,nüStu,TRUE)","v":0.29575166507547679},null,null,"    Chiυ(X ≤ x)= ",null,null,null,{"$f":"_xlfn.CHISQ.DIST(xChi,nüChi,TRUE)","v":0.94862001651693051},null,null,"Fisυ1,υ2(X ≤ x)= ",null,null,null,{"$f":"_xlfn.F.DIST(xFis,nü1Fis,nü2Fis,TRUE)","v":0.99999999992384403},null,null,"Gamα,β(X ≤ x)= ",null,null,null,{"$f":"_xlfn.GAMMA.DIST(xGam,lamGam,nüGam,TRUE)","v":0.91615627217064455}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Prozente:",null,0.97499999999999998,null,null,null,{"$f":"\"iNor(\"&$N$36&\") = x =\"","v":"iNor(0,975) = x ="},{"$f":"_xlfn.NORM.INV(Prozente,müNor,sigNor)","v":49.546279708363777},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"iStu(\"&$N$36&\") = x =\"","v":"iStu(0,975) = x ="},{"$f":"müStu + _xlfn.T.INV(Prozente,nüStu)*sigStu","v":53.629370659647584},null,null,null,null,null,{"$f":"\"iChi(\"&$N$36&\") = x =\"","v":"iChi(0,975) = x ="},{"$f":"_xlfn.CHISQ.INV(Prozente,nüChi)","v":12.832501994030022},null,null,null,null,null,{"$f":"\"iFis(\"&$N$36&\") = x =\"","v":"iFis(0,975) = x ="},{"$f":"_xlfn.F.INV(Prozente,nü1Fis,nü2Fis)","v":1.4862337676192938}]
[]
[]
[null,"x","Bin-","Bin-","Hyp-","Nor-","Poi-","Chi-","Stu","Fis","Gam"]
[null,null,"fkt","fläche","fkt","fkt","fkt","fkt","fkt","fkt","fkt"]
[]
[0,0,{"$f":"IF(B42>nBin,\"\",_xlfn.BINOM.DIST(B42,nBin,pBin,FALSE))","v":6.4328367688565961E-19},{"$f":"IF(B42>nBin,\"\",_xlfn.BINOM.DIST(B42,nBin,pBin,FALSE))","v":6.4328367688565961E-19}]
[0.1,1,3.5166174336416017E-17,3.5166174336416017E-17]
[0.2,2,9.4948670708322957E-16,9.4948670708322957E-16]
[0.3,3,1.6879763681479589E-14,1.6879763681479589E-14]
[0.4,4,2.222502218061499E-13,2.222502218061499E-13]
[0.5,5,2.3114023067839559E-12,2.3114023067839559E-12]
[0.6,6,1.9775330846929347E-11,1.9775330846929347E-11]
[0.7,7,1.4313572803491829E-10,1.4313572803491829E-10]
[0.8,8,8.9459830021823265E-10,8.9459830021823265E-10]
[0.9,9,4.9037240160110669E-9,4.9037240160110669E-9]
[1,10,2.386479021125382E-8,2.386479021125382E-8]
[1.1000000000000001,11,1.0413726637638003E-7,1.0413726637638003E-7]
[1.2,12,4.107636618179434E-7,4.107636618179434E-7]
[1.3,13,1.4745362219105668E-6,1.4745362219105668E-6]
[1.4,14,4.8449047291347262E-6,4.8449047291347262E-6]
[1.5,15,1.4642378736940525E-5,1.4642378736940525E-5]
[1.6,16,4.0876640640625645E-5,4.0876640640625645E-5]
[1.7,17,1.0579836401103119E-4,1.0579836401103119E-4]
[1.8,18,2.5469976521174119E-4,2.5469976521174119E-4]
[1.9,19,5.7195736749303145E-4,5.7195736749303145E-4]
[2,20,1.2011104717353721E-3,1.2011104717353721E-3]
[2.1,21,2.3640904523045429E-3,2.3640904523045429E-3]
[2.2000000000000002,22,4.3699853815326326E-3,4.3699853815326326E-3]
[2.2999999999999998,23,7.5999745765784809E-3,7.5999745765784809E-3]
[2.4,24,1.2455513889392559E-2,1.2455513889392559E-2]
[2.5,25,1.9264528148927137E-2,1.9264528148927137E-2]
[2.6,26,2.8155848833047347E-2,2.8155848833047347E-2]
[2.7,27,3.8931544065448208E-2,3.8931544065448208E-2]
[2.8,28,5.0981783895229754E-2,5.0981783895229754E-2]
[2.9,29,6.3287731732009384E-2,6.3287731732009384E-2]
[3,30,7.4538884039922232E-2,7.4538884039922232E-2]
[3.1,31,8.3355311184429098E-2]
[3.2,32,{"$f":"IF(B74>nBin,\"\",_xlfn.BINOM.DIST(B74,nBin,pBin,FALSE))","v":8.8565018133456005E-2}]
[3.3,33,8.9459614276218194E-2]
[3.4,34,8.5951394108523343E-2]
[3.5,35,7.8584131756364264E-2]
[3.6,36,6.8397299862020727E-2]
[3.7,37,5.6689653939692913E-2]
[3.8,38,4.4754989952389156E-2]
[3.9,39,3.3661872784702881E-2]
[4,40,2.4124342162370447E-2]
[4.0999999999999996,41,1.6475160501131032E-2]
[4.2,42,1.0721929849942427E-2]
[4.3,43,6.6492588216697348E-3]
[4.4000000000000004,44,3.9291074855321139E-3]
[4.5,45,2.2119419918551161E-3]
[4.5999999999999996,46,1.1861138217194082E-3]
[4.7,47,6.0567514300565492E-4]
[4.8,48,2.9442541673886088E-4]
[4.9000000000000004,49,1.3619679141661583E-4]
[5,50,5.9926588223310889E-5]
[5.0999999999999996,51,2.5067331021515712E-5]
[5.2,52,9.9626572008587484E-6]
[5.3,53,3.7594932833429417E-6]
[5.4,54,1.3459914224314281E-6]
[5.5,55,4.5682133124945453E-7]
[5.6,56,1.468354279016091E-7]
[5.7,57,4.4651709069495697E-8]
[5.8,58,1.2830950882039002E-8]
[5.9,59,3.4795799002139346E-9]
[6,60,8.8922597449912063E-10]
[6.1,61,2.1380296654623784E-10]
[6.2,62,4.8278089220118069E-11]
[6.3,63,1.0217585020130847E-11]
[6.4,64,{"$f":"IF(B106>nBin,\"\",_xlfn.BINOM.DIST(B106,nBin,pBin,FALSE))","v":2.0222303685675481E-12}]
[6.5,65,3.7333483727400925E-13]
[6.6,66,6.4108002360183878E-14]
[6.7,67,1.0206249131969456E-14]
[6.8,68,1.5009189899955214E-15]
[6.9,69,2.0302285855011669E-16]
[7,70,2.513616343953859E-17]
[7.1,71,2.8322437678352931E-18]
[7.2,72,2.8846927264989515E-19]
[7.3,73,2.6344225812775984E-20]
[7.4,74,2.1360183091439805E-21]
[7.5,75,1.5189463531690553E-22]
[7.6,76,9.3268635720906945E-24]
[7.7,77,4.8451239335535938E-25]
[7.8,78,2.0705657835698879E-26]
[7.9,79,6.9892515901093971E-28]
[8,80,1.7473128975273749E-29]
[8.1,81,2.8762352222672351E-31]
[8.1999999999999993,82,2.3384026197294658E-33]
[8.3000000000000007,83,""]
[8.4,84,""]
[8.5,85,""]
[8.6,86,""]
[8.6999999999999993,87,""]
[8.8000000000000007,88,""]
[8.9,89,""]
[9,90,""]
[9.1,91,""]
[9.1999999999999993,92,""]
[9.3000000000000007,93,""]
[9.4,94,""]
[9.5,95,""]
[9.6,96,{"$f":"IF(B138>nBin,\"\",_xlfn.BINOM.DIST(B138,nBin,pBin,FALSE))","v":""}]
[9.6999999999999993,97,""]
[9.8000000000000007,98,""]
[9.9,99,""]
[10,100,""]