{"text_format":"3","workbook":"xls","n_sheets":20,"sheets":["A1","LA1","A2","KA2","A3","LA3","A4","LA4","A5","LA5","A6","LA6","A7","LA7","A8","LA8","A9","LA9","A10","LA10"],"not_rendered":{"charts":2,"images":6,"external_links":1,"comments":6},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"A1","index":0,"n_rows":131,"n_cols":9,"rows_kept":131,"flags":["formulas_cached_only"]}
["Aufgabe 1",{"$nulls":6},"vorher (1 = fehlerfrei; 2 = nicht fehlerfrei)","nachher"]
["Im Contact Center der SBB in Brig wird eine interne Schulung",{"$nulls":6},1,1]
["zur Verbesserung der Qualität durchgeführt. Ziel ist es, ",{"$nulls":6},1,1]
["die Anzahl der fehlerhaften Dossier zu verringern. ",{"$nulls":6},1,1]
[{"$nulls":7},1,1]
["(Dossier = Bestellte Billette und Reservationen die dem Kunden",{"$nulls":6},2,1]
["zugeschickt werden oder die er am Bahnhofsschalter abholen",{"$nulls":6},1,1]
["kann.)",{"$nulls":6},2,1]
[{"$nulls":7},2,2]
["Es werden zwei Zufallsstichproben gezogen (eine vor der internen",{"$nulls":6},1,1]
["Schulung und eine nach der internen Schulung)",{"$nulls":6},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
["Bemerkung: Bei den Stichproben wird jeweils nur beachtet \"absolut fehlerfrei\"",{"$nulls":6},2,1]
["und \"fehlerhaft\".",{"$nulls":6},1,1]
[{"$nulls":7},1,1]
["War die interne Schulung wirksam?",null,null,"alpha: 0.05",{"$nulls":3},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
["Diego Wasmer",null,"2009-01-01",{"$nulls":4},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,1]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,2]
[{"$nulls":7},2,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,2]
[{"$nulls":7},2,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,2]
[{"$nulls":7},2,1]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,2]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,1]
[{"$nulls":7},2,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},2,2]
[{"$nulls":7},1,1]
[{"$nulls":7},2,2]
[{"$nulls":7},2,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,2]

{"sheet":"LA1","index":1,"n_rows":131,"n_cols":8,"rows_kept":131,"flags":["formulas_cached_only"]}
["Lösung",{"$nulls":5},"vorher (1 = fehlerfrei; 2 = nicht fehlerfrei)","nachher"]
["i.i.d. Zufallsvariablen (Variablen mit zwei Ausprägungen)",{"$nulls":5},1,1]
["Wir vergleichen zwei verbundene Stichproben, um zu entscheiden,",{"$nulls":5},1,1]
["ob sich eine signifikante Änderung der absoluten Häufigkeiten ergeben",{"$nulls":5},1,1]
["hat.","Es gibt zwei Ausprägungen. Somit McNemar-Test.",{"$nulls":4},1,1]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,1]
["Hypothesen",{"$nulls":5},2,2]
["H0: Die interne Schulung zeigt keine positive Wirkung.",{"$nulls":5},1,1]
["HA: Die interne Schulung bewirkt eine positive Änderung (rechtsseitiger Test)",{"$nulls":5},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
["Test",{"$nulls":5},2,1]
["McNemar-Test",{"$nulls":5},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
["Kreuztabelle:",{"$nulls":5},2,2]
[null,null," nachher",{"$nulls":3},1,1]
[null,null,1,2,null,null,2,1]
["vorher",1,80,8,null,null,1,1]
[null,2,20,22,null,null,2,1]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
["n = 28",{"$nulls":5},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
["Teststatistik","X ~ B(28,0.5)",{"$nulls":4},1,1]
["Testwert:",20,{"$nulls":4},2,2]
["p-Wert:","P(X>=20)",0.017849069088696767,"<",0.05,null,1,1]
[{"$nulls":6},1,1]
["Schlussfolgerungen aus dem Test",{"$nulls":5},1,1]
["Die Nullhypothese kann verworfen werden. Nach der internen Schulung arbeiten",{"$nulls":5},2,2]
["signifikant mehr Personen fehlerfrei als umgekehrt.",{"$nulls":5},1,1]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,1]
["Diego Wasmer",null,"2009-01-01",{"$nulls":3},1,1]
[{"$nulls":6},1,1]
["Variante mit chiquadratverteilter Teststatistik",{"$nulls":5},1,1]
["Testwert",5.142857142857143,{"$nulls":4},1,1]
["p-Wert",0.02334220522331474,"< 0.05",{"$nulls":3},2,2]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,2]
[{"$nulls":6},2,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,2]
[{"$nulls":6},2,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,2]
[{"$nulls":6},2,1]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,2]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,1]
[{"$nulls":6},2,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},2,2]
[{"$nulls":6},1,1]
[{"$nulls":6},2,2]
[{"$nulls":6},2,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,2]

{"sheet":"A2","index":2,"n_rows":219,"n_cols":9,"rows_kept":219,"flags":["formulas_cached_only"]}
[{"$nulls":7},"Umsätze","Stichprobe Verkäufer 1 und 2"]
[{"$nulls":7},48.4157324974654,1]
[{"$nulls":7},40.7240881065167,1]
[{"$nulls":7},47.0907343512071,1]
[{"$nulls":7},43.3443438402982,1]
[{"$nulls":7},31.3497462434084,1]
[{"$nulls":7},65.081546684007,1]
[{"$nulls":7},49.7486853004778,1]
[{"$nulls":7},56.897272263715,1]
[{"$nulls":7},48.3891383728375,1]
[{"$nulls":7},49.0627889446252,1]
[{"$nulls":7},33.2278211861532,1]
["Brantschen Lucien,",null,"2009-01-01",{"$nulls":4},67.2117483251653,1]
[{"$nulls":7},48.9500637599076,1]
[{"$nulls":7},52.6188641993627,1]
[{"$nulls":7},49.5741920499715,1]
[{"$nulls":7},51.940047040631,1]
[{"$nulls":7},51.999587393581,1]
[{"$nulls":7},50.2250912197092,1]
[{"$nulls":7},46.3749181190463,1]
[{"$nulls":7},44.4930131919305,1]
[{"$nulls":7},57.1753733925108,1]
[{"$nulls":7},43.778578296094,1]
[{"$nulls":7},49.4814070791949,1]
[{"$nulls":7},69.5863652165081,1]
[{"$nulls":7},48.115348201843,1]
[{"$nulls":7},56.3255088628011,1]
[{"$nulls":7},41.7952053666016,1]
[{"$nulls":7},57.7870588336707,1]
[{"$nulls":7},60.0461597075579,1]
[{"$nulls":7},44.5304374347193,1]
[{"$nulls":7},62.0432976320029,1]
[{"$nulls":7},39.3301328585125,1]
[{"$nulls":7},53.7198685341901,1]
[{"$nulls":7},47.2330675772748,1]
[{"$nulls":7},51.1545466869918,1]
[{"$nulls":7},46.895579424745,1]
[{"$nulls":7},57.5977284524382,1]
[{"$nulls":7},54.4501070261121,1]
[{"$nulls":7},54.2134980436888,1]
[{"$nulls":7},49.399244469651,1]
[{"$nulls":7},67.0031619559029,1]
[{"$nulls":7},58.8302105373136,1]
[{"$nulls":7},42.9610159678239,1]
[{"$nulls":7},42.6172658173856,1]
[{"$nulls":7},35.1318170011074,1]
[{"$nulls":7},48.2730886155203,1]
[{"$nulls":7},51.4853488522475,1]
[{"$nulls":7},52.7939252968352,1]
[{"$nulls":7},44.831232641689,1]
[{"$nulls":7},43.8544835850281,1]
[{"$nulls":7},53.4230591028893,1]
[{"$nulls":7},11.7943336070855,1]
[{"$nulls":7},44.3261899004624,1]
[{"$nulls":7},45.4560839029401,1]
[{"$nulls":7},58.0138654833603,1]
[{"$nulls":7},41.8794867733551,1]
[{"$nulls":7},46.5818328356286,1]
[{"$nulls":7},53.8867151622664,1]
[{"$nulls":7},55.4191749444081,1]
[{"$nulls":7},56.975356871961,1]
[{"$nulls":7},44.1966105707891,1]
[{"$nulls":7},51.4369363873819,1]
[{"$nulls":7},50.3137496766242,1]
[{"$nulls":7},57.285401025353,1]
[{"$nulls":7},43.4324417772522,1]
[{"$nulls":7},51.3690655640263,1]
[{"$nulls":7},58.385738016784,1]
[{"$nulls":7},51.0634867695645,1]
[{"$nulls":7},51.3938480043677,1]
[{"$nulls":7},38.9572161353454,1]
[{"$nulls":7},58.1417950167214,1]
[{"$nulls":7},47.4822210484731,1]
[{"$nulls":7},48.080568182047,1]
[{"$nulls":7},52.2792471301065,1]
[{"$nulls":7},51.3021685937133,1]
[{"$nulls":7},50.5249693524158,1]
[{"$nulls":7},30.8187081431711,1]
[{"$nulls":7},48.000010072113,1]
[{"$nulls":7},39.785539446025,1]
[{"$nulls":7},66.8780298496682,1]
[{"$nulls":7},49.5892213323489,1]
[{"$nulls":7},61.372717322441,1]
[{"$nulls":7},46.73981724229,1]
[{"$nulls":7},28.0363296999837,1]
[{"$nulls":7},40.6466498755119,1]
[{"$nulls":7},63.0290913293583,1]
[{"$nulls":7},68.3929513541819,1]
[{"$nulls":7},54.2196403973521,1]
[{"$nulls":7},49.4042911533279,1]
[{"$nulls":7},46.8405039033066,1]
[{"$nulls":7},42.5599526872979,1]
[{"$nulls":7},56.7387526943909,1]
[{"$nulls":7},39.9731394065784,1]
[{"$nulls":7},53.1769627154845,1]
[{"$nulls":7},58.686654864221,1]
[{"$nulls":7},57.4253023313786,1]
[{"$nulls":7},44.3277036912554,1]
[{"$nulls":7},38.5168621032538,1]
[{"$nulls":7},43.3825137276779,1]
[{"$nulls":7},59.5126435268785,1]
[{"$nulls":7},57.4904609365718,1]
[{"$nulls":7},48.674052397641,1]
[{"$nulls":7},58.1540931297528,1]
[{"$nulls":7},46.088544530845,1]
[{"$nulls":7},63.1949176473365,1]
[{"$nulls":7},33.0658771206038,1]
[{"$nulls":7},48.4088967808118,1]
[{"$nulls":7},50.1608774413301,1]
[{"$nulls":7},41.4487688041564,1]
[{"$nulls":7},39.8595976683275,1]
[{"$nulls":7},53.4279343298565,1]
[{"$nulls":7},28.6403191932665,1]
[{"$nulls":7},43.1734631062227,1]
[{"$nulls":7},35.7233743148005,1]
[{"$nulls":7},54.5534757114102,1]
[{"$nulls":7},50.0158789278585,1]
[{"$nulls":7},50.3733860210367,1]
[{"$nulls":7},24.1410953519586,1]
[{"$nulls":7},70.188695774361,1]
[{"$nulls":7},38.7983232195271,1]
[{"$nulls":7},42.4711831763222,2]
[{"$nulls":7},38.4981846124681,2]
[{"$nulls":7},62.5383555473596,2]
[{"$nulls":7},63.185567014333,2]
[{"$nulls":7},88.0501392823814,2]
[{"$nulls":7},68.769993358407,2]
[{"$nulls":7},45.798830138442,2]
[{"$nulls":7},52.2930065134793,2]
[{"$nulls":7},78.6432980278576,2]
[{"$nulls":7},73.4122338191223,2]
[{"$nulls":7},23.349282808398,2]
[{"$nulls":7},66.3185260548192,2]
[{"$nulls":7},76.3060797205856,2]
[{"$nulls":7},83.4122670160644,2]
[{"$nulls":7},48.9895508549517,2]
[{"$nulls":7},60.7472793375647,2]
[{"$nulls":7},47.3813280309523,2]
[{"$nulls":7},51.4824831394414,2]
[{"$nulls":7},75.7343680154579,2]
[{"$nulls":7},33.9945034703769,2]
[{"$nulls":7},49.383572594178,2]
[{"$nulls":7},42.6956471860907,2]
[{"$nulls":7},21.3545391266193,2]
[{"$nulls":7},70.2207366624622,2]
[{"$nulls":7},77.3123113393127,2]
[{"$nulls":7},55.3443749980695,2]
[{"$nulls":7},45.1094357070705,2]
[{"$nulls":7},69.633549852572,2]
[{"$nulls":7},48.5212620565728,2]
[{"$nulls":7},54.4035729088248,2]
[{"$nulls":7},52.1267892309514,2]
[{"$nulls":7},68.2538670771647,2]
[{"$nulls":7},73.1945318397809,2]
[{"$nulls":7},56.9166924108748,2]
[{"$nulls":7},54.9486021787567,2]
[{"$nulls":7},27.7518132450994,2]
[{"$nulls":7},48.1056774362664,2]
[{"$nulls":7},62.8528719648054,2]
[{"$nulls":7},37.0212746066263,2]
[{"$nulls":7},74.2213860992609,2]
[{"$nulls":7},47.2966409842867,2]
[{"$nulls":7},55.013258565769,2]
[{"$nulls":7},71.4338899990557,2]
[{"$nulls":7},49.5988465828313,2]
[{"$nulls":7},56.5786597740577,2]
[{"$nulls":7},35.5978187590154,2]
[{"$nulls":7},65.7472036920792,2]
[{"$nulls":7},48.9180717822752,2]
[{"$nulls":7},66.830454518452,2]
[{"$nulls":7},39.1895613626117,2]
[{"$nulls":7},56.9071894996295,2]
[{"$nulls":7},59.7888016597593,2]
[{"$nulls":7},72.003794092358,2]
[{"$nulls":7},62.9300699287772,2]
[{"$nulls":7},48.6029974849692,2]
[{"$nulls":7},76.3141111277589,2]
[{"$nulls":7},45.8923464957362,2]
[{"$nulls":7},57.7660890688929,2]
[{"$nulls":7},61.8760389634821,2]
[{"$nulls":7},51.5298213867392,2]
[{"$nulls":7},40.2547079913147,2]
[{"$nulls":7},81.7831839455287,2]
[{"$nulls":7},70.9813954045552,2]
[{"$nulls":7},57.1440982335162,2]
[{"$nulls":7},85.0136064555675,2]
[{"$nulls":7},60.8321516228293,2]
[{"$nulls":7},70.8513794497494,2]
[{"$nulls":7},64.0380881310979,2]
[{"$nulls":7},60.5884636631094,2]
[{"$nulls":7},56.477744415678,2]
[{"$nulls":7},72.5449242350338,2]
[{"$nulls":7},41.6858063760756,2]
[{"$nulls":7},101.522968531763,2]
[{"$nulls":7},71.0779252939934,2]
[{"$nulls":7},72.0053839076585,2]
[{"$nulls":7},60.2436290522685,2]
[{"$nulls":7},83.0308069067918,2]
[{"$nulls":7},68.367104589666,2]
[{"$nulls":7},54.7323015949946,2]
[{"$nulls":7},42.2271801085526,2]
[{"$nulls":7},79.3893364205109,2]
[{"$nulls":7},41.7983258058694,2]
[{"$nulls":7},80.1114618550932,2]
[{"$nulls":7},72.0657980621036,2]
[{"$nulls":7},54.4692784668441,2]
[{"$nulls":7},65.5212166909037,2]
[{"$nulls":7},38.558126828807,2]
[{"$nulls":7},52.429229118491,2]
[{"$nulls":7},45.5538752417705,2]
[{"$nulls":7},40.6175641684277,2]
[{"$nulls":7},62.4911851364923,2]
[{"$nulls":7},74.9349079328064,2]
[{"$nulls":7},64.958206437533,2]
[{"$nulls":7},89.7976088753515,2]
[{"$nulls":7},64.166345281023,2]
[{"$nulls":7},48.5797737064038,2]
[{"$nulls":7},61.2807442974556,2]
[{"$nulls":7},52.0415150834689,2]

