{"text_format":"3","workbook":"xls","n_sheets":12,"sheets":["Üb1","LÜb1","Üb2","LÜb2","Üb3","LÜb3","Üb4","LÜb4","Ü5","Ü6","Üb7","LÜb7"],"not_rendered":{"charts":10,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Üb1","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"flags":["formulas_cached_only"]}
["Gewinne"]
[12.1]
[13.8]
[35.1]
[19.3]
[17.8]
[17.9]
[7]
[13.3]
[14.2]
[20.9]

{"sheet":"LÜb1","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"flags":["formulas_cached_only"]}
["Gewinne geordnet (xi)","i/n","geschätztes F(xi) (Normalverteilung)",null,null,"Mittelwert",17.139999999999997]
[7,0.1,0.08795128322009749,null,null,"Standardabweichung",7.491802927941394]
[12.1,0.2,0.2505578652158795,null,null,"Anzahl Daten",10]
[13.3,0.3,0.30412950017384865]
[13.8,0.4,0.32786342378420963]
[14.2,0.5,0.3473706670937572]
[17.8,0.6,0.5350999251660415]
[17.9,0.7,0.5404010769584433]
[19.3,0.8,0.6134472297999216]
[20.9,0.9,0.6921246874886775]
[35.1,1,0.9917415042486548]
[]
[null,"Für Zeichnung der Geraden"]
[null,0,0]
[null,1,1]

{"sheet":"Üb2","index":2,"n_rows":41,"n_cols":1,"rows_kept":41,"flags":["formulas_cached_only"]}
["Daten"]
[16.70907638559619]
[20.350330975381496]
[9.497577028527282]
[13.081970075809675]
[15.83240888414205]
[11.051844365561031]
[14.247201405796902]
[19.17879614564309]
[15.835597690861643]
[6.965583614391862]
[9.689127870429957]
[17.014691474676173]
[18.045581110609177]
[7.130735422777723]
[12.26201709775952]
[14.05560590512776]
[20.469346938779296]
[10.47595629361775]
[3.4907924599717877]
[17.024867175584546]
[8.07377958987718]
[8.512564869953952]
[5.702293963253901]
[15.608944318877969]
[15.450264852216936]
[6.261853944374282]
[8.849912754433532]
[9.586220903646687]
[13.93613823996368]
[22.37211574348239]
[13.245183749164376]
[10.220591834025425]
[9.883632857972618]
[16.98501752361934]
[9.366541403541246]
[11.463126403542876]
[8.938093111689284]
[12.762011309150529]
[13.964701655871899]
[12.008027206973924]

{"sheet":"LÜb2","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"flags":["formulas_cached_only"]}
["Daten geordnet (xi)","i/n","geschätztes F(xi) (Normalverteilung)",null,null,"Mittelwert",12.640003113916922]
[3.4907924599717877,0.025,0.019691864845345908,null,null,"Standardabweichung",4.441030338607575]
[5.702293963253901,0.05,0.059122255108424726,null,null,"Anzahl",40]
[6.261853944374282,0.075,0.07547459643867038]
[6.965583614391862,0.1,0.10067304430743462]
[7.130735422777723,0.125,0.10738820083793366]
[8.07377958987718,0.15,0.15193020211923636]
[8.512564869953952,0.175,0.17634414239953178]
[8.849912754433532,0.2,0.1967115789812619]
[8.938093111689284,0.225,0.2022616466382191]
[9.366541403541246,0.25,0.23053225877720962]
[9.497577028527282,0.275,0.2396001321929322]
[9.586220903646687,0.3,0.24584315254639644]
[9.689127870429957,0.325,0.25319881925414234]
[9.883632857972618,0.35,0.267411649399408]
[10.220591834025425,0.375,0.2929503445166062]
[10.47595629361775,0.4,0.31302823978684]
[11.051844365561031,0.425,0.36031743765734436]
[11.463126403542876,0.45,0.39550441254688185]
[12.008027206973924,0.475,0.4434199857526059]
[12.26201709775952,0.5,0.4660860818893081]
[12.762011309150529,0.525,0.5109587419359877]
[13.081970075809675,0.55,0.539636904204268]
[13.245183749164376,0.575,0.5541962077823966]
[13.93613823996368,0.6,0.6148011009725705,null,null,"Für Gerade"]
[13.964701655871899,0.625,0.6172576731005721,null,null,0,0]
[14.05560590512776,0.65,0.6250440327309088,null,null,1,1]
[14.247201405796902,0.675,0.641285729216426]
[15.450264852216936,0.7,0.7365662348026699]
[15.608944318877969,0.725,0.7481008358365903]
[15.83240888414205,0.75,0.763881322521441]
[15.835597690861643,0.775,0.76410249679945]
[16.70907638559619,0.8,0.8202308803467504]
[16.98501752361934,0.825,0.8360567444387863]
[17.014691474676173,0.85,0.8377030880297804]
[17.024867175584546,0.875,0.8382651603919546]
[18.045581110609177,0.9,0.8882340449207644]
[19.17879614564309,0.925,0.9295380827670621]
[20.350330975381496,0.95,0.9587319998162298]
[20.469346938779296,0.975,0.9610460966185692]
[22.37211574348239,1,0.9857888858365031]

{"sheet":"Üb3","index":4,"n_rows":43,"n_cols":1,"rows_kept":43,"flags":["formulas_cached_only"]}
["Schraubenlängen"]
[0.5282895059031182]
[1.1405457367330103]
[2.4166619245482264]
[2.573463066433652]
[5.218897139098586]
[1.9897445097989725]
[2.3650695178566314]
[0.137639198019117]
[0.8809237998067098]
[0.10367222113911]
[0.7843098276636913]
[0.3230772103180806]
[0.38162831344721654]
[0.5893029024456412]
[1.9223567685124006]
[0.5723521064167196]
[0.8926006314619815]
[3.8534630863071837]
[0.09012127433055564]
[5.300147092316856]
[1.0109890641522588]
[0.24083928898605142]
[1.0902878984006572]
[1.0378859712682769]
[0.5755813765044268]
[0.6057819819890634]
[2.0368180957264017]
[0.3720153715940076]
[0.3416272462233839]
[0.76487449833579]
[0.8849497310842627]
[2.8879131120296235]
[1.5185819609894997]
[0.0034030218266139964]
[4.764494157007251]
[0.7487179011444062]
[0.030092790263721886]
[4.172056646118265]
[2.076081801835833]
[0.26855188398209684]
[2.065174583]
[0.28651883982097]

{"sheet":"LÜb3","index":5,"n_rows":43,"n_cols":8,"rows_kept":43,"flags":["formulas_cached_only"]}
["Schraubenlängen georndet (xi)","i/n","geschätztes F(xi) (Exponentialverteilung)",{"$nulls":3},"Mittelwert",1.4249405489247695]
[0.0034030218266139964,0.023809523809523808,0.002385335682254186,{"$nulls":3},"Anzahl",42]
[0.030092790263721886,0.047619047619047616,0.020897191938816895,{"$nulls":3},"geschätztes Lamda",0.7017836644164412]
[0.09012127433055564,0.0714285714285714,0.06128713831607757]
[0.10367222113911,0.0952380952380952,0.07017182804980937]
[0.137639198019117,0.119047619047619,0.09207448960247677]
[0.24083928898605142,0.142857142857143,0.1555055196557491]
[0.26855188398209684,0.166666666666667,0.17177077839892074]
[0.28651883982097,0.190476190476191,0.1821482891020597]
[0.3230772103180806,0.214285714285714,0.20286426600171492]
[0.3416272462233839,0.238095238095238,0.21317421476609244]
[0.3720153715940076,0.261904761904762,0.22977631836982426]
[0.38162831344721654,0.285714285714286,0.23495491806354485]
[0.5282895059031182,0.30952380952381,0.309780037061682]
[0.5723521064167196,0.333333333333334,0.33079668658727535]
[0.5755813765044268,0.357142857142857,0.33231155074607355]
[0.5893029024456412,0.380952380952381,0.3387102276052434]
[0.6057819819890634,0.404761904761905,0.34631382612800765]
[0.7487179011444062,0.428571428571429,0.40870367558267084]
[0.76487449833579,0.452380952380953,0.4153701857831258]
[0.7843098276636913,0.476190476190476,0.42329004984082974]
[0.8809237998067098,0.5,0.46109605429842626]
[0.8849497310842627,0.523809523809524,0.4626164884171696]
[0.8926006314619815,0.547619047619048,0.4654941169884471]
[1.0109890641522588,0.571428571428572,0.5081077596341813]
[1.0378859712682769,0.595238095238095,0.517305543221301]
[1.0902878984006572,0.619047619047619,0.5347341129062042,null,null,"Für Gerade"]
[1.1405457367330103,0.642857142857143,0.5508580824947664,null,null,0,0]
[1.5185819609894997,0.666666666666667,0.6555188866160473,null,null,1,1]
[1.9223567685124006,0.690476190476191,0.7405207594151382]
[1.9897445097989725,0.714285714285714,0.7525063102700973]
[2.0368180957264017,0.738095238095238,0.7605488062849158]
[2.065174583,0.761904761904762,0.7652668135130105]
[2.076081801835833,0.785714285714286,0.7670567213960453]
[2.3650695178566314,0.80952380952381,0.8098167414222991]
[2.4166619245482264,0.833333333333334,0.8165794840780305]
[2.573463066433652,0.857142857142857,0.835692292023694]
[2.8879131120296235,0.880952380952381,0.8682290704715686]
[3.8534630863071837,0.904761904761905,0.9330826795930359]
[4.172056646118265,0.928571428571429,0.9464897043353995]
[4.764494157007251,0.952380952380952,0.9646919455116327]
[5.218897139098586,0.976190476190476,0.9743326817175034]
[5.300147092316856,1,0.9757552856036286]

{"sheet":"Üb4","index":6,"n_rows":89,"n_cols":1,"rows_kept":89,"flags":["formulas_cached_only"]}
["Gewinne pro Quadratmeter in Filialen"]
[12.22]
[14.19]
[12.1]
[15.77]
[14.13]
[11.56]
[15.17]
[17.27]
[14.12]
[14.25]
[11.79]
[15.56]
[13.31]
[14.3]
[15.66]
[11.33]
[13.22]
[14.73]
[10.63]
[17.63]
[13.48]
[11.03]
[11.24]
[10.56]
[10.09]
[13.58]
[15.85]
[12.92]
[16.45]
[17.39]
[17.47]
[13.67]
[13.18]
[11.78]
[15.4]
[14.25]
[11.19]
[12.16]
[17.97]
[13.03]
[15.36]
[11.69]
[11.99]
[11.56]
[15.02]
[11.42]
[16.94]
[16.21]
[14.01]
[12.52]
[10.53]
[15.12]
[16.92]
[13.77]
[16.11]
[17.6]
[12.78]
[15.73]
[13.61]
[11.14]
[17.15]
[15.39]
[12.89]
[14.49]
[12.65]
[12.2]
[15.77]
[13.2]
[14.89]
[13.52]
[13.45]
[11.29]
[10.82]
[10.88]
[10.7]
[12.21]
[17.39]
[17.14]
[13.77]
[15.42]
[12.69]
[16.07]
[11.28]
[13.86]
[15.19]
[15.14]
[12.82]
[16.52]

{"sheet":"LÜb4","index":7,"n_rows":89,"n_cols":11,"rows_kept":89,"flags":["formulas_cached_only"]}
["Gewinne pro Quadratmeter in Filialen geordnet (xi)","i/n","geschätze F(xi) (uniforme Verteilung)",{"$nulls":3},"Maximaler Wert",17.97]
[10.09,0.011363636363636364,0,{"$nulls":3},"Minimaler Wert",10.09]
[10.53,0.022727272727272728,0.055837563451776484,{"$nulls":3},"Anzahl Daten",88]
[10.56,0.0340909090909091,0.05964467005076135]
[10.63,0.0454545454545455,0.06852791878172582]
[10.7,0.0568181818181819,0.07741116751269006,{"$nulls":3},"geschätzte Steigung a der Verteilungsfunktion (Geraden)",{"$nulls":3},0.1269035532994924]
[10.82,0.0681818181818182,0.0926395939086293,{"$nulls":3},"geschätzter Ordinatenabschnitt b",{"$nulls":3},-1.2804568527918785]
[10.88,0.0795454545454546,0.10025380710659904,{"$nulls":7},"y=ax+b"]
[11.03,0.0909090909090909,0.1192893401015227]
[11.14,0.102272727272727,0.133248730964467]
[11.19,0.113636363636363,0.13959390862944154]
[11.24,0.125,0.1459390862944161]
[11.28,0.136363636363636,0.1510152284263957]
[11.29,0.147727272727272,0.15228426395939065]
[11.33,0.159090909090909,0.15736040609137047]
[11.42,0.170454545454545,0.16878172588832485]
[11.56,0.181818181818181,0.18654822335025378,null,"Gerade"]
[11.56,0.193181818181818,0.18654822335025378,null,0,0]
[11.69,0.204545454545454,0.20304568527918776,null,1,1]
[11.78,0.215909090909091,0.21446700507614191]
[11.79,0.227272727272727,0.21573604060913687]
[11.99,0.238636363636363,0.24111675126903553]
[12.1,0.25,0.2550761421319796]
[12.16,0.261363636363636,0.2626903553299491]
[12.2,0.272727272727272,0.2677664974619287]
[12.21,0.284090909090909,0.2690355329949239]
[12.22,0.295454545454545,0.27030456852791884]
[12.52,0.306818181818181,0.3083756345177664]
[12.65,0.318181818181818,0.3248730964467006]
[12.69,0.329545454545454,0.32994923857867997]
[12.78,0.340909090909091,0.34137055837563435]
[12.82,0.352272727272727,0.34644670050761417]
[12.89,0.363636363636363,0.35532994923857864]
[12.92,0.375,0.3591370558375633]
[13.03,0.386363636363636,0.37309644670050757]
[13.18,0.397727272727272,0.39213197969543145]
[13.2,0.409090909090909,0.39467005076142114]
[13.22,0.420454545454545,0.3972081218274113]
[13.31,0.431818181818181,0.40862944162436543]
[13.45,0.443181818181818,0.42639593908629436]
[13.48,0.454545454545454,0.43020304568527923]
[13.52,0.465909090909091,0.43527918781725883]
[13.58,0.477272727272727,0.44289340101522834]
[13.61,0.488636363636363,0.446700507614213]
[13.67,0.5,0.4543147208121827]
[13.77,0.511363636363636,0.4670050761421318]
[13.77,0.522727272727272,0.4670050761421318]
[13.86,0.534090909090909,0.4784263959390862]
[14.01,0.545454545454545,0.4974619289340101]
[14.12,0.556818181818181,0.5114213197969542]
[14.13,0.568181818181818,0.5126903553299493]
[14.19,0.579545454545454,0.5203045685279186]
[14.25,0.590909090909091,0.5279187817258884]
[14.25,0.602272727272727,0.5279187817258884]
[14.3,0.613636363636363,0.5342639593908629]
[14.49,0.625,0.5583756345177664]
[14.73,0.636363636363636,0.5888324873096447]
[14.89,0.647727272727272,0.6091370558375635]
[15.02,0.659090909090909,0.6256345177664975]
[15.12,0.670454545454545,0.6383248730964466]
[15.14,0.681818181818182,0.6408629441624365]
[15.17,0.693181818181818,0.6446700507614214]
[15.19,0.704545454545454,0.647208121827411]
[15.36,0.715909090909091,0.6687817258883249]
[15.39,0.727272727272727,0.6725888324873097]
[15.4,0.738636363636363,0.6738578680203047]
[15.42,0.75,0.6763959390862944]
[15.56,0.761363636363636,0.6941624365482233]
[15.66,0.772727272727272,0.7068527918781726]
[15.73,0.784090909090909,0.7157360406091371]
[15.77,0.795454545454545,0.7208121827411169]
[15.77,0.806818181818182,0.7208121827411169]
[15.85,0.818181818181818,0.7309644670050761]
[16.07,0.829545454545454,0.7588832487309647]
[16.11,0.840909090909091,0.7639593908629441]
[16.21,0.852272727272727,0.7766497461928936]
[16.45,0.863636363636363,0.8071065989847717]
[16.52,0.875,0.8159898477157359]
[16.92,0.886363636363636,0.8667512690355332]
[16.94,0.897727272727272,0.8692893401015231]
[17.14,0.909090909090909,0.8946700507614214]
[17.15,0.920454545454545,0.8959390862944159]
[17.27,0.931818181818182,0.9111675126903553]
[17.39,0.943181818181818,0.9263959390862944]
[17.39,0.954545454545454,0.9263959390862944]
[17.47,0.965909090909091,0.9365482233502536]
[17.6,0.977272727272727,0.953045685279188]
[17.63,0.988636363636363,0.9568527918781724]
[17.97,1,1]

{"sheet":"Ü5","index":8,"n_rows":52,"n_cols":12,"rows_kept":52,"flags":["formulas_cached_only"]}
["Lösungsvorschlag für Übung 4 (die erste Spalte mit Zufallszahlen wird nicht fixiert; die können kopiert und in die zweite Spalte eingefügt werden (Werte einfügen; dann ordnen). Dadurch wird jeweils ein neues Beispiel produziert)"]
["Uniform verteilte Zufallszahlen mit den Parametern 0 und 5","fixierte und geordnete Zufallszahlen","i/n","F(xi)","geschätzte F(xi)",null,"Maximum",4.812190468820168]
[4.75892803368101,0.020098368218317564,0.02,0.004019673643663513,1.4051260155412137e-16,null,"Minimim",0.020098368218317564,null,null,"Gerade"]
[3.8168726581002344,0.1077643809276907,0.04,0.02155287618553814,0.018293891450534436,null,"Anzahl",50,null,null,0,0]
[3.2357791313852635,0.14568841454251857,0.06,0.029137682908503715,0.026207769735566752,{"$nulls":5},1,1]
[4.702612672853031,0.16065722887265377,0.08,0.032131445774530754,0.029331418867488745,null,null,"Steigung der theoretischen Verteilung, aus der die Daten stammen",0.2]
[3.445023928952171,0.24547604227461828,0.1,0.049095208454923656,0.0470311649536109,null,null,"Ordinatenabschnitt der theoretischen Vertrilung, aus der die Daten stammen",0]
[3.7765695468315696,0.33999109792599874,0.12,0.06799821958519975,0.06675429499101358]
[1.948749299763426,0.3894593816233971,0.14,0.07789187632467942,0.07707719418804394]
[2.083938555016158,0.39231582785523633,0.16,0.07846316557104727,0.07767326917405694]
[0.7047678115703715,0.40700887759316906,0.18,0.08140177551863381,0.08073937254383302]
[3.1333610014068913,0.4434481305056437,0.2,0.08868962610112874,0.08834341106135195]
[0.12311522743024828,0.4783141182927997,0.22,0.09566282365855994,0.09561914513640804]
[3.6642401820846793,0.6295383949212363,0.24,0.12590767898424726,0.12717619234120695]
[2.125545801461395,0.7193716170745224,0.26,0.14387432341490447,0.14592233082673475]
[3.4006120572238085,0.7526953349352439,0.28,0.15053906698704878,0.15287622844830515]
[0.8890335381460135,0.9424166112416554,0.3,0.1884833222483311,0.19246671884864283]
[4.0954763797889635,1.1852052953794923,0.32,0.23704105907589845,0.2431311633210987]
[3.2930780956301664,1.2189911002559928,0.34,0.24379822005119856,0.25018148793240097]
[0.6371643286482476,1.234914119273729,0.36,0.2469828238547458,0.25350425775473734]
[4.376528737253853,1.281639100461267,0.38,0.2563278200922534,0.26325469247231503]
[4.515438155997518,1.330649611710718,0.4,0.2661299223421436,0.27348206503122213]
[4.057588583544023,1.3578161978714907,0.42,0.2715632395742981,0.2791511101143416]
[3.8473342545109945,1.4876822031945967,0.44,0.2975364406389193,0.3062511746783753]
[2.51409475275711,1.5579382400496367,0.46,0.31158764800992733,0.3209120024296233,null,null,"geschätzte Steigung der Verteilungsfunktion",0.20867712452237877]
[0.14479465665557023,1.5613829996492878,0.48,0.31227659992985757,0.3216308449575494,null,null,"geschätzter Ordinatenabschnitt der Verteilungsfunktion",-0.004194069687390334]
[0.68006048326819,1.6195380697303607,0.5,0.32390761394607215,0.33376647775846513,{"$nulls":3},"y=ax+b"]
[0.10708833854213395,1.7819846282311746,0.52,0.35639692564623493,0.36766535847497134]
[0.25902469897116726,1.9943761976380037,0.54,0.39887523952760073,0.41198662045158363]
[4.077442713045744,2.019105402205339,0.56,0.4038210804410678,0.41714703975242085]
[1.8808357892835659,2.0615418255875593,0.58,0.4123083651175119,0.42600255055883685]
[3.275785109223307,2.282182342058887,0.6,0.45643646841177743,0.47204517908920607]
[4.40407798008345,2.2967272726938925,0.62,0.4593454545387785,0.47508037339049647]
[2.6109263147259956,2.4658193284624685,0.64,0.4931638656924937,0.5103660173678606]
[3.835853234304447,2.5280042885933716,0.66,0.5056008577186744,0.5233425960365162]
[2.1483802605870315,3.1222110463324224,0.68,0.6244422092664845,0.6473399536132671]
[4.726758412307639,3.1884040747045237,0.7,0.6376808149409048,0.6611529244373854]
[4.581349383734525,3.337081658447121,0.72,0.6674163316894242,0.6921785350937257]
[0.42562143144658116,3.4160041838888997,0.74,0.68320083677778,0.7086478607629605]
[0.16808020106053423,3.5116774832076656,0.76,0.7023354966415332,0.7286126897583693]
[0.43424368868384633,3.565924443591295,0.78,0.713184888718259,0.7399327894653046]
[3.152429362230148,3.5893329529000493,0.8,0.7178665905800099,0.7448176098772108]
[4.678269203605425,3.5901179591407284,0.82,0.7180235918281457,0.7449814227222478]
[0.1349183812563659,3.846432399200248,0.84,0.7692864798400496,0.798468383047432]
[3.0258878177568924,3.948951438199093,0.86,0.7897902876398186,0.8198617613145086]
[3.8416569445492033,4.39621816588093,0.88,0.8792436331761859,0.913196095941688]
[4.61231366516164,4.447150790125825,0.9,0.889430158025165,0.9238245695134916]
[3.7718694150341205,4.4552475536858225,0.92,0.8910495107371645,0.9255141788511294]
[1.5724772152334054,4.492167178736645,0.94,0.8984334357473291,0.9332184600451795]
[0.8776364017073635,4.7591692035475806,0.96,0.9518338407095162,0.9889356748243784]
[3.837425142506423,4.788064934111804,0.98,0.9576129868223608,0.994965552789494]
[0.8230344376904242,4.812190468820168,1,0.9624380937640336,1]

{"sheet":"Ü6","index":9,"n_rows":52,"n_cols":12,"rows_kept":52,"flags":["formulas_cached_only"]}
["Lösungsvorschlag für Übung 4 (die erste Spalte mit Zufallszahlen wird nicht fixiert; die können kopiert und in die zweite Spalte eingefügt werden (Werte einfügen; dann ordnen). Dadurch wird jeweils ein neues Beispiel produziert)"]
["Uniform verteilte Zufallszahlen mit den Parametern 0 und 5","fixierte und geordnete Zufallszahlen","i/n","F(xi)","geschätzte F(xi)",null,"Mittelwert",6.067146116867137]
[9.70484614393051,3.1025198909901244,0.02,0.014645698712875077,0.05586051169241002,null,"Standardabweichung",1.8639528062882178,null,null,"Gerade"]
[8.384678914160105,3.4170387684586387,0.04,0.059576966922662844,0.07754689214801991,{"$nulls":5},0,0]
[5.1744247587906065,3.437835497233557,0.06,0.06254792817622262,0.07917980869652341,{"$nulls":5},1,1]
[6.329778421281979,3.50096671816572,0.08,0.07156667402367445,0.08429623956812637,null,null,"Steigung der theoretischen Verteilung, aus der die Daten stammen",0.2]
[4.013543223300018,3.6301364329314234,0.1,0.09001949041877488,0.09553136611216873,null,null,"Ordinatenabschnitt der theoretischen Vertrilung, aus der die Daten stammen",-0.4285714285714284,"y=ax+b"]
[9.699578867915378,3.724811415724523,0.12,0.1035444879606463,0.1044403552273383]
[9.623716925562855,4.091650723589325,0.14,0.15595010336990367,0.1446082522548433]
[5.535587437534561,4.107776505003506,0.16,0.1582537864290724,0.14658553678627895]
[8.00250139507945,4.164620750343827,0.18,0.16637439290626121,0.1536997291060851]
[6.971296840090567,4.207315618591486,0.2,0.17247365979878382,0.15919098684301902]
[8.270296285685518,4.209657078119576,0.22,0.17280815401708238,0.15949580868015545]
[7.505956533735089,4.238299601813159,0.24,0.17689994311616575,0.16325552378044206]
[9.239923517526229,4.3008366080728315,0.26,0.18583380115326176,0.1716627612686873]
[6.311918489232326,4.363300322889623,0.28,0.194757188984232,0.18033123040549848]
[4.08520773654785,4.57343382393574,0.3,0.22477626056224864,0.21145929252659712]
[4.4193811114754515,4.624384640198875,0.32,0.23205494859983944,0.21945555991695853]
[5.908552644863121,4.643648396460657,0.34,0.234806913780094,0.2225235061048485]
[3.8319912905332876,4.938188470486589,0.36,0.2768840672123699,0.27236386339384144]
[9.042467823135903,5.098617119544382,0.38,0.29980244564919767,0.30166762371084]
[6.507731625592975,5.112990269428332,0.4,0.30185575277547616,0.30436079837336094]
[9.523580932778453,5.141582460847254,0.42,0.30594035154960786,0.3097498250094778]
[5.203076426472243,5.401415835125346,0.44,0.34305940501790666,0.3604858342918822]
[8.984822851966328,5.808038495681149,0.46,0.40114835652587866,0.4447212206297042]
[8.112430274166066,6.0382932198792,0.48,0.4340418885541715,0.49382485392522235]
[8.99469112851056,6.05601161210576,0.5,0.43657308744368006,0.4976168933635592,{"$nulls":3},"y=ax+b"]
[6.003294683678007,6.0811484429855165,0.52,0.4401640632836453,0.5029968931371291]
[5.930868690296568,6.274977545925182,0.54,0.467853935132169,0.544390214211526]
[8.31174660042054,6.402721558462902,0.56,0.4861030797804148,0.5714371802962583]
[9.04634599849135,6.5305662510819396,0.58,0.5043666072974201,0.5981735007729863]
[4.70981243016314,6.572697474745956,0.6,0.5103853535351367,0.6068911632969547]
[6.184801440233958,6.603260558322303,0.62,0.5147515083317576,0.6131820734248954]
[9.128298289273738,6.822549396552657,0.64,0.5460784852218082,0.657360299793239]
[4.404583355942696,6.862911880818334,0.66,0.5518445544026194,0.6652825750846922]
[4.9461450417429695,6.943572740162978,0.68,0.563367534308997,0.6808931690390392]
[8.009313124162226,7.241225825490607,0.7,0.6058894036415154,0.7356157523595769]
[4.560465924615531,7.242613002077609,0.72,0.6060875717253729,0.7358591689867258]
[9.635983548146125,7.4799594341716,0.74,0.6399942048816574,0.7757644060033339]
[9.47788209269406,7.548748991092715,0.76,0.6498212844418165,0.7866558590546227]
[3.5964855283146626,7.563983237243283,0.78,0.6519976053204692,0.789025503814268]
[6.9148517174238435,7.575736774335015,0.8,0.6536766820478594,0.7908431431617854]
[7.20451357205143,7.687033164132662,0.82,0.669576166304666,0.807592875601888]
[7.346849775083632,8.078983525000076,0.84,0.725569075000011,0.859781737223944]
[5.975433386182762,8.28226654572871,0.86,0.754609506532673,0.8826619570517007]
[9.349512570769189,8.40041038878477,0.88,0.7714871983978244,0.8946755108238624]
[3.1300478391631543,8.68552177310381,0.9,0.8122173961576873,0.9199512226403139]
[8.303091188900577,9.023573377348544,0.92,0.8605104824783636,0.9436423992710774]
[7.680858266985839,9.108562311211688,0.94,0.872651758744527,0.9486288987450789]
[6.701110360883351,9.256935811200034,0.96,0.8938479730285764,0.9564874859862367]
[8.756656969062986,9.544720760724257,0.98,0.934960108674894,0.9689582460453827]
[4.609476177764053,9.60925479703304,1,0.9441792567190059,0.9713044971197895]

{"sheet":"Üb7","index":10,"n_rows":61,"n_cols":1,"rows_kept":61,"flags":["formulas_cached_only"]}
["Daten"]
[0.45707783162214083]
[0.4476226469873312]
[2.1349721407655697]
[0.09288925603712188]
[4.898998853497476]
[0.7067246218966675]
[2.409328801089393]
[5.923530916191173]
[0.4348558857869611]
[0.944351915684477]
[1.0413445756227664]
[0.8586481566750354]
[0.5536720614613343]
[0.29533864009710187]
[1.2850830224186465]
[3.3969150316881]
[0.7330961462644082]
[0.10713899392017545]
[1.2850291484595242]
[2.2657397371163026]
[3.1534490031480376]
[2.3623302096886345]
[5.654446313265726]
[0.07020320902428218]
[6.649694854637818]
[4.10076614700894]
[0.9888157532192979]
[0.1442669656674282]
[2.3242755248695355]
[0.07778508006774809]
[3.697428621953335]
[12.93268606032499]
[5.648222746115347]
[0.5050917265054891]
[0.11603505264117041]
[3.0987420496149647]
[1.0636654941994625]
[0.22579750257647738]
[2.345804624723967]
[5.357457678086809]
[11.09276819206065]
[4.494470039943716]
[0.49558977932743264]
[2.5762649425534754]
[2.5711445018389707]
[3.030964126930245]
[1.4494435707895428]
[0.8195760642546978]
[0.25686948052042846]
[5.236838373506786]
[0.1738207137461635]
[2.5352862428542315]
[2.133764893265912]
[0.012498234271251664]
[0.9969477603342011]
[0.9434735639521598]
[2.513492423535989]
[0.9116550398936518]
[1.2026174589241192]
[0.961008854846204]

{"sheet":"LÜb7","index":11,"n_rows":61,"n_cols":9,"rows_kept":61,"flags":["formulas_cached_only"]}
["Daten geordnet","i/n","Geschätze F(xi)",null,null,"Anzahl Daten",60]
[0.012498234271251664,0.016666666666666666,0.005531288994439776]
[0.07020320902428218,0.03333333333333333,0.030675433545117925]
[0.07778508006774809,0.05,0.03393152604066396]
[0.09288925603712188,0.0666666666666667,0.040385567643061115]
[0.10713899392017545,0.0833333333333334,0.04643497336060709]
[0.11603505264117041,0.1,0.050192244237443395]
[0.1442669656674282,0.116666666666667,0.06201829551851401]
[0.1738207137461635,0.133333333333334,0.07424033161754506]
[0.22579750257647738,0.15,0.09535041582821946]
[0.25686948052042846,0.166666666666667,0.10773952082993521]
[0.29533864009710187,0.183333333333334,0.12284324265693691]
[0.4348558857869611,0.2,0.1755068927602319]
[0.4476226469873312,0.216666666666667,0.18016510851311585]
[0.45707783162214083,0.233333333333334,0.18359805565728293]
[0.49558977932743264,0.25,0.19743292380627375]
[0.5050917265054891,0.266666666666667,0.20081015003511593]
[0.5536720614613343,0.283333333333334,0.21785600635383984]
[0.7067246218966675,0.3,0.2692181209347956]
[0.7330961462644082,0.316666666666667,0.2777209933802025,{"$nulls":3},"Es scheinen exponentialverteilte Daten vorzuliegen."]
[0.8195760642546978,0.333333333333334,0.30491633573204613]
[0.8586481566750354,0.35,0.31686516723335256,{"$nulls":3},"Geschätzer Parameter Lamda:",null,0.4437941471016058]
[0.9116550398936518,0.366666666666667,0.3327477848484165]
[0.9434735639521598,0.383333333333334,0.34210375708306306]
[0.944351915684477,0.4,0.3423601599021866]
[0.961008854846204,0.416666666666667,0.3472036750978461]
[0.9888157532192979,0.433333333333334,0.3552100304635847,null,"Grade"]
[0.9969477603342011,0.45,0.3575328429828709,null,0,0]
[1.0413445756227664,0.466666666666667,0.37006751233627155,null,1,1]
[1.0636654941994625,0.483333333333334,0.3762767513672549]
[1.2026174589241192,0.5,0.4135774003318827]
[1.2850291484595242,0.516666666666667,0.434637643767827]
[1.2850830224186465,0.533333333333334,0.4346511608252661]
[1.4494435707895428,0.55,0.4744208982072261]
[2.133764893265912,0.566666666666667,0.6120785354973113]
[2.1349721407655697,0.583333333333334,0.612286316271426]
[2.2657397371163026,0.6,0.6341464031410856]
[2.3242755248695355,0.616666666666667,0.6435281035913959]
[2.345804624723967,0.633333333333334,0.6469177910773931,{"$nulls":3},"Die Daten können als exponentialverteilt - mit dem geschätzten Parameter - durchgehen."]
[2.3623302096886345,0.65,0.6494978086929584]
[2.409328801089393,0.666666666666667,0.6567327636229899]
[2.513492423535989,0.683333333333334,0.6722398625393875]
[2.5352862428542315,0.7,0.6753946673963278]
[2.5711445018389707,0.716666666666667,0.6805194493232422]
[2.5762649425534754,0.733333333333334,0.6812446195753283]
[3.030964126930245,0.75,0.7394926334293954]
[3.0987420496149647,0.766666666666667,0.7472118733041981]
[3.1534490031480376,0.783333333333334,0.7532753177461722]
[3.3969150316881,0.8,0.7785439234729546]
[3.697428621953335,0.816666666666667,0.8061939150153631]
[4.10076614700894,0.833333333333334,0.837957399889727]
[4.494470039943716,0.85,0.8639345825251921]
[4.898998853497476,0.866666666666667,0.8862948992597033]
[5.236838373506786,0.883333333333334,0.9021263795196339]
[5.357457678086809,0.9,0.9072278100049468]
[5.648222746115347,0.916666666666667,0.9184589085521631]
[5.654446313265726,0.933333333333334,0.918683812900147]
[5.923530916191173,0.95,0.9278370375946385]
[6.649694854637818,0.966666666666667,0.9477176089861202]
[11.09276819206065,0.983333333333334,0.9927220467173263]
[12.93268606032499,1,0.9967834643376998]