{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Normalverteilung","Normalverteilung (BocksBeispie)","Konfidenzintervall MW"],"not_rendered":{"charts":12,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Normalverteilung","index":0,"n_rows":101,"n_cols":35,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Zahlenwerte zum Erzeugen der Graphen, vgl. die verwendeten Formeln",null,null,null,null,null,null,null,null,null,null,"Theoretische Verteilungen -- Normalverteilung und Standardnormalverteilung"]
[null,"X","Z","f(x)","F(x)","f(z)","F(z)"," - f(a)","f(b) - ",null,null,"Mittelwert:",null,200,null,null,null,null,"links: W(Z < a) für",null,null,null,null,"a = ",-1,{"$f":"3+Y2","v":2},null,null,null,null,null,"rechts: W(Z > a) für ","b =",3,{"$f":"AH2+3","v":6}]
[1,{"$f":"$N$2+C3*$N$3","v":170.59999999999997},{"$f":"C4-0.06","v":-2.9400000000000022},{"$f":"NORMDIST(B3,$N$2,$N$3,FALSE)","v":5.2963438653109627E-4},{"$f":"NORMDIST(B3,$N$2,$N$3,TRUE)","v":1.6410612341569767E-3},{"$f":"NORMDIST(C3,0,1,0)","v":5.2963438653109828E-3},{"$f":"NORMSDIST(C3)","v":1.6410612341569829E-3},{"$f":"IF($Y$2>=$C3,$F3,0)","v":5.2963438653109828E-3},{"$f":"IF($AH$2<=$C3,$F3,0)","v":0},null,null,"Standardabw.:",null,10,null,null,null,null,null,null,null,null,"F(a)=",{"$f":"NORMSDIST(Y2)","v":0.15865525393145699},null,null,null,null,null,null,null,"1-F(b)=",{"$f":"NORMSDIST(AH2)","v":0.9986501019683699}]
[2,171.2,{"$f":"C5-0.06","v":-2.8800000000000021},6.306726396265905E-4,1.988375854894313E-3,{"$f":"NORMDIST(C4,0,1,0)","v":6.3067263962658885E-3},{"$f":"NORMSDIST(C4)","v":1.9883758548943095E-3},6.3067263962658885E-3,0,null,null,"Dichtefunktion: "]
[3,171.79999999999998,-2.8200000000000021,7.482872525780527E-4,2.4011824741892382E-3,7.482872525780517E-3,2.4011824741892352E-3,7.482872525780517E-3,0]
[4,172.39999999999998,-2.760000000000002,8.8464543982371628E-4,2.8900680762261213E-3,8.846454398237176E-3,2.890068076226127E-3,8.846454398237176E-3,0]
[5,172.99999999999997,-2.700000000000002,1.0420934814422515E-3,3.4669738030406357E-3,1.042093481442254E-2,3.4669738030406456E-3,1.042093481442254E-2,0]
[6,173.59999999999997,-2.6400000000000019,1.2231526351277871E-3,4.1453013610359968E-3,1.2231526351277911E-2,4.1453013610360176E-3,1.2231526351277911E-2,0]
[7,174.2,-2.5800000000000018,1.4305108994149658E-3,4.9400157577706291E-3,1.4305108994149626E-2,4.9400157577706169E-3,1.4305108994149626E-2,0]
[8,174.79999999999998,-2.5200000000000018,1.6670100837380985E-3,5.8677417153325312E-3,1.6670100837380984E-2,5.8677417153325312E-3,1.6670100837380984E-2,0]
[9,175.39999999999998,-2.4600000000000017,1.9356276731736851E-3,6.9468507886242675E-3,1.9356276731736878E-2,6.9468507886242814E-3,1.9356276731736878E-2,0]
[10,175.99999999999997,-2.4000000000000017,2.2394530294842733E-3,8.19753592459606E-3,2.2394530294842813E-2,8.1975359245960878E-3,2.2394530294842813E-2,0]
[11,176.6,-2.3400000000000016,2.5816575471587638E-3,9.6418699453583064E-3,2.5816575471587579E-2,9.6418699453582821E-3,2.5816575471587579E-2,0]
[12,177.2,-2.2800000000000016,2.9654584847341203E-3,1.1303844238552753E-2,2.965458484734116E-2,1.1303844238552744E-2,2.965458484734116E-2,0]
[13,177.79999999999998,-2.2200000000000015,3.3940763182449081E-3,1.3209383807256218E-2,3.3940763182449075E-2,1.3209383807256218E-2,3.3940763182449075E-2,0]
[14,178.39999999999998,-2.1600000000000015,3.8706856147455418E-3,1.5386334783925357E-2,3.870685614745549E-2,1.5386334783925388E-2,3.870685614745549E-2,0]
[15,179,-2.1000000000000014,4.3983595980427196E-3,1.7864420562816546E-2,4.3983595980427052E-2,1.7864420562816487E-2,4.3983595980427052E-2,0]
[16,179.6,-2.0400000000000014,4.9800087735070728E-3,2.0675162866070018E-2,4.9800087735070636E-2,2.0675162866069973E-2,4.9800087735070636E-2,0]
[17,180.2,-1.9800000000000013,5.6183141903867915E-3,2.3851764341508451E-2,5.6183141903867896E-2,2.3851764341508451E-2,5.6183141903867896E-2,0]
[18,180.79999999999998,-1.9200000000000013,6.3156561435198447E-3,2.7428949703836691E-2,6.3156561435198502E-2,2.742894970383673E-2,6.3156561435198502E-2,0,null,null,"Verteilungsfunktion: "]
[19,181.39999999999998,-1.8600000000000012,7.0740393456983092E-3,3.1442762980752541E-2,7.0740393456983228E-2,3.144276298075261E-2,7.0740393456983228E-2,0,null,null,null,null,null,null,null,null,null,"x-Werte: ",null,null,{"$f":"$N$2-$N$3*2","v":180},null,null,{"$f":"$N$2-$N$3","v":190},null,{"$f":"B52","v":200},null,null,{"$f":"$N$2+$N$3","v":210},null,{"$f":"$N$2+$N$3*2","v":220}]
[20,182,-1.8000000000000012,7.8950158300894139E-3,3.5930319112925789E-2,7.8950158300893997E-2,3.5930319112925713E-2,7.8950158300893997E-2,0]
[21,182.6,-1.7400000000000011,8.7796070610905528E-3,4.0929508978807289E-2,8.7796070610905469E-2,4.0929508978807275E-2,8.7796070610905469E-2,0]
[22,183.2,-1.680000000000001,9.7282269331467313E-3,4.6478657863719915E-2,9.728226933146733E-2,4.6478657863719915E-2,9.728226933146733E-2,0]
[23,183.79999999999998,-1.620000000000001,1.0740607511348352E-2,5.2616138454251886E-2,0.10740607511348366,5.2616138454251948E-2,0.10740607511348366,0]
[24,184.39999999999998,-1.5600000000000009,1.1815729505958186E-2,5.937994059479277E-2,0.11815729505958211,5.9379940594792902E-2,0.11815729505958211,0]
[25,185,-1.5000000000000009,1.2951759566589173E-2,6.6807201268858057E-2,0.12951759566589155,6.6807201268857905E-2,0.12951759566589155,0]
[26,185.6,-1.4400000000000008,1.4145996522483868E-2,7.4933699534326922E-2,0.14145996522483861,7.4933699534326922E-2,0.14145996522483861,0]
[27,186.2,-1.3800000000000008,1.5394828676263345E-2,8.379332241501404E-2,0.15394828676263353,8.3793322415014096E-2,0.15394828676263353,0]
[28,186.79999999999998,-1.3200000000000007,1.6693704174171348E-2,9.341750899347151E-2,0.16693704174171367,9.3417508993471676E-2,0.16693704174171367,0]
[29,187.4,-1.2600000000000007,1.803711632270805E-2,0.10383468112130051,0.18037116322708019,0.10383468112130027,0.18037116322708019,0]
[30,188,-1.2000000000000006,1.9418605498321296E-2,0.11506967022170828,0.19418605498321281,0.1150696702217081,0.19418605498321281,0]
[31,188.6,-1.1400000000000006,2.0830779004710823E-2,0.12714315056279812,0.20830779004710823,0.12714315056279812,0.20830779004710823,0]
[32,189.2,-1.0800000000000005,2.2265349875176085E-2,0.14007109008876883,0.22265349875176099,0.14007109008876895,0.22265349875176099,0]
[33,{"$f":"$N$2+C35*$N$3","v":189.79999999999998},-1.0200000000000005,{"$f":"NORMDIST(B35,$N$2,$N$3,FALSE)","v":2.3713195201937917E-2},{"$f":"NORMDIST(B35,$N$2,$N$3,TRUE)","v":0.15386423037273442},0.23713195201937948,0.15386423037273475,{"$f":"IF($Y$2>=$C35,$F35,0)","v":0.23713195201937948},{"$f":"IF($AH$2<=$C35,$F35,0)","v":0}]
[34,190.4,-0.96000000000000041,2.5164434109811729E-2,0.16852760746683798,0.25164434109811701,0.1685276074668377,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mittelwert z=0 bzw. m"]
[35,191,-0.90000000000000036,2.6608524989875482E-2,0.1840601253467595,0.26608524989875476,0.18406012534675939,0,0]
[36,191.6,-0.8400000000000003,2.8034381083962043E-2,0.20045419326044947,0.28034381083962051,0.20045419326044961,0,0,null,null,"Die Flächen werden als Säulendiagramm erzeugt,  "]
[37,192.2,-0.78000000000000025,2.9430502978832485E-2,0.21769543758573276,0.29430502978832507,0.21769543758573301,0,0,null,null,"     bei dem sich die - sehr schmalen - Säulen berühren"]
[38,192.8,-0.7200000000000002,3.0785126046985321E-2,0.23576249777925151,0.30785126046985289,0.23576249777925107,0,0,null,null,"     und so als Fläche erscheinen"]
[39,193.4,-0.66000000000000014,3.2086380377117259E-2,0.25462691467133625,0.32086380377117246,0.25462691467133608,0,0,null,null,"Die Markierungen nach unten und links in der Verteilungsfunktion"]
[40,194,-0.60000000000000009,3.3322460289179963E-2,0.27425311775007355,0.33322460289179967,0.27425311775007355,0,0,null,null,"     sind \"Fehlerindikatoren\" (Diagrammelement hinzufügen)"]
[41,194.6,-0.54,3.448180014393333E-2,0.29459851621569783,0.34481800143933333,0.29459851621569799,0,0,null,null,"Beides anschaulich beschrieben bei Andreas Thehos: "]
[42,195.2,-0.48,3.5553252850599688E-2,0.31561369651622218,0.35553252850599709,0.31561369651622256,0,0,null,null,"     https://www.youtube.com/watch?v=eBKLXe8JGSY"]
[43,195.8,-0.42,3.6526267262215403E-2,0.33724272684824985,0.36526267262215389,0.33724272684824952,0,0]
[44,196.4,-0.36,3.7391060537312844E-2,0.35942356678200899,0.37391060537312842,0.35942356678200876,0,0]
[45,197,-0.3,3.8138781546052408E-2,0.38208857781104733,0.38138781546052414,0.38208857781104733,0,0]
[46,197.6,-0.24,3.8761661512501405E-2,0.40516512830220391,0.38761661512501416,0.40516512830220414,0,0]
[47,198.2,-0.18,3.9253148312042879E-2,0.42857628409909881,0.3925314831204289,0.42857628409909926,0,0]
[48,198.8,-0.12,3.9608021179365613E-2,0.45224157397941661,0.3960802117936561,0.45224157397941611,0,0]
[49,199.4,{"$f":"C52-0.06","v":-0.06},3.9822483019560692E-2,0.47607781734589338,{"$f":"NORMDIST(C51,0,1,0)","v":0.39822483019560695},{"$f":"NORMSDIST(C51)","v":0.47607781734589316},0,0]
[50,{"$f":"N2","v":200},{"$f":"(B52-$N$2)/$N$3","v":0},3.9894228040143274E-2,0.5,{"$f":"NORMDIST(C52,0,1,0)","v":0.3989422804014327},{"$f":"NORMSDIST(C52)","v":0.5},0,0]
[51,{"$f":"$N$2+C53*$N$3","v":200.6},{"$f":"C52+0.06","v":0.06},3.9822483019560692E-2,0.52392218265410662,{"$f":"NORMDIST(C53,0,1,0)","v":0.39822483019560695},{"$f":"NORMSDIST(C53)","v":0.52392218265410684},0,0]
[52,201.2,{"$f":"C53+0.06","v":0.12},3.9608021179365613E-2,0.54775842602058344,{"$f":"NORMDIST(C54,0,1,0)","v":0.3960802117936561},{"$f":"NORMSDIST(C54)","v":0.54775842602058389},0,0]
[53,201.8,0.18,3.9253148312042879E-2,0.57142371590090124,0.3925314831204289,0.5714237159009008,0,0]
[54,202.4,0.24,3.8761661512501405E-2,0.59483487169779603,0.38761661512501416,0.59483487169779581,0,0]
[55,203,0.3,3.8138781546052408E-2,0.61791142218895267,0.38138781546052414,0.61791142218895267,0,0]
[56,203.6,0.36,3.7391060537312844E-2,0.64057643321799107,0.37391060537312842,0.64057643321799129,0,0]
[57,204.2,0.42,3.6526267262215403E-2,0.66275727315175015,0.36526267262215389,0.66275727315175048,0,0]
[58,204.8,0.48,3.5553252850599688E-2,0.68438630348377782,0.35553252850599709,0.68438630348377738,0,0]
[59,205.4,0.54,3.448180014393333E-2,0.70540148378430212,0.34481800143933333,0.70540148378430201,0,0]
[60,206,0.60000000000000009,3.3322460289179963E-2,0.72574688224992645,0.33322460289179967,0.72574688224992645,0,0]
[61,206.6,0.66000000000000014,3.2086380377117259E-2,0.74537308532866375,0.32086380377117246,0.74537308532866398,0,0]
[62,207.2,0.7200000000000002,3.0785126046985321E-2,0.76423750222074849,0.30785126046985289,0.76423750222074893,0,0]
[63,207.8,0.78000000000000025,2.9430502978832485E-2,0.78230456241426727,0.29430502978832507,0.78230456241426705,0,0]
[64,208.4,0.8400000000000003,2.8034381083962043E-2,0.79954580673955056,0.28034381083962051,0.79954580673955045,0,0]
[65,209,0.90000000000000036,{"$f":"NORMDIST(B67,$N$2,$N$3,FALSE)","v":2.6608524989875482E-2},{"$f":"NORMDIST(B67,$N$2,$N$3,TRUE)","v":0.81593987465324047},0.26608524989875476,0.81593987465324058,{"$f":"IF($Y$2>=$C67,$F67,0)","v":0},{"$f":"IF($AH$2<=$C67,$F67,0)","v":0}]
[66,209.6,0.96000000000000041,2.5164434109811729E-2,0.83147239253316196,0.25164434109811701,0.8314723925331623,0,0]
[67,210.20000000000002,1.0200000000000005,2.3713195201937917E-2,0.84613576962726555,0.23713195201937948,0.84613576962726522,0,0]
[68,210.8,1.0800000000000005,2.2265349875176085E-2,0.85992890991123117,0.22265349875176099,0.85992890991123105,0,0]
[69,211.4,1.1400000000000006,2.0830779004710823E-2,0.87285684943720188,0.20830779004710823,0.87285684943720188,0,0]
[70,212,1.2000000000000006,1.9418605498321296E-2,0.88493032977829178,0.19418605498321281,0.88493032977829189,0,0]
[71,212.6,1.2600000000000007,1.803711632270805E-2,0.89616531887869955,0.18037116322708019,0.89616531887869977,0,0]
[72,213.20000000000002,1.3200000000000007,1.6693704174171348E-2,0.90658249100652855,0.16693704174171367,0.90658249100652832,0,0]
[73,213.8,1.3800000000000008,1.5394828676263345E-2,0.91620667758498597,0.15394828676263353,0.91620667758498586,0,0]
[74,214.4,1.4400000000000008,1.4145996522483868E-2,0.92506630046567306,0.14145996522483861,0.92506630046567306,0,0]
[75,215,1.5000000000000009,1.2951759566589173E-2,0.93319279873114191,0.12951759566589155,0.93319279873114214,0,0]
[76,215.60000000000002,1.5600000000000009,1.1815729505958186E-2,0.94062005940520721,0.11815729505958211,0.9406200594052071,0,0]
[77,216.20000000000002,1.620000000000001,1.0740607511348352E-2,0.94738386154574816,0.10740607511348366,0.94738386154574805,0,0]
[78,216.8,1.680000000000001,9.7282269331467313E-3,0.95352134213628004,9.728226933146733E-2,0.95352134213628004,0,0]
[79,217.4,1.7400000000000011,8.7796070610905528E-3,0.95907049102119268,8.7796070610905469E-2,0.95907049102119268,0,0]
[80,218,1.8000000000000012,7.8950158300894139E-3,0.96406968088707423,7.8950158300893997E-2,0.96406968088707434,0,0]
[81,218.60000000000002,1.8600000000000012,7.0740393456983092E-3,0.96855723701924745,7.0740393456983228E-2,0.96855723701924734,0,0]
[82,219.20000000000002,1.9200000000000013,6.3156561435198447E-3,0.97257105029616331,6.3156561435198502E-2,0.97257105029616331,0,0]
[83,{"$f":"$N$2+C85*$N$3","v":219.8},1.9800000000000013,5.6183141903867915E-3,0.97614823565849151,5.6183141903867896E-2,0.97614823565849151,0,0]
[84,220.4,2.0400000000000014,4.9800087735070728E-3,0.97932483713393004,4.9800087735070636E-2,0.97932483713393004,0,0]
[85,221,2.1000000000000014,4.3983595980427196E-3,0.98213557943718344,4.3983595980427052E-2,0.98213557943718355,0,0]
[86,221.60000000000002,2.1600000000000015,3.8706856147455418E-3,0.98461366521607463,3.870685614745549E-2,0.98461366521607463,0,0]
[87,222.20000000000002,2.2200000000000015,3.3940763182449081E-3,0.98679061619274377,3.3940763182449075E-2,0.98679061619274377,0,0]
[88,222.8,2.2800000000000016,2.9654584847341203E-3,0.9886961557614472,2.965458484734116E-2,0.9886961557614472,0,0]
[89,223.4,2.3400000000000016,2.5816575471587638E-3,0.99035813005464168,2.5816575471587579E-2,0.99035813005464168,0,0]
[90,224.00000000000003,2.4000000000000017,2.2394530294842733E-3,0.99180246407540396,2.2394530294842813E-2,0.99180246407540396,0,0]
[91,224.60000000000002,2.4600000000000017,1.9356276731736851E-3,0.99305314921137577,1.9356276731736878E-2,0.99305314921137566,0,0]
[92,225.20000000000002,2.5200000000000018,1.6670100837380985E-3,0.99413225828466745,1.6670100837380984E-2,0.99413225828466745,0,0]
[93,225.8,2.5800000000000018,1.4305108994149658E-3,0.99505998424222941,1.4305108994149626E-2,0.99505998424222941,0,0]
[94,226.40000000000003,2.6400000000000019,1.2231526351277871E-3,0.99585469863896403,1.2231526351277911E-2,0.99585469863896403,0,0]
[95,227.00000000000003,2.700000000000002,1.0420934814422515E-3,0.99653302619695938,1.042093481442254E-2,0.99653302619695938,0,0]
[96,227.60000000000002,2.760000000000002,8.8464543982371628E-4,0.99710993192377384,8.846454398237176E-3,0.99710993192377384,0,0]
[97,228.20000000000002,2.8200000000000021,7.482872525780527E-4,0.99759881752581081,7.482872525780517E-3,0.99759881752581081,0,0]
[98,228.8,2.8800000000000021,6.306726396265905E-4,0.99801162414510569,6.3067263962658885E-3,0.99801162414510569,0,0]
[99,229.40000000000003,2.9400000000000022,5.2963438653109627E-4,0.99835893876584303,5.2963438653109828E-3,0.99835893876584303,0,0]

{"sheet":"Normalverteilung (BocksBeispie)","index":1,"n_rows":103,"n_cols":32,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Zahlenwerte zum Erzeugen der Graphen, vgl. die verwendeten Formeln",null,null,null,null,null,null,null,null,null,null,"Theoretische Verteilungen -- Normalverteilung und Standardnormalverteilung"]
[null,"X","Z","f(x)","F(x)","f(z)","F(z)"," - f(a)","f(b) - ",null,null,"Mittelwert:",null,0.33,null,null,null,null,"links: W(Z < a) für",null,null,null,null,{"$f":"3+V3","v":2},null,null,null,null,"rechts: W(Z > a) für ",null,null,{"$f":"AC3+3","v":5}]
[1,{"$f":"$N$2+C3*$N$3","v":0.23999999999999994},{"$f":"C4-0.06","v":-3.0000000000000022},{"$f":"NORMDIST(B3,$N$2,$N$3,FALSE)","v":0.1477282803979324},{"$f":"NORMDIST(B3,$N$2,$N$3,TRUE)","v":1.3498980316300813E-3},{"$f":"NORMDIST(C3,0,1,0)","v":4.4318484119379763E-3},{"$f":"NORMSDIST(C3)","v":1.3498980316300844E-3},{"$f":"IF($V$3>=$C3,$F3,0)","v":4.4318484119379763E-3},{"$f":"IF($AC$3<=$C3,$F3,0)","v":0},null,null,"Standardabw.:",null,0.03,null,null,null,null,null,null,"a = ",-1,null,null,null,null,null,"b =",2]
[2,0.24179999999999996,-2.9400000000000022,0.17654479551036609,1.6410612341569829E-3,5.2963438653109828E-3,1.6410612341569829E-3,5.2963438653109828E-3,0,null,null,"Dichtefunktion: ",null,null,null,null,null,null,null,null,"F(a)=",{"$f":"NORMSDIST(V3)","v":0.15865525393145699},null,null,null,null,null,null,"1-F(b)=",{"$f":"1-NORMSDIST(AC3)","v":2.2750131948179209E-2},{"$f":"NORMSDIST(AC3)","v":0.97724986805182079}]
[3,0.24359999999999996,-2.8800000000000021,{"$f":"NORMDIST(B5,$N$2,$N$3,FALSE)","v":0.21022421320886295},{"$f":"NORMDIST(B5,$N$2,$N$3,TRUE)","v":1.9883758548943095E-3},{"$f":"NORMDIST(C5,0,1,0)","v":6.3067263962658885E-3},{"$f":"NORMSDIST(C5)","v":1.9883758548943095E-3},6.3067263962658885E-3,0]
[4,0.24539999999999995,-2.8200000000000021,0.24942908419268392,2.4011824741892352E-3,7.482872525780517E-3,2.4011824741892352E-3,7.482872525780517E-3,0]
[5,0.24719999999999998,-2.760000000000002,0.29488181327457291,2.8900680762261304E-3,8.846454398237176E-3,2.890068076226127E-3,8.846454398237176E-3,0]
[6,0.24899999999999994,-2.700000000000002,0.34736449381408424,3.4669738030406426E-3,1.042093481442254E-2,3.4669738030406456E-3,1.042093481442254E-2,0]
[7,0.25079999999999997,-2.6400000000000019,0.40771754504259711,4.1453013610360176E-3,1.2231526351277911E-2,4.1453013610360176E-3,1.2231526351277911E-2,0]
[8,0.25259999999999994,-2.5800000000000018,0.47683696647165313,4.9400157577706031E-3,1.4305108994149626E-2,4.9400157577706169E-3,1.4305108994149626E-2,0]
[9,0.25439999999999996,-2.5200000000000018,0.55567002791269948,5.8677417153325312E-3,1.6670100837380984E-2,5.8677417153325312E-3,1.6670100837380984E-2,0]
[10,0.25619999999999998,-2.4600000000000017,0.64520922439122974,6.9468507886242849E-3,1.9356276731736878E-2,6.9468507886242814E-3,1.9356276731736878E-2,0]
[11,0.25799999999999995,-2.4000000000000017,0.74648434316142598,8.1975359245960791E-3,2.2394530294842813E-2,8.1975359245960878E-3,2.2394530294842813E-2,0]
[12,0.25979999999999998,-2.3400000000000016,0.86055251571958613,9.6418699453582821E-3,2.5816575471587579E-2,9.6418699453582821E-3,2.5816575471587579E-2,0]
[13,0.26159999999999994,-2.2800000000000016,0.98848616157803681,1.1303844238552716E-2,2.965458484734116E-2,1.1303844238552744E-2,2.965458484734116E-2,0]
[14,0.26339999999999997,-2.2200000000000015,1.1313587727483025,1.3209383807256218E-2,3.3940763182449075E-2,1.3209383807256218E-2,3.3940763182449075E-2,0]
[15,0.26519999999999999,-2.1600000000000015,1.2902285382485175,1.5386334783925407E-2,3.870685614745549E-2,1.5386334783925388E-2,3.870685614745549E-2,0]
[16,0.26699999999999996,-2.1000000000000014,1.4661198660142338,1.7864420562816459E-2,4.3983595980427052E-2,1.7864420562816487E-2,4.3983595980427052E-2,0,null,null,null,null,null,null,null,null,"z"]
[17,0.26879999999999998,-2.0400000000000014,1.6600029245023546,2.0675162866069973E-2,4.9800087735070636E-2,2.0675162866069973E-2,4.9800087735070636E-2,0]
[18,0.27059999999999995,-1.9800000000000013,1.8727713967955932,2.3851764341508392E-2,5.6183141903867896E-2,2.3851764341508451E-2,5.6183141903867896E-2,0,null,null,"Verteilungsfunktion: ",null,null,null,null,null,null,"x-Werte: ",null,{"$f":"$N$2-$N$3*2","v":0.27},null,{"$f":"$N$2-$N$3","v":0.30000000000000004},null,{"$f":"B53","v":0.33},null,{"$f":"$N$2+$N$3","v":0.36},null,{"$f":"$N$2+$N$3*2","v":0.39}]
[19,0.27239999999999998,-1.9200000000000013,2.1052187145066155,2.7428949703836712E-2,6.3156561435198502E-2,2.742894970383673E-2,6.3156561435198502E-2,0]
[20,0.2742,-1.8600000000000012,2.3580131152327768,3.1442762980752652E-2,7.0740393456983228E-2,3.144276298075261E-2,7.0740393456983228E-2,0]
[21,0.27599999999999997,-1.8000000000000012,2.6316719433631315,3.593031911292565E-2,7.8950158300893997E-2,3.5930319112925713E-2,7.8950158300893997E-2,0]
[22,0.27779999999999999,-1.7400000000000011,2.9265356870301833,4.0929508978807289E-2,8.7796070610905469E-2,4.0929508978807275E-2,8.7796070610905469E-2,0]
[23,0.27959999999999996,-1.680000000000001,3.242742311048906,4.6478657863719866E-2,9.728226933146733E-2,4.6478657863719915E-2,9.728226933146733E-2,0]
[24,0.28139999999999998,-1.620000000000001,3.5802025037827869,5.2616138454251928E-2,0.10740607511348366,5.2616138454251948E-2,0.10740607511348366,0]
[25,0.28320000000000001,-1.5600000000000009,3.9385765019860748,5.9379940594792985E-2,0.11815729505958211,5.9379940594792902E-2,0.11815729505958211,0]
[26,0.28499999999999998,-1.5000000000000009,4.3172531888630488,6.6807201268857877E-2,0.12951759566589155,6.6807201268857905E-2,0.12951759566589155,0]
[27,0.2868,-1.4400000000000008,4.715332174161289,7.4933699534326922E-2,0.14145996522483861,7.4933699534326922E-2,0.14145996522483861,0]
[28,0.28859999999999997,-1.3800000000000008,5.1316095587544455,8.3793322415013999E-2,0.15394828676263353,8.3793322415014096E-2,0.15394828676263353,0]
[29,0.29039999999999999,-1.3200000000000007,5.5645680580571204,9.3417508993471635E-2,0.16693704174171367,9.3417508993471676E-2,0.16693704174171367,0]
[30,0.29220000000000002,-1.2600000000000007,6.0123721075693437,0.10383468112130037,0.18037116322708019,0.10383468112130027,0.18037116322708019,0]
[31,0.29399999999999998,-1.2000000000000006,6.4728684994404224,0.11506967022170805,0.19418605498321281,0.1150696702217081,0.19418605498321281,0]
[32,0.29580000000000001,-1.1400000000000006,6.9435930015702763,0.12714315056279818,0.20830779004710823,0.12714315056279812,0.20830779004710823,0]
[33,0.29759999999999998,-1.0800000000000005,7.4217832917253617,0.14007109008876872,0.22265349875176099,0.14007109008876895,0.22265349875176099,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Mittelwert z=0 bzw. m"]
[34,{"$f":"$N$2+C36*$N$3","v":0.2994},-1.0200000000000005,{"$f":"NORMDIST(B36,$N$2,$N$3,FALSE)","v":7.9043984006459809},{"$f":"NORMDIST(B36,$N$2,$N$3,TRUE)","v":0.15386423037273469},0.23713195201937948,0.15386423037273475,{"$f":"IF($V$3>=$C36,$F36,0)","v":0.23713195201937948},{"$f":"IF($AC$3<=$C36,$F36,0)","v":0},null,null,"Die Flächen werden als Säulendiagramm erzeugt,  "]
[35,0.30120000000000002,-0.96000000000000041,8.3881447032705729,0.1685276074668379,0.25164434109811701,0.1685276074668377,0,0,null,null,"     bei dem sich die - sehr schmalen - Säulen berühren"]
[36,0.30299999999999999,-0.90000000000000036,8.8695083299584887,0.18406012534675928,0.26608524989875476,0.18406012534675939,0,0,null,null,"     und so als Fläche erscheinen"]
[37,0.30480000000000002,-0.8400000000000003,9.3447936946540189,0.20045419326044966,0.28034381083962051,0.20045419326044961,0,0,null,null,"Die Markierungen nach unten und links in der Verteilungsfunktion"]
[38,0.30659999999999998,-0.78000000000000025,9.8101676596108298,0.21769543758573276,0.29430502978832507,0.21769543758573301,0,0,null,null,"     sind \"Fehlerindikatoren\" (Diagrammelement hinzufügen)"]
[39,0.30840000000000001,-0.7200000000000002,10.261708682328429,0.23576249777925098,0.30785126046985289,0.23576249777925107,0,0,null,null,"Beides anschaulich beschrieben bei Andreas Thehos: "]
[40,0.31020000000000003,-0.66000000000000014,10.695460125705754,0.25462691467133625,0.32086380377117246,0.25462691467133608,0,0,null,null,"     https://www.youtube.com/watch?v=eBKLXe8JGSY"]
[41,0.312,-0.60000000000000009,11.107486763059987,0.27425311775007338,0.33322460289179967,0.27425311775007355,0,0]
[42,0.31380000000000002,-0.54,11.493933381311114,0.2945985162156981,0.34481800143933333,0.29459851621569799,0,0]
[43,0.31559999999999999,-0.48,11.851084283533233,0.31561369651622229,0.35553252850599709,0.31561369651622256,0,0]
[44,0.31740000000000002,-0.42,12.175422420738464,0.33724272684824946,0.36526267262215389,0.33724272684824952,0,0]
[45,0.31920000000000004,-0.36,12.463686845770949,0.35942356678200904,0.37391060537312842,0.35942356678200876,0,0]
[46,0.32100000000000001,-0.3,12.71292718201747,0.38208857781104721,0.38138781546052414,0.38208857781104733,0,0]
[47,0.32280000000000003,-0.24,12.920553837500474,0.4051651283022043,0.38761661512501416,0.40516512830220414,0,0]
[48,0.3246,-0.18,13.084382770680962,0.42857628409909904,0.3925314831204289,0.42857628409909926,0,0]
[49,0.32640000000000002,-0.12,13.202673726455204,0.45224157397941622,0.3960802117936561,0.45224157397941611,0,0]
[50,0.32819999999999999,{"$f":"C53-0.06","v":-0.06},13.274161006520231,0.47607781734589283,{"$f":"NORMDIST(C52,0,1,0)","v":0.39822483019560695},{"$f":"NORMSDIST(C52)","v":0.47607781734589316},0,0]
[51,{"$f":"N2","v":0.33},{"$f":"(B53-$N$2)/$N$3","v":0},13.298076013381092,0.5,{"$f":"NORMDIST(C53,0,1,0)","v":0.3989422804014327},{"$f":"NORMSDIST(C53)","v":0.5},0,0]
[52,{"$f":"$N$2+C54*$N$3","v":0.33180000000000004},{"$f":"C53+0.06","v":0.06},13.274161006520231,0.52392218265410717,{"$f":"NORMDIST(C54,0,1,0)","v":0.39822483019560695},{"$f":"NORMSDIST(C54)","v":0.52392218265410684},0,0]
[53,0.33360000000000001,{"$f":"C54+0.06","v":0.12},13.202673726455204,0.54775842602058378,{"$f":"NORMDIST(C55,0,1,0)","v":0.3960802117936561},{"$f":"NORMSDIST(C55)","v":0.54775842602058389},0,0]
[54,0.33540000000000003,0.18,13.084382770680962,0.57142371590090102,0.3925314831204289,0.5714237159009008,0,0]
[55,0.3372,0.24,12.920553837500474,0.5948348716977957,0.38761661512501416,0.59483487169779581,0,0]
[56,0.33900000000000002,0.3,12.71292718201747,0.61791142218895279,0.38138781546052414,0.61791142218895267,0,0]
[57,0.34079999999999999,0.36,12.463686845770949,0.64057643321799096,0.37391060537312842,0.64057643321799129,0,0]
[58,0.34260000000000002,0.42,12.175422420738464,0.66275727315175059,0.36526267262215389,0.66275727315175048,0,0]
[59,0.34440000000000004,0.48,11.851084283533233,0.68438630348377771,0.35553252850599709,0.68438630348377738,0,0]
[60,0.34620000000000001,0.54,11.493933381311114,0.7054014837843019,0.34481800143933333,0.70540148378430201,0,0]
[61,0.34800000000000003,0.60000000000000009,11.107486763059987,0.72574688224992667,0.33322460289179967,0.72574688224992645,0,0]
[62,0.3498,0.66000000000000014,10.695460125705754,0.74537308532866375,0.32086380377117246,0.74537308532866398,0,0]
[63,0.35160000000000002,0.7200000000000002,10.261708682328429,0.76423750222074904,0.30785126046985289,0.76423750222074893,0,0]
[64,0.35340000000000005,0.78000000000000025,9.8101676596108298,0.78230456241426727,0.29430502978832507,0.78230456241426705,0,0]
[65,0.35520000000000002,0.8400000000000003,9.3447936946540189,0.79954580673955034,0.28034381083962051,0.79954580673955045,0,0]
[66,0.35700000000000004,0.90000000000000036,{"$f":"NORMDIST(B68,$N$2,$N$3,FALSE)","v":8.8695083299584887},{"$f":"NORMDIST(B68,$N$2,$N$3,TRUE)","v":0.81593987465324069},0.26608524989875476,0.81593987465324058,{"$f":"IF($V$3>=$C68,$F68,0)","v":0},{"$f":"IF($AC$3<=$C68,$F68,0)","v":0}]
[67,0.35880000000000001,0.96000000000000041,8.3881447032705729,0.83147239253316207,0.25164434109811701,0.8314723925331623,0,0]
[68,0.36060000000000003,1.0200000000000005,7.9043984006459809,0.84613576962726533,0.23713195201937948,0.84613576962726522,0,0]
[69,0.36240000000000006,1.0800000000000005,7.4217832917253617,0.85992890991123128,0.22265349875176099,0.85992890991123105,0,0]
[70,0.36420000000000002,1.1400000000000006,6.9435930015702763,0.87285684943720176,0.20830779004710823,0.87285684943720188,0,0]
[71,0.36600000000000005,1.2000000000000006,6.4728684994404224,0.884930329778292,0.19418605498321281,0.88493032977829189,0,0]
[72,0.36780000000000002,1.2600000000000007,6.0123721075693437,0.89616531887869966,0.18037116322708019,0.89616531887869977,0,0]
[73,0.36960000000000004,1.3200000000000007,5.5645680580571204,0.90658249100652832,0.16693704174171367,0.90658249100652832,0,0]
[74,0.37140000000000006,1.3800000000000008,5.1316095587544455,0.91620667758498597,0.15394828676263353,0.91620667758498586,0,0]
[75,0.37320000000000003,1.4400000000000008,4.715332174161289,0.92506630046567306,0.14145996522483861,0.92506630046567306,0,0]
[76,0.37500000000000006,1.5000000000000009,4.3172531888630488,0.93319279873114214,0.12951759566589155,0.93319279873114214,0,0]
[77,0.37680000000000002,1.5600000000000009,3.9385765019860748,0.94062005940520699,0.11815729505958211,0.9406200594052071,0,0]
[78,0.37860000000000005,1.620000000000001,3.5802025037827869,0.94738386154574805,0.10740607511348366,0.94738386154574805,0,0]
[79,0.38040000000000007,1.680000000000001,3.242742311048906,0.95352134213628015,9.728226933146733E-2,0.95352134213628004,0,0]
[80,0.38220000000000004,1.7400000000000011,2.9265356870301833,0.95907049102119268,8.7796070610905469E-2,0.95907049102119268,0,0]
[81,0.38400000000000006,1.8000000000000012,2.6316719433631315,0.96406968088707434,7.8950158300893997E-2,0.96406968088707434,0,0]
[82,0.38580000000000003,1.8600000000000012,2.3580131152327768,0.96855723701924734,7.0740393456983228E-2,0.96855723701924734,0,0]
[83,0.38760000000000006,1.9200000000000013,2.1052187145066155,0.97257105029616331,6.3156561435198502E-2,0.97257105029616331,0,0]
[84,{"$f":"$N$2+C86*$N$3","v":0.38940000000000008},1.9800000000000013,1.8727713967955932,0.97614823565849163,5.6183141903867896E-2,0.97614823565849151,0,0]
[85,0.39120000000000005,2.0400000000000014,1.6600029245023546,0.97932483713393004,4.9800087735070636E-2,0.97932483713393004,0,4.9800087735070636E-2]
[86,0.39300000000000007,2.1000000000000014,1.4661198660142338,0.98213557943718355,4.3983595980427052E-2,0.98213557943718355,0,4.3983595980427052E-2]
[87,0.39480000000000004,2.1600000000000015,1.2902285382485175,0.98461366521607463,3.870685614745549E-2,0.98461366521607463,0,3.870685614745549E-2]
[88,0.39660000000000006,2.2200000000000015,1.1313587727483025,0.98679061619274377,3.3940763182449075E-2,0.98679061619274377,0,3.3940763182449075E-2]
[89,0.39840000000000009,2.2800000000000016,0.98848616157803681,0.98869615576144732,2.965458484734116E-2,0.9886961557614472,0,2.965458484734116E-2]
[90,0.40020000000000006,2.3400000000000016,0.86055251571958613,0.99035813005464168,2.5816575471587579E-2,0.99035813005464168,0,2.5816575471587579E-2]
[91,0.40200000000000008,2.4000000000000017,0.74648434316142598,0.99180246407540396,2.2394530294842813E-2,0.99180246407540396,0,2.2394530294842813E-2]
[92,0.40380000000000005,2.4600000000000017,0.64520922439122974,0.99305314921137566,1.9356276731736878E-2,0.99305314921137566,0,1.9356276731736878E-2]
[93,0.40560000000000007,2.5200000000000018,0.55567002791269948,0.99413225828466745,1.6670100837380984E-2,0.99413225828466745,0,1.6670100837380984E-2]
[94,0.4074000000000001,2.5800000000000018,0.47683696647165313,0.99505998424222941,1.4305108994149626E-2,0.99505998424222941,0,1.4305108994149626E-2]
[95,0.40920000000000006,2.6400000000000019,0.40771754504259711,0.99585469863896403,1.2231526351277911E-2,0.99585469863896403,0,1.2231526351277911E-2]
[96,0.41100000000000009,2.700000000000002,0.34736449381408424,0.99653302619695938,1.042093481442254E-2,0.99653302619695938,0,1.042093481442254E-2]
[97,0.41280000000000006,2.760000000000002,0.29488181327457291,0.99710993192377384,8.846454398237176E-3,0.99710993192377384,0,8.846454398237176E-3]
[98,0.41460000000000008,2.8200000000000021,{"$f":"NORMDIST(B100,$N$2,$N$3,FALSE)","v":0.24942908419268392},{"$f":"NORMDIST(B100,$N$2,$N$3,TRUE)","v":0.99759881752581081},{"$f":"NORMDIST(C100,0,1,0)","v":7.482872525780517E-3},{"$f":"NORMSDIST(C100)","v":0.99759881752581081},0,7.482872525780517E-3]
[99,0.4164000000000001,2.8800000000000021,0.21022421320886242,0.99801162414510569,6.3067263962658885E-3,0.99801162414510569,0,6.3067263962658885E-3]
[100,0.41820000000000007,2.9400000000000022,0.17654479551036609,0.99835893876584303,5.2963438653109828E-3,0.99835893876584303,0,5.2963438653109828E-3]
[101,0.4200000000000001,3.0000000000000022,0.1477282803979324,0.9986501019683699,4.4318484119379763E-3,0.9986501019683699,0,4.4318484119379763E-3]

{"sheet":"Konfidenzintervall MW","index":2,"n_rows":111,"n_cols":34,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["Zahlenwerte zum Erzeugen der Graphen, vgl. die verwendeten Formeln",null,null,null,null,null,null,null,null,null,null,null,null,"Konfidenzintervall für den MIttelwert - Standardnormalverteilung des Stichprobenmittels xquer"]
[null,"X","Z","f(x)","-f(gu)","f(go)","F(x)","f(z)","F(z)"," - f(a)","f(b) - ",null,null,"Mittelwert:",null,null,{"$f":"Q40","v":48.5},null,null,null,null,null,"links: W(Z < gu)",null,null,{"$f":"3+X3","v":1.0400360154599464},null,null,null,null,null,"rechts: W(Z > go)",null,{"$f":"AE3+3","v":4.9599639845400532}]
[1,{"$f":"$Q$2+C3*$Q$3","v":48.125},{"$f":"C4-0.06","v":-3.0000000000000022},{"$f":"NORMDIST(B3,$Q$2,$Q$3,FALSE)","v":3.545478729550406E-2},{"$f":"IF(B3<=$AH$45,D3,0)","v":3.545478729550406E-2},{"$f":"IF(B3>=$AH$47,D3,0)","v":0},{"$f":"NORMDIST(B3,$Q$2,$Q$3,TRUE)","v":1.3498980316300933E-3},{"$f":"NORMDIST(C3,0,1,0)","v":4.4318484119379763E-3},{"$f":"NORMSDIST(C3)","v":1.3498980316300844E-3},{"$f":"IF($X$3>=$C3,$H3,0)","v":4.4318484119379763E-3},{"$f":"IF($AE$3<=$C3,$H3,0)","v":0},null,null,"Standardfehler SigmaXquer",null,null,{"$f":"S41","v":0.125},null,null,null,null,null,"gu ",{"$f":"IF(X39<>\"\",-X39,-3)","v":-1.9599639845400536},null,null,null,null,null,"go ",{"$f":"IF(AND(X39<>\"\",O42=2),X39,3)","v":1.9599639845400536}]
[2,48.1325,-2.9400000000000022,4.2370750922488425E-2,{"$f":"IF(B4<=$AH$45,D4,0)","v":4.2370750922488425E-2},{"$f":"IF(B4>=$AH$47,D4,0)","v":0},1.6410612341570059E-3,5.2963438653109828E-3,1.6410612341569829E-3,5.2963438653109828E-3,0,null,null,"Dichtefunktion: ",null,null,null,null,null,null,null,null,"F(a)=",{"$f":"NORMSDIST(X3)","v":2.500000000000004E-2},null,null,null,null,null,null,"1-F(b)=",{"$f":"1-NORMSDIST(AE3)","v":2.5000000000000022E-2},{"$f":"NORMSDIST(AE3)","v":0.97499999999999998}]
[3,48.14,-2.8800000000000021,5.0453811170128052E-2,5.0453811170128052E-2,0,1.9883758548943542E-3,6.3067263962658885E-3,1.9883758548943095E-3,6.3067263962658885E-3,0]
[4,48.147500000000001,-2.8200000000000021,5.9862980206245628E-2,5.9862980206245628E-2,0,2.4011824741893006E-3,7.482872525780517E-3,2.4011824741892352E-3,7.482872525780517E-3,0]
[5,48.155000000000001,-2.760000000000002,7.0771635185899587E-2,7.0771635185899587E-2,0,2.8900680762262241E-3,8.846454398237176E-3,2.890068076226127E-3,8.846454398237176E-3,0]
[6,48.162500000000001,-2.700000000000002,8.3367478515383314E-2,8.3367478515383314E-2,0,3.4669738030407857E-3,1.042093481442254E-2,3.4669738030406456E-3,1.042093481442254E-2,0]
[7,48.17,-2.6400000000000019,9.7852210810227339E-2,9.7852210810227339E-2,0,4.1453013610362049E-3,1.2231526351277911E-2,4.1453013610360176E-3,1.2231526351277911E-2,0]
[8,48.177500000000002,-2.5800000000000018,0.11444087195320224,0.11444087195320224,0,4.9400157577708737E-3,1.4305108994149626E-2,4.9400157577706169E-3,1.4305108994149626E-2,0]
[9,48.185000000000002,-2.5200000000000018,0.13336080669905462,0.13336080669905462,0,5.8677417153328651E-3,1.6670100837380984E-2,5.8677417153325312E-3,1.6670100837380984E-2,0]
[10,48.192500000000003,-2.4600000000000017,0.15485021385390346,0.15485021385390346,0,6.9468507886247055E-3,1.9356276731736878E-2,6.9468507886242814E-3,1.9356276731736878E-2,0]
[11,48.2,-2.4000000000000017,0.17915624235875299,0.17915624235875299,0,8.197535924596636E-3,2.2394530294842813E-2,8.1975359245960878E-3,2.2394530294842813E-2,0]
[12,48.207500000000003,-2.3400000000000016,0.20653260377271357,0.20653260377271357,0,9.6418699453589742E-3,2.5816575471587579E-2,9.6418699453582821E-3,2.5816575471587579E-2,0]
[13,48.214999999999996,-2.2800000000000016,0.23723667877871424,0.23723667877871424,0,1.1303844238551916E-2,2.965458484734116E-2,1.1303844238552744E-2,2.965458484734116E-2,0]
[14,48.222499999999997,-2.2200000000000015,0.27152610545957706,0.27152610545957706,0,1.3209383807255348E-2,3.3940763182449075E-2,1.3209383807256218E-2,3.3940763182449075E-2,0]
[15,48.23,-2.1600000000000015,0.30965484917962827,0.30965484917962827,0,1.5386334783924486E-2,3.870685614745549E-2,1.5386334783925388E-2,3.870685614745549E-2,0]
[16,48.237499999999997,-2.1000000000000014,0.35186876784340082,0.35186876784340082,0,1.786442056281555E-2,4.3983595980427052E-2,1.7864420562816487E-2,4.3983595980427052E-2,0,null,null,null,null,null,null,null,null,"z"]
[17,48.244999999999997,-2.0400000000000014,0.39840070188054955,0.39840070188054955,0,2.0675162866069022E-2,4.9800087735070636E-2,2.0675162866069973E-2,4.9800087735070636E-2,0]
[18,48.252499999999998,-1.9800000000000013,0.44946513523092818,0.44946513523092818,0,2.38517643415075E-2,5.6183141903867896E-2,2.3851764341508451E-2,5.6183141903867896E-2,0,null,null,"Verteilungsfunktion: ",null,null,null,null,null,null,"Xquer-Werte: ",null,{"$f":"$Q$2-$Q$3*2","v":48.25},null,{"$f":"$Q$2-$Q$3","v":48.375},null,{"$f":"B53","v":48.5},null,{"$f":"$Q$2+$Q$3","v":48.625},null,{"$f":"$Q$2+$Q$3*2","v":48.75}]
[19,48.26,-1.9200000000000013,0.5052524914815737,0,0,2.7428949703835796E-2,6.3156561435198502E-2,2.742894970383673E-2,0,0]
[20,48.267499999999998,-1.8600000000000012,0.56592314765585272,0,0,3.1442762980751743E-2,7.0740393456983228E-2,3.144276298075261E-2,0,0]
[21,48.274999999999999,-1.8000000000000012,0.63160126640714032,0,0,3.5930319112924901E-2,7.8950158300893997E-2,3.5930319112925713E-2,0,0]
[22,48.282499999999999,-1.7400000000000011,0.70236856488723398,0,0,4.092950897880656E-2,8.7796070610905469E-2,4.0929508978807275E-2,0,0]
[23,48.29,-1.680000000000001,0.77825815465173098,0,0,4.647865786371938E-2,9.728226933146733E-2,4.6478657863719915E-2,0,0]
[24,48.297499999999999,-1.620000000000001,0.85924860090786426,0,0,5.2616138454251546E-2,0.10740607511348366,5.2616138454251948E-2,0,0]
[25,48.305,-1.5600000000000009,0.94525836047665479,0,0,5.937994059479277E-2,0.11815729505958211,5.9379940594792902E-2,0,0]
[26,48.3125,-1.5000000000000009,1.036140765327134,0,0,6.6807201268858057E-2,0.12951759566589155,6.6807201268857905E-2,0,0]
[27,48.32,-1.4400000000000008,1.1316797217987138,0,0,7.493369953432738E-2,0.14145996522483861,7.4933699534326922E-2,0,0]
[28,48.327500000000001,-1.3800000000000008,1.2315862941010773,0,0,8.3793322415014956E-2,0.15394828676263353,8.3793322415014096E-2,0,0]
[29,48.335000000000001,-1.3200000000000007,1.3354963339337227,0,0,9.3417508993472911E-2,0.16693704174171367,9.3417508993471676E-2,0,0]
[30,48.342500000000001,-1.2600000000000007,1.4429693058166593,0,0,0.10383468112130201,0.18037116322708019,0.10383468112130027,0,0]
[31,48.35,-1.2000000000000006,1.5534884398657247,0,0,0.11506967022171044,0.19418605498321281,0.1150696702217081,0,0]
[32,48.357500000000002,-1.1400000000000006,1.6664623203768927,0,0,0.12714315056280112,0.20830779004710823,0.12714315056279812,0,0]
[33,{"$f":"$Q$2+C35*$Q$3","v":48.365000000000002},-1.0800000000000005,{"$f":"NORMDIST(B35,$Q$2,$Q$3,FALSE)","v":1.7812279900141197},0,0,{"$f":"NORMDIST(B35,$Q$2,$Q$3,TRUE)","v":0.14007109008877255},0.22265349875176099,0.14007109008876895,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Mittelwert z=0 bzw. Xquer"]
[34,48.372500000000002,-1.0200000000000005,1.8970556161550718,0,0,0.15386423037273911,0.23713195201937948,0.15386423037273475,0,0,null,null,"8.2.1 Konfidenzintervall für den Mittelwert"]
[35,48.38,-0.96000000000000041,2.0131547287849765,0,0,0.16852760746684295,0.25164434109811701,0.1685276074668377,0,0,null,null,"NUR die gelb hinterlegten Felder eingeben: (nur entweder s oder s!)",null,null,null,null,null,null,null,null,"Ablesewert zc"]
[36,48.387500000000003,-0.90000000000000036,2.1286819991900821,0,0,0.18406012534676552,0.26608524989875476,0.18406012534675939,0,0,null,null,"Vorgegebene Werte: ",null,"(Eingerahmte Felder werden errechnet)",null,null,null,null,null,null,{"$f":"IF(O42=2,\"1-a/2\",IF(O42=1,\"1-a\",\"------\"))","v":"1-a/2"},{"$f":"IF(O42=2,1-O41/2,IF(O42=1,1-O41,\"Seiten eingeben! 1 oder 2!\"))","v":0.97499999999999998}]
[37,48.395000000000003,-0.8400000000000003,2.2427504867170116,0,0,0.20045419326045666,0.28034381083962051,0.20045419326044961,0,0,null,null,"s",null,"s",1," --> s oder s:",{"$f":"IF(AND(O39>0,Q39=0),O39,IF(AND(O39=0,Q39>0),Q39,\" - ??? -\"))","v":1},null,null,null,"kritisches |zc|",{"$f":"NORMINV(X38,0,1)","v":1.9599639845400536}]
[38,48.402500000000003,-0.78000000000000025,2.3544402383066516,0,0,0.21769543758574114,0.29430502978832507,0.21769543758573301,0,0,null,null,null,null,"x_quer",48.5,"daraus errechnet: "]
[39,48.41,-0.7200000000000002,2.4628100837587752,0,0,0.2357624977792428,0.30785126046985289,0.23576249777925107,0,0,null,null,"a",0.05,"n",64,"Sigma Xquer",{"$f":"IF(AND(Q41>0,Q42>0,Q43>0.05),\n(S39/(Q41^0.5))*SQRT((Q42-Q41)/(Q42-1)),\nS39/(Q41^0.5))","v":0.125},null,"Konfidenzintervall -> Formel (8-17)"]
[40,48.417499999999997,-0.66000000000000014,2.5669104301693375,0,0,0.25462691467132809,0.32086380377117246,0.25462691467133608,0,0,null,null,"Seiten:",2,"N",null,null,null,null,"Es geht um die (unbekannte) Lage des wahren Mittelwertes m bei bekanntem Xquer"]
[41,48.424999999999997,-0.60000000000000009,2.6657968231343605,0,0,0.274253117750066,0.33322460289179967,0.27425311775007355,0,0,null,null,null,null,"n/N",{"$f":"IF(AND(Q41>0,Q42>0),Q41/Q42,\" -- \")","v":" -- "},{"$f":"IF(AND(Q41>0,Q42>0,Q43>0.05),\"Endlichkeitskorrektur !!\",\" (o.k.) \")","v":" (o.k.) "}]
[42,48.432499999999997,-0.54,2.7585440115146365,0,0,0.29459851621569094,0.34481800143933333,0.29459851621569799,0,0,null,null,null,null,null,null,null,null,null,"gu = Xquer - Zc * s_Xquer  ="]
[43,48.44,-0.48,2.8442602280479519,0,0,0.31561369651621607,0.35553252850599709,0.31561369651622256,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(",{"$f":"Q40","v":48.5},"--",{"$f":"X39","v":1.9599639845400536},"*",{"$f":"S41","v":0.125},")"," =",{"$f":"AA45-AC45*AE45","v":48.25500450193249}]
[44,48.447499999999998,-0.42,2.9221013809772116,0,0,0.33724272684824363,0.36526267262215389,0.33724272684824952,0,0,null,null,null,null,null,null,null,null,null,"go = Xquer + Zc * s_Xquer  ="]
[45,48.454999999999998,-0.36,2.9912848429850123,0,0,0.35942356678200366,0.37391060537312842,0.35942356678200876,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(",{"$f":"AA45","v":48.5},"+",{"$f":"AC45","v":1.9599639845400536},"*",{"$f":"AE45","v":0.125},")"," =",{"$f":"AA45+AC45*AE45","v":48.74499549806751}]
[46,48.462499999999999,-0.3,3.0511025236841824,0,0,0.382088577811043,0.38138781546052414,0.38208857781104733,0,0]
[47,48.47,-0.24,3.1009329210001066,0,0,0.40516512830220064,0.38761661512501416,0.40516512830220414,0,0]
[48,48.477499999999999,-0.18,3.1402518649634272,0,0,0.42857628409909659,0.3925314831204289,0.42857628409909926,0,0]
[49,48.484999999999999,-0.12,3.168641694349247,0,0,0.45224157397941434,0.3960802117936561,0.45224157397941611,0,0]
[50,48.4925,{"$f":"C53-0.06","v":-0.06},3.1857986415648547,0,0,0.47607781734589227,{"$f":"NORMDIST(C52,0,1,0)","v":0.39822483019560695},{"$f":"NORMSDIST(C52)","v":0.47607781734589316},0,0]
[51,{"$f":"Q2","v":48.5},{"$f":"(B53-$Q$2)/$Q$3","v":0},3.1915382432114616,0,0,0.5,{"$f":"NORMDIST(C53,0,1,0)","v":0.3989422804014327},{"$f":"NORMSDIST(C53)","v":0.5},0,0]
[52,{"$f":"$Q$2+C54*$Q$3","v":48.5075},{"$f":"C53+0.06","v":0.06},3.1857986415648547,0,0,0.52392218265410773,{"$f":"NORMDIST(C54,0,1,0)","v":0.39822483019560695},{"$f":"NORMSDIST(C54)","v":0.52392218265410684},0,0]
[53,48.515000000000001,{"$f":"C54+0.06","v":0.12},3.168641694349247,0,0,0.54775842602058566,{"$f":"NORMDIST(C55,0,1,0)","v":0.3960802117936561},{"$f":"NORMSDIST(C55)","v":0.54775842602058389},0,0]
[54,48.522500000000001,0.18,3.1402518649634272,0,0,0.57142371590090346,0.3925314831204289,0.5714237159009008,0,0]
[55,48.53,0.24,3.1009329210001066,0,0,0.59483487169779936,0.38761661512501416,0.59483487169779581,0,0]
[56,48.537500000000001,0.3,3.0511025236841824,0,0,0.617911422188957,0.38138781546052414,0.61791142218895267,0,0]
[57,48.545000000000002,0.36,2.9912848429850123,0,0,0.6405764332179964,0.37391060537312842,0.64057643321799129,0,0]
[58,48.552500000000002,0.42,2.9221013809772116,0,0,0.66275727315175637,0.36526267262215389,0.66275727315175048,0,0]
[59,48.56,0.48,2.8442602280479519,0,0,0.68438630348378393,0.35553252850599709,0.68438630348377738,0,0]
[60,48.567500000000003,0.54,2.7585440115146365,0,0,0.705401483784309,0.34481800143933333,0.70540148378430201,0,0]
[61,48.575000000000003,0.60000000000000009,2.6657968231343605,0,0,0.725746882249934,0.33322460289179967,0.72574688224992645,0,0]
[62,48.582500000000003,0.66000000000000014,2.5669104301693375,0,0,0.74537308532867197,0.32086380377117246,0.74537308532866398,0,0]
[63,48.59,0.7200000000000002,2.4628100837587752,0,0,0.76423750222075726,0.30785126046985289,0.76423750222074893,0,0]
[64,48.597499999999997,0.78000000000000025,2.3544402383066516,0,0,0.78230456241425883,0.29430502978832507,0.78230456241426705,0,0]
[65,48.604999999999997,0.8400000000000003,{"$f":"NORMDIST(B67,$Q$2,$Q$3,FALSE)","v":2.2427504867170116},0,0,{"$f":"NORMDIST(B67,$Q$2,$Q$3,TRUE)","v":0.79954580673954334},0.28034381083962051,0.79954580673955045,{"$f":"IF($X$3>=$C67,$H67,0)","v":0},{"$f":"IF($AE$3<=$C67,$H67,0)","v":0}]
[66,48.612499999999997,0.90000000000000036,2.1286819991900821,{"$f":"IF(B68<=$AH$45,D68,0)","v":0},{"$f":"IF(B68>=$AH$47,D68,0)","v":0},0.81593987465323448,0.26608524989875476,0.81593987465324058,0,0]
[67,48.62,0.96000000000000041,2.0131547287849765,0,0,0.83147239253315708,0.25164434109811701,0.8314723925331623,0,0]
[68,48.627499999999998,1.0200000000000005,1.8970556161550718,0,0,0.84613576962726089,0.23713195201937948,0.84613576962726522,0,0]
[69,48.634999999999998,1.0800000000000005,1.7812279900141197,0,0,0.8599289099112275,0.22265349875176099,0.85992890991123105,0,0]
[70,48.642499999999998,1.1400000000000006,1.6664623203768927,0,0,0.87285684943719888,0.20830779004710823,0.87285684943720188,0,0]
[71,48.65,1.2000000000000006,1.5534884398657247,0,0,0.88493032977828956,0.19418605498321281,0.88493032977829189,0,0]
[72,48.657499999999999,1.2600000000000007,1.4429693058166593,0,0,0.89616531887869799,0.18037116322708019,0.89616531887869977,0,0]
[73,48.664999999999999,1.3200000000000007,1.3354963339337227,0,0,0.9065824910065271,0.16693704174171367,0.90658249100652832,0,0]
[74,48.672499999999999,1.3800000000000008,1.2315862941010773,0,0,0.91620667758498509,0.15394828676263353,0.91620667758498586,0,0]
[75,48.68,1.4400000000000008,1.1316797217987138,0,0,0.92506630046567262,0.14145996522483861,0.92506630046567306,0,0]
[76,48.6875,1.5000000000000009,1.036140765327134,0,0,0.93319279873114191,0.12951759566589155,0.93319279873114214,0,0]
[77,48.695,1.5600000000000009,0.94525836047665479,0,0,0.94062005940520721,0.11815729505958211,0.9406200594052071,0,0]
[78,48.702500000000001,1.620000000000001,0.85924860090786426,0,0,0.9473838615457485,0.10740607511348366,0.94738386154574805,0,0]
[79,48.71,1.680000000000001,0.77825815465173098,0,0,0.95352134213628059,9.728226933146733E-2,0.95352134213628004,0,0]
[80,48.717500000000001,1.7400000000000011,0.70236856488723398,0,0,0.95907049102119346,8.7796070610905469E-2,0.95907049102119268,0,0]
[81,48.725000000000001,1.8000000000000012,0.63160126640714032,0,0,0.96406968088707512,7.8950158300893997E-2,0.96406968088707434,0,0]
[82,48.732500000000002,1.8600000000000012,0.56592314765585272,0,0,0.96855723701924823,7.0740393456983228E-2,0.96855723701924734,0,0]
[83,48.74,1.9200000000000013,0.5052524914815737,0,0,0.9725710502961642,6.3156561435198502E-2,0.97257105029616331,0,0]
[84,{"$f":"$Q$2+C86*$Q$3","v":48.747500000000002},1.9800000000000013,0.44946513523092818,0,0.44946513523092818,0.97614823565849251,5.6183141903867896E-2,0.97614823565849151,0,5.6183141903867896E-2]
[85,48.755000000000003,2.0400000000000014,0.39840070188054955,0,0.39840070188054955,0.97932483713393093,4.9800087735070636E-2,0.97932483713393004,0,4.9800087735070636E-2]
[86,48.762500000000003,2.1000000000000014,0.35186876784340082,0,0.35186876784340082,0.98213557943718444,4.3983595980427052E-2,0.98213557943718355,0,4.3983595980427052E-2]
[87,48.77,2.1600000000000015,0.30965484917962827,0,0.30965484917962827,0.98461366521607552,3.870685614745549E-2,0.98461366521607463,0,3.870685614745549E-2]
[88,48.777500000000003,2.2200000000000015,0.27152610545957706,0,0.27152610545957706,0.98679061619274466,3.3940763182449075E-2,0.98679061619274377,0,3.3940763182449075E-2]
[89,48.785000000000004,2.2800000000000016,0.23723667877871424,0,0.23723667877871424,0.98869615576144809,2.965458484734116E-2,0.9886961557614472,0,2.965458484734116E-2]
[90,48.792499999999997,2.3400000000000016,0.20653260377271357,0,0.20653260377271357,0.99035813005464102,2.5816575471587579E-2,0.99035813005464168,0,2.5816575471587579E-2]
[91,48.8,2.4000000000000017,0.17915624235875299,0,0.17915624235875299,0.9918024640754034,2.2394530294842813E-2,0.99180246407540396,0,2.2394530294842813E-2]
[92,48.807499999999997,2.4600000000000017,0.15485021385390346,0,0.15485021385390346,0.99305314921137533,1.9356276731736878E-2,0.99305314921137566,0,1.9356276731736878E-2]
[93,48.814999999999998,2.5200000000000018,0.13336080669905462,0,0.13336080669905462,0.99413225828466711,1.6670100837380984E-2,0.99413225828466745,0,1.6670100837380984E-2]
[94,48.822499999999998,2.5800000000000018,0.11444087195320224,0,0.11444087195320224,0.99505998424222908,1.4305108994149626E-2,0.99505998424222941,0,1.4305108994149626E-2]
[95,48.83,2.6400000000000019,9.7852210810227339E-2,0,9.7852210810227339E-2,0.99585469863896381,1.2231526351277911E-2,0.99585469863896403,0,1.2231526351277911E-2]
[96,48.837499999999999,2.700000000000002,8.3367478515383314E-2,0,8.3367478515383314E-2,0.99653302619695916,1.042093481442254E-2,0.99653302619695938,0,1.042093481442254E-2]
[97,48.844999999999999,2.760000000000002,7.0771635185899587E-2,0,7.0771635185899587E-2,0.99710993192377373,8.846454398237176E-3,0.99710993192377384,0,8.846454398237176E-3]
[98,48.852499999999999,2.8200000000000021,5.9862980206245628E-2,0,5.9862980206245628E-2,0.9975988175258107,7.482872525780517E-3,0.99759881752581081,0,7.482872525780517E-3]
[99,48.86,2.8800000000000021,5.0453811170128052E-2,0,5.0453811170128052E-2,0.99801162414510569,6.3067263962658885E-3,0.99801162414510569,0,6.3067263962658885E-3]
[100,48.8675,2.9400000000000022,4.2370750922488425E-2,0,4.2370750922488425E-2,0.99835893876584303,5.2963438653109828E-3,0.99835893876584303,0,5.2963438653109828E-3]
[101,48.875,3.0000000000000022,3.545478729550406E-2,0,3.545478729550406E-2,0.9986501019683699,4.4318484119379763E-3,0.9986501019683699,0,4.4318484119379763E-3]
[]
["Die Flächen werden als Säulendiagramm erzeugt,  "]
["     bei dem sich die - sehr schmalen - Säulen berühren"]
["     und so als Fläche erscheinen"]
["Die Markierungen nach unten und links in der Verteilungsfunktion"]
["     sind \"Fehlerindikatoren\" (Diagrammelement hinzufügen)"]
["Beides anschaulich beschrieben bei Andreas Thehos: "]
["     https://www.youtube.com/watch?v=eBKLXe8JGSY"]