{"sheet":"KA2","index":3,"n_rows":121,"n_cols":17,"rows_kept":121,"flags":["formulas_cached_only"]}
["Zuerst zu überprüfen, ob sich die Varianzen unterscheiden. ",{"$nulls":5},"n1",120,null,"i","xi","i/n","F(xi)","i","yi","i/n","F(yi)"]
["Dies kann mit dem F-Test gemacht werden: ",{"$nulls":4},0.9999992472932288,"E(X)1",49.21830891308726,null,1,11.7943336070855,0.008333333333333333,4.289725929074173e-05,1,21.3545391266193,0.01020408163265306,0.006339114071202356]
[{"$nulls":6},"Stabw1",9.528436944042713,null,2,24.1410953519586,0.016666666666666666,0.004246333874477148,2,23.349282808398,0.02040816326530612,0.009102802606272942]
["H0:","Varianzen unterscheiden sich nicht.",{"$nulls":4},"V(X)1",90.79111059659805,null,3,28.0363296999837,0.025,0.013106966282075083,3,27.7518132450994,0.030612244897959183,0.019147518322163437]
["HA:","Varianzen unterscheiden sich.",{"$nulls":4},"Alpha",0.05,null,4,28.6403191932665,0.03333333333333333,0.015400290290306762,4,33.9945034703769,0.04081632653061224,0.04837114579291191]
[{"$nulls":9},5,30.8187081431711,0.041666666666666664,0.026740299552117985,5,35.5978187590154,0.05102040816326531,0.05993213864761704]
["Zweiseitiger Test:",{"$nulls":5},"x","y",null,6,31.3497462434084,0.05,0.03037656236766695,6,37.0212746066263,0.061224489795918366,0.07191623512917511]
[{"$nulls":6},0,0,null,7,33.0658771206038,0.058333333333333334,0.04502048010926907,7,38.4981846124681,0.07142857142857142,0.0862094034588683]
["Testwert",null,0.3932025819214784,{"$nulls":3},1,1,null,8,33.2278211861532,0.06666666666666667,0.04665541494155612,8,38.558126828807,0.08163265306122448,0.0868314399579253]
["p-Wert:",null,1.5054135424907855e-06,"<0.05",null,null,"n2",98,null,9,35.1318170011074,0.075,0.06965527551865769,9,39.1895613626117,0.09183673469387756,0.09358892474286218]
["Schlussfolgerung: Die Varianzen unterscheiden sich signifikant.",{"$nulls":5},"E(X)2",59.2319590153855,null,10,35.7233743148005,0.08333333333333333,0.0783467717438634,10,40.2547079913147,0.10204081632653061,0.10585495315917637]
[{"$nulls":6},"Stabw2",15.195447130517245,null,11,38.5168621032538,0.09166666666666666,0.13069619213682626,11,40.6175641684277,0.11224489795918367,0.11028795599848673]
[{"$nulls":6},"V(X)2",230.90161349634477,null,12,38.7983232195271,0.1,0.13707243020916038,12,41.6858063760756,0.12244897959183673,0.12410705633487962]
["Als nächstes ist zu überprüfen, ob die Daten pro Stichprobe normalverteilt sind.",{"$nulls":8},13,38.9572161353454,0.10833333333333334,0.14076436988396546,13,41.7983258058694,0.1326530612244898,0.12563023111345295]
["Dazu sind P-P-Plots durchzuführen:",{"$nulls":8},14,39.3301328585125,0.11666666666666667,0.14969223764525896,14,42.2271801085526,0.14285714285714285,0.1315549997835168]
[{"$nulls":9},15,39.785539446025,0.125,0.16109688584962112,15,42.4711831763222,0.15306122448979592,0.1350107582425163]
[{"$nulls":9},16,39.8595976683275,0.13333333333333333,0.16300375304234205,16,42.6956471860907,0.16326530612244897,0.13824431739497722]
[{"$nulls":9},17,39.9731394065784,0.14166666666666666,0.16595562365591987,17,45.1094357070705,0.17346938775510204,0.17634304903798714]
[{"$nulls":9},18,40.6466498755119,0.15,0.1841700101372915,18,45.5538752417705,0.1836734693877551,0.1840219304061419]
[{"$nulls":9},19,40.7240881065167,0.15833333333333333,0.18634120923359676,19,45.798830138442,0.19387755102040816,0.1883418254003093]
[{"$nulls":9},20,41.4487688041564,0.16666666666666666,0.20742011201045152,20,45.8923464957362,0.20408163265306123,0.190007397327156]
[{"$nulls":9},21,41.7952053666016,0.175,0.21797591155886908,21,47.2966409842867,0.21428571428571427,0.2160938444778172]
[{"$nulls":9},22,41.8794867733551,0.18333333333333332,0.22059000934023865,22,47.3813280309523,0.22448979591836735,0.21773064589366753]
[{"$nulls":9},23,42.5599526872979,0.19166666666666668,0.24234230283896463,23,48.1056774362664,0.23469387755102042,0.23201973423526523]
[{"$nulls":9},24,42.6172658173856,0.2,0.24422603417125288,24,48.5212620565728,0.24489795918367346,0.2404479842768925]
[{"$nulls":9},25,42.9610159678239,0.20833333333333334,0.2556879835105401,25,48.5797737064038,0.25510204081632654,0.24164787562203016]
[{"$nulls":9},26,43.1734631062227,0.21666666666666667,0.2629097195904857,26,48.6029974849692,0.2653061224489796,0.242125022458074]
[{"$nulls":9},27,43.3443438402982,0.225,0.268793237234491,27,48.9180717822752,0.2755102040816326,0.24864860904276764]
[{"$nulls":9},28,43.3825137276779,0.23333333333333334,0.27011642574255523,28,48.9895508549517,0.2857142857142857,0.2501414988346645]
[{"$nulls":9},29,43.4324417772522,0.24166666666666667,0.27185212440363227,29,49.383572594178,0.29591836734693877,0.2584555162037696]
[{"$nulls":9},30,43.778578296094,0.25,0.28403563761908224,30,49.5988465828313,0.30612244897959184,0.2630576130527995]
[{"$nulls":9},31,43.8544835850281,0.25833333333333336,0.28674190726496107,31,51.4824831394414,0.3163265306122449,0.30503039120549735]
[{"$nulls":9},32,44.1966105707891,0.26666666666666666,0.29908906631620713,32,51.5298213867392,0.32653061224489793,0.3061225254944496]
[{"$nulls":9},33,44.3261899004624,0.275,0.3038277179691268,33,52.0415150834689,0.336734693877551,0.3180362265543023]
[{"$nulls":9},34,44.3277036912554,0.2833333333333333,0.3038832740064783,34,52.1267892309514,0.3469387755102041,0.3200405406668556]
[{"$nulls":9},35,44.4930131919305,0.2916666666666667,0.30997715748663524,35,52.2930065134793,0.35714285714285715,0.3239624629060007]
[{"$nulls":9},36,44.5304374347193,0.3,0.3113641046633453,36,52.429229118491,0.3673469387755102,0.32719131585145944]
[{"$nulls":9},37,44.831232641689,0.30833333333333335,0.3226076419343378,37,54.4035729088248,0.37755102040816324,0.3753364720673166]
[{"$nulls":9},38,45.4560839029401,0.31666666666666665,0.3464798291808736,38,54.4692784668441,0.3877551020408163,0.37697770847190226]
[{"$nulls":9},39,46.088544530845,0.325,0.371279800212023,39,54.7323015949946,0.3979591836734694,0.3835696823360628]
[{"$nulls":9},40,46.3749181190463,0.3333333333333333,0.38269473136048404,40,54.9486021787567,0.40816326530612246,0.38901614297344855]
[{"$nulls":9},41,46.5818328356286,0.3416666666666667,0.39100694549670356,41,55.013258565769,0.41836734693877553,0.3906484916745643]
[{"$nulls":9},42,46.73981724229,0.35,0.3973874409778765,42,55.3443749980695,0.42857142857142855,0.3990376802307809]
[{"$nulls":9},43,46.8405039033066,0.35833333333333334,0.40146835154728144,43,56.477744415678,0.4387755102040816,0.428084646991685]
["Damit zeigt sich, dass der Welch-Test durchgeführt werden kann.",{"$nulls":8},44,46.895579424745,0.36666666666666664,0.4037051927479718,44,56.5786597740577,0.4489795918367347,0.4306924707363945]
["Hypothesen",{"$nulls":8},45,47.0907343512071,0.375,0.41165613499770504,45,56.9071894996295,0.45918367346938777,0.43920261203647737]
["H0: Die durchschnittlichen Umsätze der beiden Verkäufer unterscheiden sich nicht. ",{"$nulls":8},46,47.2330675772748,0.38333333333333336,0.41747819519422935,46,56.9166924108748,0.46938775510204084,0.4394492110805428]
["HA: Die durchschnittlichen Umsätze der beiden Verkäufer unterscheiden sich.  ",{"$nulls":8},47,47.4822210484731,0.39166666666666666,0.4277126125135242,47,57.1440982335162,0.47959183673469385,0.4453571504773135]
[{"$nulls":9},48,48.000010072113,0.4,0.4491301783910955,48,57.7660890688929,0.4897959183673469,0.4615745600511346]
["Test",{"$nulls":8},49,48.080568182047,0.4083333333333333,0.45247734498145264,49,59.7888016597593,0.5,0.5146161124897776]
["Welch-Test (da Varianzen sich stark unterscheiden).",{"$nulls":8},50,48.115348201843,0.4166666666666667,0.4539235036037238,50,60.2436290522685,0.5102040816326531,0.5265408438985689]
[{"$nulls":9},51,48.2730886155203,0.425,0.46048976439767253,51,60.5884636631094,0.5204081632653061,0.5355665175074251]
["Test rechtsseitig, linksseitig oder zweiseitig?",{"$nulls":8},52,48.3891383728375,0.43333333333333335,0.4653275588699767,52,60.7472793375647,0.5306122448979592,0.5397174814585012]
["Es handelt sich um einen zweiseitigen Test. ",{"$nulls":8},53,48.4088967808118,0.44166666666666665,0.46615176313278783,53,60.8321516228293,0.5408163265306123,0.5419340433514213]
[{"$nulls":9},54,48.4157324974654,0.45,0.4664369429045745,54,61.2807442974556,0.5510204081632653,0.5536264185837589]
["Teststatistik",{"$nulls":8},55,48.674052397641,0.4583333333333333,0.4772251285276554,55,61.8760389634821,0.5612244897959183,0.5690691345883405]
[-5.675728095648579,{"$nulls":8},56,48.9500637599076,0.4666666666666667,0.488770435284822,56,62.4911851364923,0.5714285714285714,0.5849163546865876]
[{"$nulls":9},57,49.0627889446252,0.475,0.49348888630498244,57,62.5383555473596,0.5816326530612245,0.5861262037182184]
["P-Wert",{"$nulls":3},"R=",0.3211154419025407,{"$nulls":3},58,49.399244469651,0.48333333333333334,0.5075750625441195,58,62.8528719648054,0.5918367346938775,0.5941716526279315]
[6.553075640963688e-08,"<0.05",null,null,"df=",156.17201959717676,{"$nulls":3},59,49.4042911533279,0.49166666666666664,0.5077863209420779,59,62.9300699287772,0.6020408163265306,0.5961404802717434]
[{"$nulls":9},60,49.4814070791949,0.5,0.511014151341534,60,63.185567014333,0.6122448979591837,0.602638970208542]
["Schlussfolgerungen aus dem Test",{"$nulls":8},61,49.5741920499715,0.5083333333333333,0.5148968638317147,61,64.0380881310979,0.6224489795918368,0.624107829260324]
["p-Wert","<",0.05,{"$nulls":6},62,49.5892213323489,0.5166666666666667,0.5155256612569635,62,64.166345281023,0.6326530612244898,0.6273065072405316]
["Das Ergebnis ist signifikant.",{"$nulls":8},63,49.7486853004778,0.525,0.5221946533035594,63,64.958206437533,0.6428571428571429,0.6468536244560683]
["Die Nullhypothese wird verworfen.",{"$nulls":8},64,50.0158789278585,0.5333333333333333,0.5333541837451058,64,65.5212166909037,0.6530612244897959,0.6605230050144361]
["Die durchschnittlichen Umsätze der beiden Verkäufer unterscheiden sich.",{"$nulls":8},65,50.1608774413301,0.5416666666666666,0.5393997531594799,65,65.7472036920792,0.6632653061224489,0.6659521264481354]
[{"$nulls":9},66,50.2250912197092,0.55,0.5420742598855048,66,66.3185260548192,0.673469387755102,0.6795215123088142]
[{"$nulls":9},67,50.3137496766242,0.5583333333333333,0.5457637347939257,67,66.830454518452,0.6836734693877551,0.6914803461761551]
["Brantschen Lucien,",null,"2009-01-01",{"$nulls":6},68,50.3733860210367,0.5666666666666667,0.5482432701081814,68,68.2538670771647,0.6938775510204082,0.7236517770164133]
[{"$nulls":9},69,50.5249693524158,0.575,0.5545370535243364,69,68.367104589666,0.7040816326530612,0.7261387793333066]
["Mit R:",{"$nulls":8},70,51.0634867695645,0.5833333333333334,0.5767748649593121,70,68.769993358407,0.7142857142857143,0.7348965703652833]
["data:  brantschen$Umsaetze by brantschen$Stichprobe ",{"$nulls":8},71,51.1545466869918,0.5916666666666667,0.5805130792197915,71,69.633549852572,0.7244897959183674,0.7531766376614495]
["t = -5.6757, df = 156.172, p-value = 6.543e-08",{"$nulls":8},72,51.3021685937133,0.6,0.5865577380118966,72,70.2207366624622,0.7346938775510204,0.7652099748871908]
["alternative hypothesis: true difference in means is not equal to 0 ",{"$nulls":8},73,51.3690655640263,0.6083333333333333,0.5892903119436452,73,70.8513794497494,0.7448979591836735,0.7777643531935181]
["95 percent confidence interval:",{"$nulls":8},74,51.3938480043677,0.6166666666666667,0.5903015210709002,74,70.9813954045552,0.7551020408163265,0.7803041525607761]
[" -13.498607  -6.528693 ",{"$nulls":8},75,51.4369363873819,0.625,0.592058242825562,75,71.0779252939934,0.7653061224489796,0.7821789889586821]
["sample estimates:",{"$nulls":8},76,51.4853488522475,0.6333333333333333,0.5940298212669912,76,71.4338899990557,0.7755102040816326,0.7890123842944956]
["mean in group 1 mean in group 2 ",{"$nulls":8},77,51.940047040631,0.6416666666666667,0.6124244910086394,77,72.003794092358,0.7857142857142857,0.7996870882186428]
["       49.21831        59.23196 ",{"$nulls":8},78,51.999587393581,0.65,0.6148155588728454,78,72.0053839076585,0.7959183673469388,0.7997164053264105]
[{"$nulls":9},79,52.2792471301065,0.6583333333333333,0.6259866590633127,79,72.0657980621036,0.8061224489795918,0.8008285656236865]
[{"$nulls":9},80,52.6188641993627,0.6666666666666666,0.6394110136246945,80,72.5449242350338,0.8163265306122449,0.8095163488174055]
[{"$nulls":9},81,52.7939252968352,0.675,0.646265474043963,81,73.1945318397809,0.826530612244898,0.8209170484225096]
[{"$nulls":9},82,53.1769627154845,0.6833333333333333,0.6610962286563827,82,73.4122338191223,0.8367346938775511,0.8246396644588088]
[{"$nulls":9},83,53.4230591028893,0.6916666666666667,0.6704964260361985,83,74.2213860992609,0.8469387755102041,0.838041865400819]
[{"$nulls":9},84,53.4279343298565,0.7,0.6706815866887961,84,74.9349079328064,0.8571428571428571,0.8492912242951862]
[{"$nulls":9},85,53.7198685341901,0.7083333333333334,0.6816915561165696,85,75.7343680154579,0.8673469387755102,0.8612627372602752]
[{"$nulls":9},86,53.8867151622664,0.7166666666666667,0.6879134499283583,86,76.3060797205856,0.8775510204081632,0.869415832265313]
[{"$nulls":9},87,54.2134980436888,0.725,0.6999442377265181,87,76.3141111277589,0.8877551020408163,0.8695279564459588]
[{"$nulls":9},88,54.2196403973521,0.7333333333333333,0.7001683531401122,88,77.3123113393127,0.8979591836734694,0.8829479642806466]
[{"$nulls":9},89,54.4501070261121,0.7416666666666667,0.7085219867282917,89,78.6432980278576,0.9081632653061225,0.8992773029914078]
[{"$nulls":9},90,54.5534757114102,0.75,0.7122331538197108,90,79.3893364205109,0.9183673469387755,0.9076696502300254]
[{"$nulls":9},91,55.4191749444081,0.7583333333333333,0.7424040443074571,91,80.1114618550932,0.9285714285714286,0.9152889495137628]
[{"$nulls":9},92,56.3255088628011,0.7666666666666667,0.7721341483125955,92,81.7831839455287,0.9387755102040817,0.9311058518833334]
[{"$nulls":9},93,56.7387526943909,0.775,0.7850208787132451,93,83.0308069067918,0.9489795918367347,0.941347085574375]
[{"$nulls":9},94,56.897272263715,0.7833333333333333,0.7898496238611312,94,83.4122670160644,0.9591836734693877,0.944227429296034]
[{"$nulls":9},95,56.975356871961,0.7916666666666666,0.7922045872415437,95,85.0136064555675,0.9693877551020408,0.9551203925402141]
[{"$nulls":9},96,57.1753733925108,0.8,0.7981653611601272,96,88.0501392823814,0.9795918367346939,0.9710530842684892]
[{"$nulls":9},97,57.285401025353,0.8083333333333333,0.8014002294179086,97,89.7976088753515,0.9897959183673469,0.9778636924661259]
[{"$nulls":9},98,57.4253023313786,0.8166666666666667,0.8054679357502448,98,101.522968531763,1,0.9973081957084784]
[{"$nulls":9},99,57.4904609365718,0.825,0.8073450232457081]
[{"$nulls":9},100,57.5977284524382,0.8333333333333334,0.8104109719967334]
[{"$nulls":9},101,57.7870588336707,0.8416666666666667,0.8157487103098462]
[{"$nulls":9},102,58.0138654833603,0.85,0.8220185268689748]
[{"$nulls":9},103,58.1417950167214,0.8583333333333333,0.8254949266674207]
[{"$nulls":9},104,58.1540931297528,0.8666666666666667,0.8258268323621158]
[{"$nulls":9},105,58.385738016784,0.875,0.8320034735958826]
[{"$nulls":9},106,58.686654864221,0.8833333333333333,0.8398139483229454]
[{"$nulls":9},107,58.8302105373136,0.8916666666666667,0.8434550141592212]
[{"$nulls":9},108,59.5126435268785,0.9,0.8600135454502571]
[{"$nulls":9},109,60.0461597075579,0.9083333333333333,0.8720995859961587]
[{"$nulls":9},110,61.372717322441,0.9166666666666666,0.8989503025592849]
[{"$nulls":9},111,62.0432976320029,0.925,0.9108438777871064]
[{"$nulls":9},112,63.0290913293583,0.9333333333333333,0.926390940042117]
[{"$nulls":9},113,63.1949176473365,0.9416666666666667,0.9287890119522172]
[{"$nulls":9},114,65.081546684007,0.95,0.952026767255292]
[{"$nulls":9},115,66.8780298496682,0.9583333333333334,0.9680853411034118]
[{"$nulls":9},116,67.0031619559029,0.9666666666666667,0.9690144649079236]
[{"$nulls":9},117,67.2117483251653,0.975,0.9705134355347326]
[{"$nulls":9},118,68.3929513541819,0.9833333333333333,0.977908982905173]
[{"$nulls":9},119,69.5863652165081,0.9916666666666667,0.9837256853357246]
[{"$nulls":9},120,70.188695774361,1,0.9861256610112566]

{"sheet":"A3","index":4,"n_rows":121,"n_cols":9,"rows_kept":121,"flags":["formulas_cached_only"]}
[{"$nulls":7},"Barbesuchverhalten (1 = Barbesuch; 0 = kein Barbesuch)","Ort:Belalp = 1; Bettmeralp = 2"]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
["Eyer Roman",null,"2009-01-01",{"$nulls":4},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},0,1]
[{"$nulls":7},0,1]
[{"$nulls":7},1,1]
[{"$nulls":7},0,1]
[{"$nulls":7},0,1]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]
[{"$nulls":7},0,2]
[{"$nulls":7},1,2]

{"sheet":"LA3","index":5,"n_rows":62,"n_cols":14,"rows_kept":62,"flags":["formulas_cached_only"]}
["Test auf Anteile bei zwei Ausprägungen",{"$nulls":11},"Belalp","Bettmeralp"]
[{"$nulls":12},1,0]
["Hypothesen",{"$nulls":11},0,1]
["H0 : Die Barbesuche in Belalp und der Bettmeralp unterscheiden sich.",{"$nulls":11},0,1]
["HA:  Die Barbesuche in Belalp und der Bettmeralp unterscheiden sich nicht.",{"$nulls":11},1,1]
[{"$nulls":12},0,1]
["Test",{"$nulls":11},1,1]
["Test auf Anteile zwei Ausprägungen (unverbundener Zweistichprobentest)",{"$nulls":4},"Belalp","Bettmeralp",{"$nulls":5},0,0]
[{"$nulls":4},"Anzahl",60,60,{"$nulls":5},1,0]
["Test rechtsseitig, linksseitig oder zweiseitig?",{"$nulls":11},1,0]
["zweiseitiger Test, alpha = 0.05",{"$nulls":4},"X1",41,{"$nulls":5},1,0]
[{"$nulls":5},"X2",32,{"$nulls":5},1,0]
["Teststatistik",{"$nulls":4},"X1/n1",0.6833333333333333,{"$nulls":5},1,0]
["Testwert",1.683149814013904,"P-Wert",1,null,"X2/n2",0.5333333333333333,{"$nulls":5},1,0]
[{"$nulls":5},"(X1+X2)/(n1+n2)",0.6083333333333333,{"$nulls":5},1,1]
["Schlussfolgerungen aus dem Test",{"$nulls":11},1,1]
["Da wir zweiseitig testen gilt: 0.09234609 > 0.025",{"$nulls":11},1,1]
["Der Unterschied ist somit nicht signifikant. H0 wird nicht verworfen.",{"$nulls":11},0,1]
["Die Barbesuche in Belalp und der Bettmeralp unterscheiden sich. ",{"$nulls":11},1,0]
[{"$nulls":12},1,1]
[{"$nulls":12},1,0]
[{"$nulls":12},1,1]
["Eyer Roman",null,"2009-01-01",{"$nulls":9},1,1]
[{"$nulls":12},0,1]
["Mit R",{"$nulls":11},1,0]
[" AnteilZweistichTest(eyer$Barbesuchverhalten,eyer$Ort,seite=2)",{"$nulls":11},0,1]
["       Anteil1   Anteil2 Testwert    p-Wert Seite:0=rechts;1=links;2=beid",{"$nulls":11},1,0]
["[1,] 0.6833333 0.5333333 1.683150 0.0923461                             2",{"$nulls":11},0,1]
["     Anteilsdifferenz VertrauensintervallIn% UntereGrenze ObereGrenze",{"$nulls":11},1,1]
["[1,]             0.15                   0.95            0   0.3246693",{"$nulls":11},0,1]
["     Stichprobengrösse1 Stichprobengrösse2",{"$nulls":11},1,1]
["[1,]                 60                 60",{"$nulls":11},1,0]
[{"$nulls":12},1,1]
[{"$nulls":12},1,1]
[{"$nulls":12},1,1]
[{"$nulls":12},0,0]
[{"$nulls":12},1,1]
[{"$nulls":12},0,1]
[{"$nulls":12},1,0]
[{"$nulls":12},1,0]
[{"$nulls":12},1,0]
[{"$nulls":12},1,1]
[{"$nulls":12},0,0]
[{"$nulls":12},1,0]
[{"$nulls":12},1,1]
[{"$nulls":12},1,1]
[{"$nulls":12},1,0]
[{"$nulls":12},1,1]
[{"$nulls":12},1,0]
[{"$nulls":12},1,1]
[{"$nulls":12},1,0]
[{"$nulls":12},0,1]
[{"$nulls":12},1,0]
[{"$nulls":12},0,1]
[{"$nulls":12},1,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},0,0]
[{"$nulls":12},1,1]
[{"$nulls":12},0,0]
[{"$nulls":12},0,1]
[{"$nulls":12},41,32]

{"sheet":"A4","index":6,"n_rows":101,"n_cols":8,"rows_kept":101,"flags":["formulas_cached_only"]}
[{"$nulls":6},"Snowboarder = 1; Nicht-Snowboarder = 2","Ort"]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
["Imesch Janine",null,"2009-01-01",{"$nulls":3},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},1,1]
[{"$nulls":6},1,1]
[{"$nulls":6},0,1]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},1,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]
[{"$nulls":6},0,2]

{"sheet":"LA4","index":7,"n_rows":52,"n_cols":9,"rows_kept":52,"flags":["formulas_cached_only"]}
["Test auf Anteile bei zwei Ausprägungen",{"$nulls":6},"Saas - Fee","Zermatt"]
["Unverbundener Zweistichprobentest",{"$nulls":5},1,1,0]
["Hypothesen",{"$nulls":5},2,0,0]
["H0 : Die Snowboarderanteile unterscheiden sich.",{"$nulls":5},3,0,0]
["HA:  Die Snowboarderanteile unterscheiden sich nicht.",{"$nulls":5},4,1,1]
[{"$nulls":6},5,1,1]
["Test",{"$nulls":5},6,1,1]
["Unverbundener Zweistichprobentest auf Anteile (zwei Ausprägungen)",{"$nulls":5},7,0,1]
[{"$nulls":6},8,0,1]
["Test rechtsseitig, linksseitig oder zweiseitig?",{"$nulls":5},9,1,0]
["zweiseitiger Test, alpha = 0.05",{"$nulls":5},10,1,0]
[{"$nulls":6},11,1,0]
["Teststatistik",{"$nulls":5},12,1,1]
["Testwert",2.401922307076307,"P-Wert",0.9918454140611224,null,null,13,1,0]
[{"$nulls":6},14,0,1]
["Schlussfolgerungen aus dem Test",{"$nulls":5},15,0,0]
["Da wir zweiseitig testen gilt: 0.99184541> 0.025",{"$nulls":5},16,1,1]
["Der Unterschied ist somit nicht signifikant. H0 wird nicht verworfen.",{"$nulls":5},17,0,1]
["Die Snowboardanteile in Saas Fee und Zermatt unterscheiden sich. ",{"$nulls":5},18,1,1]
[{"$nulls":6},19,0,1]
[null,"Saas - Fee","Zermatt",{"$nulls":3},20,1,0]
["Anzahl",50,50,{"$nulls":3},21,1,0]
[{"$nulls":6},22,1,0]
["X1",32,{"$nulls":4},23,1,0]
["X2",20,{"$nulls":4},24,1,0]
["X1/n1",0.64,{"$nulls":4},25,1,1]
["X2/n2",0.4,{"$nulls":4},26,1,0]
["(X1+X2)/(n1+n2)",0.52,{"$nulls":4},27,0,1]
[{"$nulls":6},28,1,0]
["Testwert",2.401922307076307,{"$nulls":4},29,0,1]
[{"$nulls":6},30,0,0]
["p-Wert",0.9918454140611224,">",0.025,null,null,31,1,1]
[{"$nulls":6},32,0,0]
[{"$nulls":6},33,1,0]
["1= Snowboarder",{"$nulls":5},34,0,0]
["0= kein Snowboarder",{"$nulls":5},35,1,0]
[{"$nulls":6},36,0,1]
["Mit R:",{"$nulls":5},37,0,0]
[" AnteilZweistichTest(imesch$Snowboarder,imesch$Ort,seite=2)",{"$nulls":5},38,1,0]
["     Anteil1 Anteil2 Testwert     p-Wert Seite:0=rechts;1=links;2=beid",{"$nulls":5},39,1,1]
["[1,]    0.64     0.4 2.401922 0.01630917                             2",{"$nulls":5},40,1,0]
["     Anteilsdifferenz VertrauensintervallIn% UntereGrenze ObereGrenze",{"$nulls":5},41,0,1]
["[1,]             0.24                   0.95   0.04416046   0.4358395",{"$nulls":5},42,1,0]
["     Stichprobengrösse1 Stichprobengrösse2",{"$nulls":5},43,1,1]
["[1,]                 50                 50",{"$nulls":5},44,1,0]
[{"$nulls":6},45,1,1]
[{"$nulls":6},46,1,0]
[{"$nulls":6},47,0,0]
[{"$nulls":6},48,1,0]
[{"$nulls":6},49,1,0]
[{"$nulls":6},50,0,0]
[{"$nulls":7},32,20]

{"sheet":"A5","index":8,"n_rows":91,"n_cols":4,"rows_kept":91,"flags":["formulas_cached_only"]}
["Es soll untersucht werden, ob es nach der Legalisierung","Person","Stichprobe 1","Stichprobe 2"]
["von Cannabis mehr Konsumenten gibt oder weniger.",1,0,1]
["Es werden, wie beim McNemar-Test üblich, zwei Stich-",2,0,1]
["proben bei denselben Probanden entnommen. Eine vor der Legalisierung (Stich-",3,0,1]
["probe 1) und eine nach der Legalisierung (Stichprobe 2).",4,0,0]
["0 bedeutet dabei, dass die Person nicht konsumiert, 1",5,0,1]
["hingegen bedeutet, dass die Person konsumiert.",6,1,0]
[null,7,0,1]
[null,8,0,0]
[null,9,0,1]
["Burgener, Jan. 09",10,0,0]
[null,11,1,1]
[null,12,0,0]
[null,13,0,1]
[null,14,0,0]
[null,15,0,1]
[null,16,0,1]
[null,17,0,0]
[null,18,0,0]
[null,19,1,1]
[null,20,0,1]
[null,21,1,1]
[null,22,0,1]
[null,23,0,1]
[null,24,0,0]
[null,25,0,0]
[null,26,0,1]
[null,27,0,1]
[null,28,0,0]
[null,29,0,1]
[null,30,1,1]
[null,31,0,1]
[null,32,0,1]
[null,33,0,1]
[null,34,0,0]
[null,35,0,1]
[null,36,1,0]
[null,37,0,1]
[null,38,0,0]
[null,39,0,1]
[null,40,0,0]
[null,41,1,1]
[null,42,0,0]
[null,43,0,1]
[null,44,0,0]
[null,45,0,1]
[null,46,0,1]
[null,47,0,0]
[null,48,0,0]
[null,49,1,1]
[null,50,0,1]
[null,51,1,1]
[null,52,0,1]
[null,53,0,1]
[null,54,0,0]
[null,55,0,0]
[null,56,0,1]
[null,57,0,1]
[null,58,0,0]
[null,59,0,1]
[null,60,1,1]
[null,61,0,1]
[null,62,0,1]
[null,63,0,1]
[null,64,0,0]
[null,65,0,1]
[null,66,1,0]
[null,67,0,1]
[null,68,0,0]
[null,69,0,1]
[null,70,0,0]
[null,71,1,1]
[null,72,0,0]
[null,73,0,1]
[null,74,0,0]
[null,75,0,1]
[null,76,0,1]
[null,77,0,0]
[null,78,0,0]
[null,79,1,1]
[null,80,0,1]
[null,81,1,1]
[null,82,0,1]
[null,83,0,1]
[null,84,0,0]
[null,85,0,0]
[null,86,0,1]
[null,87,0,1]
[null,88,0,0]
[null,89,0,1]
[null,90,1,1]

{"sheet":"LA5","index":9,"n_rows":92,"n_cols":13,"rows_kept":92,"flags":["formulas_cached_only"]}
["Hypothesen",{"$nulls":5},"Person","Stichprobe 1","Stichprobe 2","vorher nicht nacher nicht","vorher nicht nachher schon","vorher schon nachher nicht","vorher schon nachher auch"]
["H0: Die Legalisierung führt nicht zu mehr Konsum",{"$nulls":5},1,0,1,"","x","",""]
["HA: Legalisierung führt zu mehr Konsum",{"$nulls":5},2,0,1,"","x","",""]
[{"$nulls":6},3,0,1,"","x","",""]
["Test",{"$nulls":5},4,0,0,"x","","",""]
["McNemar-Test",null,"(verbundener Zweistichprobentest)",{"$nulls":3},5,0,1,"","x","",""]
[{"$nulls":6},6,1,0,"","","x",""]
["Test rechtsseitig, linksseitig oder zweiseitig?",{"$nulls":5},7,0,1,"","x","",""]
["linksseitig",{"$nulls":5},8,0,0,"x","","",""]
[{"$nulls":6},9,0,1,"","x","",""]
["Teststatistik",{"$nulls":5},10,0,0,"x","","",""]
["Binomialverteilung mit Test-Wert 3 (n = 3+45=48;p = 0.5)",{"$nulls":5},11,1,1,"","","","x"]
[{"$nulls":6},12,0,0,"x","","",""]
["Schlussfolgerungen aus dem Test",{"$nulls":5},13,0,1,"","x","",""]
["Der p Wert ist kleiner als 0.05. Deshalb können wir die Nullhypothese ver-",{"$nulls":5},14,0,0,"x","","",""]
["werfen. Wir nehmen daher die Alternativhypothese an und gehen davon ",{"$nulls":5},15,0,1,"","x","",""]
["aus, dass eine Legalisierung die Anzahl der Konsumenten erhöht.",{"$nulls":5},16,0,1,"","x","",""]
["p-Wert ist signifikant.",{"$nulls":5},17,0,0,"x","","",""]
[{"$nulls":6},18,0,0,"x","","",""]
[{"$nulls":6},19,1,1,"","","","x"]
[{"$nulls":6},20,0,1,"","x","",""]
[null,"Konsumiert vorher","Konsumiert vorher nicht",{"$nulls":3},21,1,1,"","","","x"]
["Konsumiert nachher",12,45,{"$nulls":3},22,0,1,"","x","",""]
["Konsumiert nachher nicht",3,30,{"$nulls":3},23,0,1,"","x","",""]
[{"$nulls":6},24,0,0,"x","","",""]
["n:",48,{"$nulls":4},25,0,0,"x","","",""]
["T-Wert",3,{"$nulls":4},26,0,1,"","x","",""]
["P-Wert",6.562927978848174e-11,{"$nulls":4},27,0,1,"","x","",""]
["<0.05",{"$nulls":5},28,0,0,"x","","",""]
[{"$nulls":6},29,0,1,"","x","",""]
["Da der p-Wert < 0.05, kann die Nullhypothese verworfen werden.",{"$nulls":5},30,1,1,"","","","x"]
["Die Legaisierung führt zu mehr Konsum.",{"$nulls":5},31,0,1,"","x","",""]
[{"$nulls":6},32,0,1,"","x","",""]
["Burgener, Jan 09",{"$nulls":5},33,0,1,"","x","",""]
[{"$nulls":6},34,0,0,"x","","",""]
[{"$nulls":6},35,0,1,"","x","",""]
[{"$nulls":6},36,1,0,"","","x",""]
[{"$nulls":6},37,0,1,"","x","",""]
[{"$nulls":6},38,0,0,"x","","",""]
[{"$nulls":6},39,0,1,"","x","",""]
[{"$nulls":6},40,0,0,"x","","",""]
[{"$nulls":6},41,1,1,"","","","x"]
[{"$nulls":6},42,0,0,"x","","",""]
[{"$nulls":6},43,0,1,"","x","",""]
[{"$nulls":6},44,0,0,"x","","",""]
[{"$nulls":6},45,0,1,"","x","",""]
[{"$nulls":6},46,0,1,"","x","",""]
[{"$nulls":6},47,0,0,"x","","",""]
[{"$nulls":6},48,0,0,"x","","",""]
[{"$nulls":6},49,1,1,"","","","x"]
[{"$nulls":6},50,0,1,"","x","",""]
[{"$nulls":6},51,1,1,"","","","x"]
[{"$nulls":6},52,0,1,"","x","",""]
[{"$nulls":6},53,0,1,"","x","",""]
[{"$nulls":6},54,0,0,"x","","",""]
[{"$nulls":6},55,0,0,"x","","",""]
[{"$nulls":6},56,0,1,"","x","",""]
[{"$nulls":6},57,0,1,"","x","",""]
[{"$nulls":6},58,0,0,"x","","",""]
[{"$nulls":6},59,0,1,"","x","",""]
[{"$nulls":6},60,1,1,"","","","x"]
[{"$nulls":6},61,0,1,"","x","",""]
[{"$nulls":6},62,0,1,"","x","",""]
[{"$nulls":6},63,0,1,"","x","",""]
[{"$nulls":6},64,0,0,"x","","",""]
[{"$nulls":6},65,0,1,"","x","",""]
[{"$nulls":6},66,1,0,"","","x",""]
[{"$nulls":6},67,0,1,"","x","",""]
[{"$nulls":6},68,0,0,"x","","",""]
[{"$nulls":6},69,0,1,"","x","",""]
[{"$nulls":6},70,0,0,"x","","",""]
[{"$nulls":6},71,1,1,"","","","x"]
[{"$nulls":6},72,0,0,"x","","",""]
[{"$nulls":6},73,0,1,"","x","",""]
[{"$nulls":6},74,0,0,"x","","",""]
[{"$nulls":6},75,0,1,"","x","",""]
[{"$nulls":6},76,0,1,"","x","",""]
[{"$nulls":6},77,0,0,"x","","",""]
[{"$nulls":6},78,0,0,"x","","",""]
[{"$nulls":6},79,1,1,"","","","x"]
[{"$nulls":6},80,0,1,"","x","",""]
[{"$nulls":6},81,1,1,"","","","x"]
[{"$nulls":6},82,0,1,"","x","",""]
[{"$nulls":6},83,0,1,"","x","",""]
[{"$nulls":6},84,0,0,"x","","",""]
[{"$nulls":6},85,0,0,"x","","",""]
[{"$nulls":6},86,0,1,"","x","",""]
[{"$nulls":6},87,0,1,"","x","",""]
[{"$nulls":6},88,0,0,"x","","",""]
[{"$nulls":6},89,0,1,"","x","",""]
[{"$nulls":6},90,1,1,"","","","x"]
[{"$nulls":9},30,45,3,12]

{"sheet":"A6","index":10,"n_rows":19,"n_cols":3,"rows_kept":19,"flags":["formulas_cached_only"]}
["Aufabenstellung:"]
[]
["An einer Stichprobe von 40 Patienten wird ein Medikament mit einem Placebo verglichen."]
["Jeder Patient erhält zunächst das Medikament. Nach einer ausgiebigen Zeitspanne, bei welcher"]
["der Patient die Zeit bekommt, damit er das Medikament vollständig im Körper abbaut, erhält er "]
["dann das Placebo. Die Wirkung der Behandlung wird als \"schwach\" oder \"stark\" beurteilt."]
[]
["Nach Durchführung des Tests erhalten wir folgende Auswertung:"]
["11 Personen hatten sowohl beim Medikament, wie auch beim Placebo schwache Wirkung."]
["Bei 5 Personen war die Wirkung unter dem Medikament schwach,aber unter dem Placebo stark."]
["16 Personen hatten starke Wirkung unter Medikament, jedoch schwache Wirkung unter Placebo."]
["8 Personen hatten sowohl beim Medikament, wie auch beim Placebo starke Wikung."]
[]
["Hat das Medikant eine starke Wirkung?"]
[]
["(Alpha = 0.05)"]
[]
[]
["Crettaz Sabrina",null,"2009-01-01"]

{"sheet":"LA6","index":11,"n_rows":53,"n_cols":3,"rows_kept":53,"flags":["formulas_cached_only"]}
["McNemar Test"]
[]
[]
[]
["Stellen Sie die Hypothesen auf"]
["H0: Beide Behandlungen wirken gleich stark."]
["H1: Die Wirkung des Medikaments ist stärker als die des Placebos"]
[]
["Wählen Sie einen geeigneten Test"]
["McNemar Test (verbundener Zweistichprobentest)"]
[]
["Um was für einen Test handelt es sich?"]
["einseitiger Test"]
[]
["Berechnen Sie den Testwert"]
[5]
[]
["Berechnen Sie den p-Wert"]
[0.013301849365234378,null,"Somit Verwerfung der O-Hypothese"]
["(=> in Formel n= 21, weil die sich ändernden Fälle sind 16 + 5)"]
[]
["Ziehen Sie die Schlussfolgerungen aus dem Test"]
["Das Medikament hat eine deutlich stärkere Wirkung als das Placebo (p = 0.013)"]
["0.013 < 0.05 (Verwerfung der 0-Hypothese)"]
[]
["Da die Urliste der Daten nicht vorliegt (sondern die Angaben aus einer Kreutabelle)"]
["muss man die Auswertung mit R wie folgt machen: "]
["für den Test mit der chiquadratverteilten Teststatistik:"]
["crettaz=matrix(c(11,5,16,8),"]
["nrow = 2,"]
["       dimnames = list(\"ersteStich\" = c(\"schwach\", \"stark\"),"]
["                       \"zweiteStich\" = c(\"schwach\", \"stark\")))"]
["mcnemar.test(crettaz)"]
[]
["        McNemar's Chi-squared test with continuity correction"]
[]
["data:  crettaz "]
["McNemar's chi-squared = 4.7619, df = 1, p-value = 0.02910"]
["(für den einseitigen Test wird der p-Wert noch halbiert, oder im Test alternative = \"l\" eingegeben."]
[]
["Mit Binomialveteilung:"]
["> binom.test(crettaz,alternative=\"l\")"]
[]
["        Exact binomial test"]
[]
["data:  crettaz "]
["number of successes = 5, number of trials = 21, p-value = 0.01330"]
["alternative hypothesis: true probability of success is less than 0.5 "]
["95 percent confidence interval:"]
[" 0.0000000 0.4369763 "]
["sample estimates:"]
["probability of success "]
[0.2380952]

{"sheet":"A7","index":12,"n_rows":252,"n_cols":7,"rows_kept":252,"flags":["formulas_cached_only"]}
["Es soll überprüft werden, ob sich die Verkaufszahlen",{"$nulls":4},"Verkaufszahlen","1=Stichprobe1;2=Stichprobe2"]
["von einem Jahr zum anderen erhöht haben.",{"$nulls":4},2255.3,1]
["Dazu werden an verschiedenen Tagen die Verkaufszahlen",{"$nulls":4},2236.3,1]
["erhoben",{"$nulls":4},2221.4,1]
["Alpha = 0.05",{"$nulls":4},2603.5,1]
[{"$nulls":5},2735.5,1]
[{"$nulls":5},2357,1]
["Karlen Anja, Jan 09",{"$nulls":4},2689.8,1]
[{"$nulls":5},2386.8,1]
[{"$nulls":5},2458.7,1]
[{"$nulls":5},2730.3,1]
[{"$nulls":5},2604.3,1]
[{"$nulls":5},2394.1,1]
[{"$nulls":5},2255.9,1]
[{"$nulls":5},2038.6,1]
[{"$nulls":5},2469.5,1]
[{"$nulls":5},2424,1]
[{"$nulls":5},2500.5,1]
[{"$nulls":5},2099.7,1]
[{"$nulls":5},2333.4,1]
[{"$nulls":5},2462.8,1]
[{"$nulls":5},2706.5,1]
[{"$nulls":5},2291.4,1]
[{"$nulls":5},2409.5,1]
[{"$nulls":5},2245.9,1]
[{"$nulls":5},2269,1]
[{"$nulls":5},2606.3,1]
[{"$nulls":5},2668.9,1]
[{"$nulls":5},2433.3,1]
[{"$nulls":5},2405.8,1]
[{"$nulls":5},2719.9,1]
[{"$nulls":5},2430.8,1]
[{"$nulls":5},2460.2,1]
[{"$nulls":5},2465.9,1]
[{"$nulls":5},2301.6,1]
[{"$nulls":5},2388.4,1]
[{"$nulls":5},2565,1]
[{"$nulls":5},2551.9,1]
[{"$nulls":5},2220.4,1]
[{"$nulls":5},2378.7,1]
[{"$nulls":5},2375.9,1]
[{"$nulls":5},2055,1]
[{"$nulls":5},2363.8,1]
[{"$nulls":5},2480.4,1]
[{"$nulls":5},2373.6,1]
[{"$nulls":5},2450.1,1]
[{"$nulls":5},2161.1,1]
[{"$nulls":5},2331.5,1]
[{"$nulls":5},2196,1]
[{"$nulls":5},2117.1,1]
[{"$nulls":5},2262.1,1]
[{"$nulls":5},2629.7,1]
[{"$nulls":5},2500.4,1]
[{"$nulls":5},2186,1]
[{"$nulls":5},2500.3,1]
[{"$nulls":5},2382.7,1]
[{"$nulls":5},2479.5,1]
[{"$nulls":5},2663,1]
[{"$nulls":5},2314,1]
[{"$nulls":5},2820.4,1]
[{"$nulls":5},2495,1]
[{"$nulls":5},2675.3,1]
[{"$nulls":5},2115.9,1]
[{"$nulls":5},2495,1]
[{"$nulls":5},2648.3,1]
[{"$nulls":5},2254.7,1]
[{"$nulls":5},2611.2,1]
[{"$nulls":5},2268.6,1]
[{"$nulls":5},2132.1,1]
[{"$nulls":5},2769.3,1]
[{"$nulls":5},2072.2,1]
[{"$nulls":5},2179.8,1]
[{"$nulls":5},2341.3,1]
[{"$nulls":5},2426.1,1]
[{"$nulls":5},2594.5,1]
[{"$nulls":5},2278.8,1]
[{"$nulls":5},2408,1]
[{"$nulls":5},2433,1]
[{"$nulls":5},2459.2,1]
[{"$nulls":5},2361.3,1]
[{"$nulls":5},2356.3,1]
[{"$nulls":5},2395.7,1]
[{"$nulls":5},2459,1]
[{"$nulls":5},2097.8,1]
[{"$nulls":5},2345.8,1]
[{"$nulls":5},2520.2,1]
[{"$nulls":5},2354.6,1]
[{"$nulls":5},2184.3,1]
[{"$nulls":5},2754.7,1]
[{"$nulls":5},2344.2,1]
[{"$nulls":5},1976.7,1]
[{"$nulls":5},2480.1,1]
[{"$nulls":5},2310.2,1]
[{"$nulls":5},2511,1]
[{"$nulls":5},2654.3,1]
[{"$nulls":5},2483.6,1]
[{"$nulls":5},2475.6,1]
[{"$nulls":5},2373.3,1]
[{"$nulls":5},2420.7,1]
[{"$nulls":5},2198.6,1]
[{"$nulls":5},2306.8,1]
[{"$nulls":5},2263.3,1]
[{"$nulls":5},2417.3,1]
[{"$nulls":5},2501.3,1]
[{"$nulls":5},2142.6,1]
[{"$nulls":5},2421.4,1]
[{"$nulls":5},2402.8,1]
[{"$nulls":5},2219.1,1]
[{"$nulls":5},2207.6,1]
[{"$nulls":5},2630.1,1]
[{"$nulls":5},2173.1,1]
[{"$nulls":5},2306.4,1]
[{"$nulls":5},2281.1,1]
[{"$nulls":5},2377.8,1]
[{"$nulls":5},2130.8,1]
[{"$nulls":5},2558.6,1]
[{"$nulls":5},2056.7,1]
[{"$nulls":5},2610,1]
[{"$nulls":5},2427.1,1]
[{"$nulls":5},2493.1,1]
[{"$nulls":5},2024.7,1]
[{"$nulls":5},2447.4,1]
[{"$nulls":5},2537.3,1]
[{"$nulls":5},2207.8,1]
[{"$nulls":5},2502.5,2]
[{"$nulls":5},2562.7,2]
[{"$nulls":5},2602.6,2]
[{"$nulls":5},2097.3,2]
[{"$nulls":5},2680.6,2]
[{"$nulls":5},2313.8,2]
[{"$nulls":5},2776.2,2]
[{"$nulls":5},2356.8,2]
[{"$nulls":5},2584,2]
[{"$nulls":5},2531.5,2]
[{"$nulls":5},2409.7,2]
[{"$nulls":5},2425.5,2]
[{"$nulls":5},2248.1,2]
[{"$nulls":5},2188.4,2]
[{"$nulls":5},2539.4,2]
[{"$nulls":5},2443.2,2]
[{"$nulls":5},2654,2]
[{"$nulls":5},2327.8,2]
[{"$nulls":5},2368.3,2]
[{"$nulls":5},2640.3,2]
[{"$nulls":5},2695.8,2]
[{"$nulls":5},2636.9,2]
[{"$nulls":5},2303,2]
[{"$nulls":5},2577.7,2]
[{"$nulls":5},2476,2]
[{"$nulls":5},2363.7,2]
[{"$nulls":5},2719.3,2]
[{"$nulls":5},2478.7,2]
[{"$nulls":5},2794.6,2]
[{"$nulls":5},2659.5,2]
[{"$nulls":5},2323.8,2]
[{"$nulls":5},2615.3,2]
[{"$nulls":5},2691.3,2]
[{"$nulls":5},2673.1,2]
[{"$nulls":5},2597.6,2]
[{"$nulls":5},2385.7,2]
[{"$nulls":5},2548.8,2]
[{"$nulls":5},2551.3,2]
[{"$nulls":5},2286.3,2]
[{"$nulls":5},2408.2,2]
[{"$nulls":5},2328.3,2]
[{"$nulls":5},2693.5,2]
[{"$nulls":5},2634.1,2]
[{"$nulls":5},2424.5,2]
[{"$nulls":5},2549.3,2]
[{"$nulls":5},2410.3,2]
[{"$nulls":5},2550.3,2]
[{"$nulls":5},2629.4,2]
[{"$nulls":5},2420.6,2]
[{"$nulls":5},2364.5,2]
[{"$nulls":5},2506.1,2]
[{"$nulls":5},2678.4,2]
[{"$nulls":5},2364.7,2]
[{"$nulls":5},2842.6,2]
[{"$nulls":5},2467.9,2]
[{"$nulls":5},2634.8,2]
[{"$nulls":5},2725.3,2]
[{"$nulls":5},2504.6,2]
[{"$nulls":5},2217.5,2]
[{"$nulls":5},2739.8,2]
[{"$nulls":5},2540.3,2]
[{"$nulls":5},2241.4,2]
[{"$nulls":5},2445.1,2]
[{"$nulls":5},2606,2]
[{"$nulls":5},2381.1,2]
[{"$nulls":5},2395.9,2]
[{"$nulls":5},2809.9,2]
[{"$nulls":5},2497.9,2]
[{"$nulls":5},2565.8,2]
[{"$nulls":5},2715.5,2]
[{"$nulls":5},2423.4,2]
[{"$nulls":5},2177.7,2]
[{"$nulls":5},2519.4,2]
[{"$nulls":5},2673.4,2]
[{"$nulls":5},2434.3,2]
[{"$nulls":5},2584.8,2]
[{"$nulls":5},2425.5,2]
[{"$nulls":5},2506.4,2]
[{"$nulls":5},2480.5,2]
[{"$nulls":5},2796.6,2]
[{"$nulls":5},2553.4,2]
[{"$nulls":5},2807.6,2]
[{"$nulls":5},2467.6,2]
[{"$nulls":5},2725.8,2]
[{"$nulls":5},2610.2,2]
[{"$nulls":5},2762.6,2]
[{"$nulls":5},2491.2,2]
[{"$nulls":5},2586.3,2]
[{"$nulls":5},2454.7,2]
[{"$nulls":5},2185.2,2]
[{"$nulls":5},2327.8,2]
[{"$nulls":5},2490.3,2]
[{"$nulls":5},2514.2,2]
[{"$nulls":5},2710.9,2]
[{"$nulls":5},2280.9,2]
[{"$nulls":5},2414.2,2]
[{"$nulls":5},2294.2,2]
[{"$nulls":5},2460.5,2]
[{"$nulls":5},2485.2,2]
[{"$nulls":5},2494.8,2]
[{"$nulls":5},2532.9,2]
[{"$nulls":5},2361.8,2]
[{"$nulls":5},2391.6,2]
[{"$nulls":5},2529.5,2]
[{"$nulls":5},2521,2]
[{"$nulls":5},2366.1,2]
[{"$nulls":5},2385.7,2]
[{"$nulls":5},2522.9,2]
[{"$nulls":5},2507.5,2]
[{"$nulls":5},2367.9,2]
[{"$nulls":5},2453.5,2]
[{"$nulls":5},2528.9,2]
[{"$nulls":5},2565.2,2]
[{"$nulls":5},2446.3,2]
[{"$nulls":5},2646.2,2]
[{"$nulls":5},2268.5,2]
[{"$nulls":5},2270.5,2]
[{"$nulls":5},2672.6,2]
[{"$nulls":5},2628.7,2]
[{"$nulls":5},2400.3,2]
[{"$nulls":5},2486,2]
[{"$nulls":5},2242.3,2]
[{"$nulls":5},2345.6,2]
[{"$nulls":5},2222.2,2]
[{"$nulls":5},2100,2]
[{"$nulls":5},2354.1,2]
[{"$nulls":5},2367.3,2]
[{"$nulls":5},2003,2]

{"sheet":"LA7","index":13,"n_rows":129,"n_cols":11,"rows_kept":129,"flags":["formulas_cached_only"]}
[{"$nulls":9},"Verkaufszahlen2007","Verkaufszahlen2008"]
["H0: Es gibt keinen Unterschied zwischen beiden Jahren.",{"$nulls":8},2255.3,2502.5]
["HA: Im zweiten Jahr wurde mehr verkauft ",{"$nulls":8},2236.3,2562.7]
[{"$nulls":9},2221.4,2602.6]
["Einseitiger Test, rechtseitiger Test",{"$nulls":8},2603.5,2097.3]
[{"$nulls":9},2735.5,2680.6]
["Man denkt an den t-Test.",{"$nulls":8},2357,2313.8]
["Dazu muss man zuerst auf Varianzgleichheit testen: ",{"$nulls":8},2689.8,2776.2]
[null,"Verkauf 07","Verkauf 08",{"$nulls":6},2386.8,2356.8]
["Anzahl",123,128,{"$nulls":6},2458.7,2584]
["Mittelwert",2392.519512195121,2488.6906249999997,{"$nulls":6},2730.3,2531.5]
["Varianz",33145.98814074817,27554.29124999985,{"$nulls":6},2604.3,2409.7]
[{"$nulls":9},2394.1,2425.5]
[{"$nulls":9},2255.9,2248.1]
[1.2029337949582846,"Testwert",{"$nulls":7},2038.6,2188.4]
[{"$nulls":9},2469.5,2539.4]
[{"$nulls":9},2424,2443.2]
["FF (122,127) (1.2029338)",null,0.15159356722558337,"= p-Wert",{"$nulls":5},2500.5,2654]
[null,null,0.8484064327744166,{"$nulls":6},2099.7,2327.8]
[{"$nulls":9},2333.4,2368.3]
["Varianzen sind nicht verschieden",{"$nulls":8},2462.8,2640.3]
["Somit können wir den T-Test wählen, sofern die Daten pro Stichprobe normalverteilt sind.",{"$nulls":8},2706.5,2695.8]
[{"$nulls":9},2291.4,2636.9]
[{"$nulls":9},2409.5,2303]
[{"$nulls":9},2245.9,2577.7]
["PPPlot Verkaufszahlen 2007",{"$nulls":3},"PPPlot Verkaufszahlen 2008",{"$nulls":4},2269,2476]
[{"$nulls":9},2606.3,2363.7]
[{"$nulls":9},2668.9,2719.3]
[{"$nulls":9},2433.3,2478.7]
[{"$nulls":9},2405.8,2794.6]
[{"$nulls":9},2719.9,2659.5]
[{"$nulls":9},2430.8,2323.8]
[{"$nulls":9},2460.2,2615.3]
[{"$nulls":9},2465.9,2691.3]
[{"$nulls":9},2301.6,2673.1]
[{"$nulls":9},2388.4,2597.6]
[{"$nulls":9},2565,2385.7]
[{"$nulls":9},2551.9,2548.8]
[{"$nulls":9},2220.4,2551.3]
[{"$nulls":9},2378.7,2286.3]
[{"$nulls":9},2375.9,2408.2]
[{"$nulls":9},2055,2328.3]
[{"$nulls":9},2363.8,2693.5]
[{"$nulls":9},2480.4,2634.1]
[{"$nulls":9},2373.6,2424.5]
[{"$nulls":9},2450.1,2549.3]
[{"$nulls":9},2161.1,2410.3]
["Es kann davon ausgegangen werden, dass die Verkaufszahlen 07 und die Verkaufszahlen 08 normalverteilt sind.",{"$nulls":8},2331.5,2550.3]
[{"$nulls":9},2196,2629.4]
[{"$nulls":9},2117.1,2420.6]
["Ergebnisse mit Statistikprogramm R",{"$nulls":8},2262.1,2364.5]
[{"$nulls":9},2629.7,2506.1]
[{"$nulls":9},2500.4,2678.4]
["       Two Sample t-test",{"$nulls":8},2186,2364.7]
[{"$nulls":9},2500.3,2842.6]
["data:  Verkaufszahlen by Stichprobe ",{"$nulls":8},2382.7,2467.9]
["t = -4.3761, df = 249, p-value = 1",{"$nulls":8},2479.5,2634.8]
["alternative hypothesis: true difference in means is greater than 0 ",{"$nulls":8},2663,2725.3]
["95 percent confidence interval:",{"$nulls":8},2314,2504.6]
[" -132.4542       Inf ",{"$nulls":8},2820.4,2217.5]
["sample estimates:",{"$nulls":8},2495,2739.8]
["mean in group 1 mean in group 2 ",{"$nulls":8},2675.3,2540.3]
["       2392.520        2488.691 ",{"$nulls":8},2115.9,2241.4]
[{"$nulls":9},2495,2445.1]
[{"$nulls":9},2648.3,2606]
[{"$nulls":9},2254.7,2381.1]
[{"$nulls":9},2611.2,2395.9]
["Karlen Anja, Jan 09",{"$nulls":8},2268.6,2809.9]
[{"$nulls":9},2132.1,2497.9]
[{"$nulls":9},2769.3,2565.8]
[{"$nulls":9},2072.2,2715.5]
[{"$nulls":9},2179.8,2423.4]
[{"$nulls":9},2341.3,2177.7]
[{"$nulls":9},2426.1,2519.4]
[{"$nulls":9},2594.5,2673.4]
[{"$nulls":9},2278.8,2434.3]
[{"$nulls":9},2408,2584.8]
[{"$nulls":9},2433,2425.5]
[{"$nulls":9},2459.2,2506.4]
[{"$nulls":9},2361.3,2480.5]
[{"$nulls":9},2356.3,2796.6]
[{"$nulls":9},2395.7,2553.4]
[{"$nulls":9},2459,2807.6]
[{"$nulls":9},2097.8,2467.6]
[{"$nulls":9},2345.8,2725.8]
[{"$nulls":9},2520.2,2610.2]
[{"$nulls":9},2354.6,2762.6]
[{"$nulls":9},2184.3,2491.2]
[{"$nulls":9},2754.7,2586.3]
[{"$nulls":9},2344.2,2454.7]
[{"$nulls":9},1976.7,2185.2]
[{"$nulls":9},2480.1,2327.8]
[{"$nulls":9},2310.2,2490.3]
[{"$nulls":9},2511,2514.2]
[{"$nulls":9},2654.3,2710.9]
[{"$nulls":9},2483.6,2280.9]
[{"$nulls":9},2475.6,2414.2]
[{"$nulls":9},2373.3,2294.2]
[{"$nulls":9},2420.7,2460.5]
[{"$nulls":9},2198.6,2485.2]
[{"$nulls":9},2306.8,2494.8]
[{"$nulls":9},2263.3,2532.9]
[{"$nulls":9},2417.3,2361.8]
[{"$nulls":9},2501.3,2391.6]
[{"$nulls":9},2142.6,2529.5]
[{"$nulls":9},2421.4,2521]
[{"$nulls":9},2402.8,2366.1]
[{"$nulls":9},2219.1,2385.7]
[{"$nulls":9},2207.6,2522.9]
[{"$nulls":9},2630.1,2507.5]
[{"$nulls":9},2173.1,2367.9]
[{"$nulls":9},2306.4,2453.5]
[{"$nulls":9},2281.1,2528.9]
[{"$nulls":9},2377.8,2565.2]
[{"$nulls":9},2130.8,2446.3]
[{"$nulls":9},2558.6,2646.2]
[{"$nulls":9},2056.7,2268.5]
[{"$nulls":9},2610,2270.5]
[{"$nulls":9},2427.1,2672.6]
[{"$nulls":9},2493.1,2628.7]
[{"$nulls":9},2024.7,2400.3]
[{"$nulls":9},2447.4,2486]
[{"$nulls":9},2537.3,2242.3]
[{"$nulls":9},2207.8,2345.6]
[{"$nulls":10},2222.2]
[{"$nulls":10},2100]
[{"$nulls":10},2354.1]
[{"$nulls":10},2367.3]
[{"$nulls":10},2003]

{"sheet":"A8","index":14,"n_rows":32,"n_cols":8,"rows_kept":32,"flags":["formulas_cached_only"]}
[{"$nulls":5},"Die folgenden Daten wurden ermittelt (man hat es vor und nach dem Werbespot mit den gleichen Personen zu tun):"]
["Erarbeitet durch Joël Fischer",null,"2009-01-01",null,null,"0 = Abneigung gegenüber \"Hupsy\""]
[{"$nulls":5},"1 = Zuneigung zu \"Hupsy\""]
["Problemstellung:",{"$nulls":4},"Personen ID","Vor dem Werbespot","Nach dem Werbespot"]
["Bei meinem Test geht es darum, die Wirksamkeit eines TV-Spots zu prüfen.",{"$nulls":4},1,0,0]
["Die Marketingabteilung will wissen, ob es sich gelohnt hat, den Werbespot",{"$nulls":4},2,1,1]
["für die neue Hautcreme \"Hupsy\" im Fernsehen aus zu strahlen oder nicht.",{"$nulls":4},3,1,1]
[{"$nulls":5},4,1,1]
[{"$nulls":5},5,0,1]
[{"$nulls":5},6,0,0]
[{"$nulls":5},7,1,1]
[{"$nulls":5},8,1,0]
[{"$nulls":5},9,0,0]
[{"$nulls":5},10,0,1]
[{"$nulls":5},11,0,1]
[{"$nulls":5},12,1,1]
[{"$nulls":5},13,0,1]
[{"$nulls":5},14,0,1]
[{"$nulls":5},15,0,1]
[{"$nulls":5},16,0,1]
[{"$nulls":5},17,1,0]
[{"$nulls":5},18,0,1]
[{"$nulls":5},19,1,1]
[{"$nulls":5},20,0,0]
[{"$nulls":5},21,1,1]
[{"$nulls":5},22,0,1]
[{"$nulls":5},23,0,0]
[{"$nulls":5},24,1,1]
[{"$nulls":5},25,0,0]
[{"$nulls":5},26,0,1]
[{"$nulls":5},27,0,1]
[{"$nulls":5},28,0,1]

{"sheet":"LA8","index":15,"n_rows":40,"n_cols":4,"rows_kept":40,"merged":[[15,0,16,1],[15,2,15,3],[17,0,18,0],[21,2,21,3],[23,0,24,0]],"flags":["formulas_cached_only"]}
["Auswertung"]
[]
["Hypothesen"]
["Nullhypothese: Der TV-Spot zeigt keine Wirkung"]
["Alternativhypothese: Der TV-Spot zeigt eine Wirkung"]
[]
["Test"]
["McNemar Test"]
[]
["Zusammenfassung der Ausgewerteten Daten"]
["Es gibt 8 Personen, die \"Hupsy\" vor und nach dem Werbespot zugeneigt sind."]
["Es gibt 2 Personen, bei denen der Werbespot bewirkt hat, das sie gegenüber \"Hupsy\" vor dem Werbespot zugeneigt waren, nach dem Werbespot jedoch eine Ablehnung empfinden."]
["Es gibt 12 Personen, die vor dem Werbespot eine Ablehnung gegenüber \"Hupsy\" hatten, welche sich aber nach dem Werbespot das Produkt kaufen würden."]
["Es gibt 6 Personen, welche vor und nach dem Werbespot eine Ablehnung gegenüber \"Hupsy\" hatten."]
[]
[null,null,"Nachher"]
[null,null,"Zugeneigt","Ablehnung"]
["Vorher","Zugeneigt",8,2]
[null,"Ablehnung",12,6]
[]
[]
[null,null,"Nachher"]
[null,null,"Zugeneigt","Ablehnung"]
["Vorher","Zugeneigt","a","c"]
[null,"Ablehnung","b","d"]
[]
[]
["Es sind nur die ROT markierten Felder von interesse, da es sich nur bei denen Zahlen um Veränderungen handelt"]
[]
["Ermitteln des Erwartungswertes"]
["Der Testwert können wir also berechnen mit nur zwei Feldern. (Feld B und Feld C mit den Werten b und c)"]
["Testwert = ",2]
["Signifikanzniveau = ",{"v":0.006469726562500004,"d":"0.01"},"Mit einem Freiheitsgrad von 1"]
[null,"< 0.054"]
[]
["Somit können wir die Nullhypothese verwerfen, was heisst, dass der Werbespot erfolgreich war!"]
[]
["Mit chiquadratverteilter Teststatistik:"]
["Testwert",7.142857142857143]
["p-wert",0.007526315432321177,"<0.05"]

{"sheet":"A9","index":16,"n_rows":25,"n_cols":9,"rows_kept":25,"flags":["formulas_cached_only"]}
[{"$nulls":5},"Monat","Umsatz Verk mit Zusatzausbildung","Umsatz Verk ohne Zusatzausbildung","Differenz"]
[{"$nulls":5},"Januar",5520,5127,393]
["Es wird überprüft, ob ein Verkäufer mit Zusatzausbildung",{"$nulls":4},"Februar",7460,9874,-2414]
["einen besseren Umsatz erzielt als einer ohne.",{"$nulls":4},"März",6661,7482,-821]
["Dabei werden die Verkaufszahlen der letzen 2 Jahre",{"$nulls":4},"April",3658,3449,209]
["miteinander verglichen",{"$nulls":4},"Mai",3178,3012,166]
[{"$nulls":5},"Juni",6588,3984,2604]
[{"$nulls":5},"Juli",7896,6899,997]
[{"$nulls":5},"August",5963,5564,399]
[{"$nulls":5},"September",4712,5245,-533]
[{"$nulls":5},"Oktober",4987,6456,-1469]
["Briggeler","2009-01-01",{"$nulls":3},"November",3478,3125,353]
[{"$nulls":5},"Dezember",7614,7251,363]
[{"$nulls":5},"Januar",5987,5412,575]
[{"$nulls":5},"Februar",4259,3961,298]
[{"$nulls":5},"März",6018,5614,404]
[{"$nulls":5},"April",6841,6257,584]
[{"$nulls":5},"Mai",5980,4810,1170]
[{"$nulls":5},"Juni",5678,5222,456]
[{"$nulls":5},"Juli",4899,4750,149]
[{"$nulls":5},"August",4809,6321,-1512]
[{"$nulls":5},"September",9987,9256,731]
[{"$nulls":5},"Oktober",5478,5144,334]
[{"$nulls":5},"November",5790,9812,-4022]
[{"$nulls":5},"Dezember",6899,6421,478]

{"sheet":"LA9","index":17,"n_rows":49,"n_cols":7,"rows_kept":49,"flags":["formulas_cached_only"]}
["T-Test"]
["Monat","Umsatz Verk mit Zusatzausbildung","Umsatz Verk ohne Zusatzausbildung","Differenz"]
["Januar",5520,5127,393]
["Februar",7460,9874,-2414]
["März",6661,7482,-821]
["April",3658,3449,209]
["Mai",3178,3012,166]
["Juni",6588,3984,2604]
["Juli",7896,6899,997]
["August",5963,5564,399]
["September",4712,5245,-533]
["Oktober",4987,6456,-1469]
["November",3478,3125,353]
["Dezember",7614,7251,363]
["Januar",5987,5412,575]
["Februar",4259,3961,298]
["März",6018,5614,404]
["April",6841,6257,584]
["Mai",5980,4810,1170]
["Juni",5678,5222,456]
["Juli",4899,4750,149]
["August",4809,6321,-1512]
["September",9987,9256,731]
["Oktober",5478,5144,334]
["November",5790,9812,-4022,null,null,"Die Differenzen können als normalverteilt angesehen werden"]
["Dezember",6899,6421,478]
[]
[null,null,"Mittelwert",-4.5]
[null,null,"Standardabw",1305.8207147730636]
[null,null,"Alpha",0.05]
["H0: Der Umsatz steigt wegen der Zusatzausbildung nicht"]
["HA: Der Umsatz steigt wegen der Zusatzausbildung"]
[]
["Testwert",-0.016882415354300635]
[]
["P-Wert",0.5066619905426073]
["Die Nullhypothese wird angenommen da der p-Wert > Alpha"]
[]
["Mit R:"]
["    One Sample t-test"]
[null,"Test im R"]
["data:  briggel$mit - briggel$ohne "]
["t = -0.0169, df = 23, p-value = 0.5067"]
["alternative hypothesis: true mean is greater than 0 "]
["95 percent confidence interval:"]
[" -461.3317       Inf "]
["sample estimates:"]
["mean of x "]
[-4.5]

{"sheet":"A10","index":18,"n_rows":212,"n_cols":8,"rows_kept":212,"flags":["formulas_cached_only"]}
[{"$nulls":6},"Produktion","Maschine"]
["Es soll untersucht werden, ob sich die Produktionsmenge zweier",{"$nulls":5},27.58403459602045,1]
["Maschinen untescheidet. (Alpha = 0.05)",{"$nulls":5},29.68170078514891,1]
[{"$nulls":6},33.23792761842847,1]
[{"$nulls":6},32.14601043374163,1]
["Knubel, Jan 09",{"$nulls":5},30.828173333937663,1]
[{"$nulls":6},30.177234267695674,1]
[{"$nulls":6},31.839399727889088,1]
[{"$nulls":6},29.584446442689355,1]
[{"$nulls":6},29.32696937121117,1]
[{"$nulls":6},31.338006184978852,1]
[{"$nulls":6},26.78893284463213,1]
[{"$nulls":6},27.759704262842007,1]
[{"$nulls":6},30.42157252427891,1]
[{"$nulls":6},33.11434556964923,1]
[{"$nulls":6},31.670140708198282,1]
[{"$nulls":6},31.359498555699975,1]
[{"$nulls":6},26.110805105444637,1]
[{"$nulls":6},30.285766343436684,1]
[{"$nulls":6},31.121515053154702,1]
[{"$nulls":6},32.17077259499933,1]
[{"$nulls":6},28.762751960240582,1]
[{"$nulls":6},32.971207614206556,1]
[{"$nulls":6},28.680946495282065,1]
[{"$nulls":6},34.62775708353834,1]
[{"$nulls":6},29.03710216118583,1]
[{"$nulls":6},29.624806507711128,1]
[{"$nulls":6},31.362186356045623,1]
[{"$nulls":6},31.885925377998916,1]
[{"$nulls":6},35.23188994051191,1]
[{"$nulls":6},32.02858159621506,1]
[{"$nulls":6},31.391678358068695,1]
[{"$nulls":6},30.197606381667793,1]
[{"$nulls":6},29.415860657851674,1]
[{"$nulls":6},26.296330253717585,1]
[{"$nulls":6},29.12309524872021,1]
[{"$nulls":6},28.203655149429125,1]
[{"$nulls":6},34.793780214313166,1]
[{"$nulls":6},26.902330074414245,1]
[{"$nulls":6},31.74739748533115,1]
[{"$nulls":6},30.45261026301295,1]
[{"$nulls":6},30.025221205883387,1]
[{"$nulls":6},28.149607611392472,1]
[{"$nulls":6},26.88082297112587,1]
[{"$nulls":6},30.707435960133093,1]
[{"$nulls":6},30.40463305302365,1]
[{"$nulls":6},30.31840099580738,1]
[{"$nulls":6},28.394955509891247,1]
[{"$nulls":6},30.633633852501877,1]
[{"$nulls":6},25.373969297798613,1]
[{"$nulls":6},33.27862778826403,1]
[{"$nulls":6},29.725488821184044,1]
[{"$nulls":6},31.772436662537757,1]
[{"$nulls":6},30.132698594496418,1]
[{"$nulls":6},28.094713013403315,1]
[{"$nulls":6},26.47299907243596,1]
[{"$nulls":6},31.369194017314275,1]
[{"$nulls":6},34.3222803230716,1]
[{"$nulls":6},32.09921221440603,1]
[{"$nulls":6},30.74609256810281,1]
[{"$nulls":6},27.835265151306984,1]
[{"$nulls":6},30.969643483557135,1]
[{"$nulls":6},31.146070144759044,1]
[{"$nulls":6},29.222505141573695,1]
[{"$nulls":6},27.412258504151776,1]
[{"$nulls":6},30.366156582617762,1]
[{"$nulls":6},30.23984180960066,1]
[{"$nulls":6},30.1694691052853,1]
[{"$nulls":6},30.41716258491749,1]
[{"$nulls":6},35.11658832886335,1]
[{"$nulls":6},29.12844980919265,1]
[{"$nulls":6},32.2271753021812,1]
[{"$nulls":6},32.080746335491156,1]
[{"$nulls":6},34.06030515132736,1]
[{"$nulls":6},31.20769150547135,1]
[{"$nulls":6},35.09269398209159,1]
[{"$nulls":6},29.456030900576394,1]
[{"$nulls":6},31.81108817144448,1]
[{"$nulls":6},31.879619151704194,1]
[{"$nulls":6},29.054789147859662,1]
[{"$nulls":6},29.354090461165523,1]
[{"$nulls":6},31.18708276199991,1]
[{"$nulls":6},32.030767653764954,1]
[{"$nulls":6},32.51237276960053,1]
[{"$nulls":6},31.117272295808306,1]
[{"$nulls":6},27.022160799283217,1]
[{"$nulls":6},29.912626395493405,1]
[{"$nulls":6},27.694188013219303,1]
[{"$nulls":6},36.03597643273169,1]
[{"$nulls":6},30.72425732361491,1]
[{"$nulls":6},27.22526633511601,1]
[{"$nulls":6},26.46811964122573,1]
[{"$nulls":6},29.55099974802601,1]
[{"$nulls":6},25.818352222596843,1]
[{"$nulls":6},26.970113781858142,1]
[{"$nulls":6},30.1903456511956,1]
[{"$nulls":6},34.81006224113603,1]
[{"$nulls":6},34.402264940817474,1]
[{"$nulls":6},26.29046700821274,1]
[{"$nulls":6},29.16434617983196,1]
[{"$nulls":6},33.04098948602768,1]
[{"$nulls":6},27.274249536331357,1]
[{"$nulls":6},26.86882210485406,1]
[{"$nulls":6},25.699091423883065,1]
[{"$nulls":6},33.668029278000645,1]
[{"$nulls":6},28.725864,2]
[{"$nulls":6},27.2136195,2]
[{"$nulls":6},27.3462375,2]
[{"$nulls":6},22.908723000000002,2]
[{"$nulls":6},32.202894,2]
[{"$nulls":6},37.6026855,2]
[{"$nulls":6},28.0632255,2]
[{"$nulls":6},22.836609,2]
[{"$nulls":6},35.772174,2]
[{"$nulls":6},35.7328395,2]
[{"$nulls":6},27.1051485,2]
[{"$nulls":6},30.783321,2]
[{"$nulls":6},35.331873,2]
[{"$nulls":6},32.4363885,2]
[{"$nulls":6},33.990069,2]
[{"$nulls":6},30.8052435,2]
[{"$nulls":6},26.286039,2]
[{"$nulls":6},39.065740500000004,2]
[{"$nulls":6},27.7077465,2]
[{"$nulls":6},25.6330545,2]
[{"$nulls":6},28.148712,2]
[{"$nulls":6},29.6129265,2]
[{"$nulls":6},23.346327,2]
[{"$nulls":6},30.834006,2]
[{"$nulls":6},27.1221375,2]
[{"$nulls":6},33.637221,2]
[{"$nulls":6},28.929903,2]
[{"$nulls":6},28.202463,2]
[{"$nulls":6},25.592848500000002,2]
[{"$nulls":6},30.687507,2]
[{"$nulls":6},26.7750795,2]
[{"$nulls":6},28.4578815,2]
[{"$nulls":6},26.5989465,2]
[{"$nulls":6},27.549165,2]
[{"$nulls":6},26.940312,2]
[{"$nulls":6},29.425959,2]
[{"$nulls":6},34.9314675,2]
[{"$nulls":6},33.455325,2]
[{"$nulls":6},26.9613555,2]
[{"$nulls":6},32.358615,2]
[{"$nulls":6},32.7995085,2]
[{"$nulls":6},31.8810225,2]
[{"$nulls":6},31.0713225,2]
[{"$nulls":6},31.165749,2]
[{"$nulls":6},26.97117,2]
[{"$nulls":6},25.395429,2]
[{"$nulls":6},24.694315500000002,2]
[{"$nulls":6},28.7487285,2]
[{"$nulls":6},28.81104,2]
[{"$nulls":6},31.7176425,2]
[{"$nulls":6},35.688171,2]
[{"$nulls":6},31.2884865,2]
[{"$nulls":6},30.9099195,2]
[{"$nulls":6},27.638277,2]
[{"$nulls":6},29.6087355,2]
[{"$nulls":6},32.685241500000004,2]
[{"$nulls":6},28.6521975,2]
[{"$nulls":6},25.687884,2]
[{"$nulls":6},29.286096,2]
[{"$nulls":6},33.19521,2]
[{"$nulls":6},36.497979,2]
[{"$nulls":6},30.2405295,2]
[{"$nulls":6},35.2648785,2]
[{"$nulls":6},32.1555555,2]
[{"$nulls":6},29.98383405,2]
[{"$nulls":6},23.1088155,2]
[{"$nulls":6},30.4061775,2]
[{"$nulls":6},27.9797205,2]
[{"$nulls":6},32.373597000000004,2]
[{"$nulls":6},24.378909,2]
[{"$nulls":6},36.072213,2]
[{"$nulls":6},37.500723,2]
[{"$nulls":6},33.307014,2]
[{"$nulls":6},38.346057,2]
[{"$nulls":6},31.3177605,2]
[{"$nulls":6},28.4190135,2]
[{"$nulls":6},30.53655,2]
[{"$nulls":6},33.7738965,2]
[{"$nulls":6},27.6546405,2]
[{"$nulls":6},32.88246,2]
[{"$nulls":6},30.09158565,2]
[{"$nulls":6},29.99078916,2]
[{"$nulls":6},29.5556745,2]
[{"$nulls":6},32.3305605,2]
[{"$nulls":6},32.621496,2]
[{"$nulls":6},26.730306,2]
[{"$nulls":6},29.7969585,2]
[{"$nulls":6},25.512057,2]
[{"$nulls":6},29.576703,2]
[{"$nulls":6},27.0775185,2]
[{"$nulls":6},30.5294625,2]
[{"$nulls":6},30.721422,2]
[{"$nulls":6},30.0165696,2]
[{"$nulls":6},36.4991295,2]
[{"$nulls":6},28.18188,2]
[{"$nulls":6},30.276807,2]
[{"$nulls":6},27.366801,2]
[{"$nulls":6},32.9198055,2]
[{"$nulls":6},31.4139495,2]
[{"$nulls":6},28.7223045,2]
[{"$nulls":6},26.544366,2]
[{"$nulls":6},32.860515,2]
[{"$nulls":6},23.9885625,2]
[{"$nulls":6},31.744368,2]
[{"$nulls":6},37.735158,2]
[{"$nulls":6},28.1680875,2]
[{"$nulls":6},32.9858925,2]

{"sheet":"LA10","index":19,"n_rows":212,"n_cols":8,"rows_kept":212,"flags":["formulas_cached_only"]}
["Überprüfen auf Normalverteilung",{"$nulls":5},"Paroduktion","Maschine"]
["ppplot Maschine 1",{"$nulls":3},"ppplot Maschine 2",null,27.58403459602045,1]
[{"$nulls":6},29.68170078514891,1]
[{"$nulls":6},33.23792761842847,1]
[{"$nulls":6},32.14601043374163,1]
[{"$nulls":6},30.828173333937663,1]
[{"$nulls":6},30.177234267695674,1]
[{"$nulls":6},31.839399727889088,1]
[{"$nulls":6},29.584446442689355,1]
[{"$nulls":6},29.32696937121117,1]
[{"$nulls":6},31.338006184978852,1]
[{"$nulls":6},26.78893284463213,1]
[{"$nulls":6},27.759704262842007,1]
[{"$nulls":6},30.42157252427891,1]
[{"$nulls":6},33.11434556964923,1]
[{"$nulls":6},31.670140708198282,1]
[{"$nulls":6},31.359498555699975,1]
[{"$nulls":6},26.110805105444637,1]
[{"$nulls":6},30.285766343436684,1]
[null,null,"Daten sind beide Normalverteit",{"$nulls":3},31.121515053154702,1]
[{"$nulls":6},32.17077259499933,1]
[{"$nulls":6},28.762751960240582,1]
["Durchschnitt Maschine 1=",null,30.308776382846936,null,"s1",2.452979847981906,32.971207614206556,1]
["Durchschnitt Maschine 2=",null,30.197877135140196,null,"s2",3.5784053828801135,28.680946495282065,1]
[{"$nulls":6},34.62775708353834,1]
["n=",null,104,{"$nulls":3},29.03710216118583,1]
["m=",null,107,{"$nulls":3},29.624806507711128,1]
[{"$nulls":6},31.362186356045623,1]
["H0= Durchschittliche Produktion der beiden Maschinen unterscheiden sich nicht",{"$nulls":5},31.885925377998916,1]
["HA= Durchschnittliche Produktion der beiden Maschinen unterscheidet sich ( zweiseitiger Test; α=0.05)",{"$nulls":5},35.23188994051191,1]
["Testen der Voraussetzungen (Varianzgleichheit):",{"$nulls":5},32.02858159621506,1]
["      F test to compare two variances",{"$nulls":5},31.391678358068695,1]
[{"$nulls":6},30.197606381667793,1]
["data:  knubel$Produktion by knubel$Maschine ",{"$nulls":5},29.415860657851674,1]
["F = 0.4594, num df = 103, denom df = 106, p-value = 9.256e-05",{"$nulls":5},26.296330253717585,1]
["alternative hypothesis: true ratio of variances is not equal to 1 ",{"$nulls":5},29.12309524872021,1]
["95 percent confidence interval:",{"$nulls":5},28.203655149429125,1]
[" 0.3125990 0.6759518 ",{"$nulls":5},34.793780214313166,1]
["sample estimates:",{"$nulls":5},26.902330074414245,1]
["ratio of variances ",{"$nulls":5},31.74739748533115,1]
[0.4594276,{"$nulls":5},30.45261026301295,1]
[{"$nulls":6},30.025221205883387,1]
["Varianzen unterscheiden sich signifiant.",{"$nulls":5},28.149607611392472,1]
[{"$nulls":6},26.88082297112587,1]
[{"$nulls":6},30.707435960133093,1]
[{"$nulls":6},30.40463305302365,1]
["data:  knubel$Produktion by knubel$Maschine ",{"$nulls":5},30.31840099580738,1]
["t = 0.2612, df = 186.914, p-value = 0.7942",{"$nulls":5},28.394955509891247,1]
["alternative hypothesis: true difference in means is not equal to 0 ",{"$nulls":5},30.633633852501877,1]
["95 percent confidence interval:",{"$nulls":5},25.373969297798613,1]
[" -0.7266627  0.9484612 ",{"$nulls":5},33.27862778826403,1]
["sample estimates:",{"$nulls":5},29.725488821184044,1]
["mean in group 1 mean in group 2 ",{"$nulls":5},31.772436662537757,1]
["       30.30878        30.19788 ",{"$nulls":5},30.132698594496418,1]
[{"$nulls":6},28.094713013403315,1]
[{"$nulls":6},26.47299907243596,1]
[{"$nulls":6},31.369194017314275,1]
[{"$nulls":6},34.3222803230716,1]
[{"$nulls":6},32.09921221440603,1]
[{"$nulls":6},30.74609256810281,1]
[{"$nulls":6},27.835265151306984,1]
[{"$nulls":6},30.969643483557135,1]
[{"$nulls":6},31.146070144759044,1]
[{"$nulls":6},29.222505141573695,1]
[{"$nulls":6},27.412258504151776,1]
[{"$nulls":6},30.366156582617762,1]
[{"$nulls":6},30.23984180960066,1]
[{"$nulls":6},30.1694691052853,1]
[{"$nulls":6},30.41716258491749,1]
[{"$nulls":6},35.11658832886335,1]
[{"$nulls":6},29.12844980919265,1]
[{"$nulls":6},32.2271753021812,1]
[{"$nulls":6},32.080746335491156,1]
[{"$nulls":6},34.06030515132736,1]
[{"$nulls":6},31.20769150547135,1]
[{"$nulls":6},35.09269398209159,1]
[{"$nulls":6},29.456030900576394,1]
[{"$nulls":6},31.81108817144448,1]
[{"$nulls":6},31.879619151704194,1]
[{"$nulls":6},29.054789147859662,1]
[{"$nulls":6},29.354090461165523,1]
[{"$nulls":6},31.18708276199991,1]
[{"$nulls":6},32.030767653764954,1]
[{"$nulls":6},32.51237276960053,1]
[{"$nulls":6},31.117272295808306,1]
[{"$nulls":6},27.022160799283217,1]
[{"$nulls":6},29.912626395493405,1]
[{"$nulls":6},27.694188013219303,1]
[{"$nulls":6},36.03597643273169,1]
[{"$nulls":6},30.72425732361491,1]
[{"$nulls":6},27.22526633511601,1]
[{"$nulls":6},26.46811964122573,1]
[{"$nulls":6},29.55099974802601,1]
[{"$nulls":6},25.818352222596843,1]
[{"$nulls":6},26.970113781858142,1]
[{"$nulls":6},30.1903456511956,1]
[{"$nulls":6},34.81006224113603,1]
[{"$nulls":6},34.402264940817474,1]
[{"$nulls":6},26.29046700821274,1]
[{"$nulls":6},29.16434617983196,1]
[{"$nulls":6},33.04098948602768,1]
[{"$nulls":6},27.274249536331357,1]
[{"$nulls":6},26.86882210485406,1]
[{"$nulls":6},25.699091423883065,1]
[{"$nulls":6},33.668029278000645,1]
[{"$nulls":6},28.725864,2]
[{"$nulls":6},27.2136195,2]
[{"$nulls":6},27.3462375,2]
[{"$nulls":6},22.908723000000002,2]
[{"$nulls":6},32.202894,2]
[{"$nulls":6},37.6026855,2]
[{"$nulls":6},28.0632255,2]
[{"$nulls":6},22.836609,2]
[{"$nulls":6},35.772174,2]
[{"$nulls":6},35.7328395,2]
[{"$nulls":6},27.1051485,2]
[{"$nulls":6},30.783321,2]
[{"$nulls":6},35.331873,2]
[{"$nulls":6},32.4363885,2]
[{"$nulls":6},33.990069,2]
[{"$nulls":6},30.8052435,2]
[{"$nulls":6},26.286039,2]
[{"$nulls":6},39.065740500000004,2]
[{"$nulls":6},27.7077465,2]
[{"$nulls":6},25.6330545,2]
[{"$nulls":6},28.148712,2]
[{"$nulls":6},29.6129265,2]
[{"$nulls":6},23.346327,2]
[{"$nulls":6},30.834006,2]
[{"$nulls":6},27.1221375,2]
[{"$nulls":6},33.637221,2]
[{"$nulls":6},28.929903,2]
[{"$nulls":6},28.202463,2]
[{"$nulls":6},25.592848500000002,2]
[{"$nulls":6},30.687507,2]
[{"$nulls":6},26.7750795,2]
[{"$nulls":6},28.4578815,2]
[{"$nulls":6},26.5989465,2]
[{"$nulls":6},27.549165,2]
[{"$nulls":6},26.940312,2]
[{"$nulls":6},29.425959,2]
[{"$nulls":6},34.9314675,2]
[{"$nulls":6},33.455325,2]
[{"$nulls":6},26.9613555,2]
[{"$nulls":6},32.358615,2]
[{"$nulls":6},32.7995085,2]
[{"$nulls":6},31.8810225,2]
[{"$nulls":6},31.0713225,2]
[{"$nulls":6},31.165749,2]
[{"$nulls":6},26.97117,2]
[{"$nulls":6},25.395429,2]
[{"$nulls":6},24.694315500000002,2]
[{"$nulls":6},28.7487285,2]
[{"$nulls":6},28.81104,2]
[{"$nulls":6},31.7176425,2]
[{"$nulls":6},35.688171,2]
[{"$nulls":6},31.2884865,2]
[{"$nulls":6},30.9099195,2]
[{"$nulls":6},27.638277,2]
[{"$nulls":6},29.6087355,2]
[{"$nulls":6},32.685241500000004,2]
[{"$nulls":6},28.6521975,2]
[{"$nulls":6},25.687884,2]
[{"$nulls":6},29.286096,2]
[{"$nulls":6},33.19521,2]
[{"$nulls":6},36.497979,2]
[{"$nulls":6},30.2405295,2]
[{"$nulls":6},35.2648785,2]
[{"$nulls":6},32.1555555,2]
[{"$nulls":6},29.98383405,2]
[{"$nulls":6},23.1088155,2]
[{"$nulls":6},30.4061775,2]
[{"$nulls":6},27.9797205,2]
[{"$nulls":6},32.373597000000004,2]
[{"$nulls":6},24.378909,2]
[{"$nulls":6},36.072213,2]
[{"$nulls":6},37.500723,2]
[{"$nulls":6},33.307014,2]
[{"$nulls":6},38.346057,2]
[{"$nulls":6},31.3177605,2]
[{"$nulls":6},28.4190135,2]
[{"$nulls":6},30.53655,2]
[{"$nulls":6},33.7738965,2]
[{"$nulls":6},27.6546405,2]
[{"$nulls":6},32.88246,2]
[{"$nulls":6},30.09158565,2]
[{"$nulls":6},29.99078916,2]
[{"$nulls":6},29.5556745,2]
[{"$nulls":6},32.3305605,2]
[{"$nulls":6},32.621496,2]
[{"$nulls":6},26.730306,2]
[{"$nulls":6},29.7969585,2]
[{"$nulls":6},25.512057,2]
[{"$nulls":6},29.576703,2]
[{"$nulls":6},27.0775185,2]
[{"$nulls":6},30.5294625,2]
[{"$nulls":6},30.721422,2]
[{"$nulls":6},30.0165696,2]
[{"$nulls":6},36.4991295,2]
[{"$nulls":6},28.18188,2]
[{"$nulls":6},30.276807,2]
[{"$nulls":6},27.366801,2]
[{"$nulls":6},32.9198055,2]
[{"$nulls":6},31.4139495,2]
[{"$nulls":6},28.7223045,2]
[{"$nulls":6},26.544366,2]
[{"$nulls":6},32.860515,2]
[{"$nulls":6},23.9885625,2]
[{"$nulls":6},31.744368,2]
[{"$nulls":6},37.735158,2]
[{"$nulls":6},28.1680875,2]
[{"$nulls":6},32.9858925,2]