{"text_format":"3","workbook":"xls","n_sheets":13,"sheets":["Bei1","Bei2","Bei3","Bei4","Bei5","Ueb1","Ueb2","Ue3","Ueb4","Ueb5","L Ue5","Tabelle2","Tabelle3"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Bei1","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"flags":["formulas_cached_only"]}
["Beispiel 1"]
["Objekt","Körpergrösse","Gewicht"]
[1,187,80]
[2,100,25]
[3,198,86]
[4,130,35]
[5,165,69]
[6,178,75]
[7,181,77]
[8,178,85]
[9,50,4]
[10,175,70]
[11,174,72]

{"sheet":"Bei2","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"flags":["formulas_cached_only"]}
["Beispiel 2"]
[]
["Objekt","Gewicht","Alter"]
[1,61,41]
[2,62,31]
[3,76,50]
[4,70,34]
[5,94,34]
[6,85,43]
[7,61,41]
[8,92,43]
[9,52,57]
[10,76,31]
[11,82,57]
[12,94,38]

{"sheet":"Bei3","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"flags":["formulas_cached_only"]}
["Beispiel 3"]
["Objekt","Alter","Prämien für Autounfallversicherung"]
[1,60,350]
[2,30,540]
[3,20,570]
[4,35,490]
[5,45,450]
[6,44,450]
[7,28,550]
[8,64,360]
[9,18,600]
[10,54,400]

{"sheet":"Bei4","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"flags":["formulas_cached_only"]}
[]
["Objekt","X","Y","lnY"]
[1,5,4,1.3862943611198906]
[2,2,1.5,0.4054651081081644]
[3,4,2,0.6931471805599453]
[4,3,2.5,0.9162907318741551]
[5,10,15,2.70805020110221]
[6,6,4.826809000000002,1.5741855868049466]
[7,7,7,1.9459101490553132]
[8,8,8.157307210000003,2.098914115739929]
[9,9,11,2.3978952727983707]
[10,1,1.3,0.26236426446749106]
[11,11,18,2.8903717578961645]

{"sheet":"Bei5","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"flags":["formulas_cached_only"]}
["Proband","Körpergrösse in cm","Schelligkeit beim Lösen einer Aufgabe in Sekunden","Alter in Jahren"]
[1,90,10,5]
[2,100,5,9]
[3,80,12,5]
[4,95,8,7]
[5,103,4,8]
[6,110,10,9]
[7,120,4,13]
[8,150,2,15]
[9,120,7,10]
[10,115,8,7]
[11,110,6,9]
[12,130,3,10]

{"sheet":"Ueb1","index":5,"n_rows":6,"n_cols":3,"rows_kept":6,"flags":["formulas_cached_only"]}
["Proband","xi","yi"]
[1,1.5,3]
[2,2,10]
[3,3,12]
[4,4,20]
[5,5.2,25]

{"sheet":"Ueb2","index":6,"n_rows":16,"n_cols":3,"rows_kept":16,"flags":["formulas_cached_only"]}
[null,"Bevölkerung in Mio.","Hängige Verfahren"]
["Frankreich",58.1,419]
["Italien",57.2,329]
["Deutschland",81.6,293]
["Spanien",39.8,291]
["Griechenland",10.5,241]
["Belgien",10.1,238]
["Portugal",9.8,199]
["GB",58.3,174]
["Österreich",8,163]
["Irland",3.6,146]
["Luxemburg",0.4,115]
["Niederlande",15.5,114]
["Schweden",8.8,101]
["Finnland",5.1,81]
["Dänemark",5.1,75]

{"sheet":"Ue3","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"flags":["formulas_cached_only"]}
["Mitarbeiter","Vorgesetzer A","Vorgesetzter B"]
[1,5,4]
[2,6,7]
[3,7,5.5]
[4,5,4]
[5,8,7.5]
[6,4,3.5]
[7,9,8]
[8,8.5,7]
[9,9,4]
[10,9.5,8]
[11,6.5,7]
[12,7.5,6]

{"sheet":"Ueb4","index":8,"n_rows":21,"n_cols":7,"rows_kept":21,"flags":["formulas_cached_only"]}
["Proband","Akoholkonsum (l reiner Alkohol pro Jahr)","Zigarettenkonsum","Lebenserwartung",null,null,"Hier wäre eine multiple Regression angebrachter"]
[1,0,10,81.6]
[2,1,12,81.3]
[3,2,15,77.4]
[4,3,15,71.2]
[5,5.2,17,70.1]
[6,5.2,19,66.7]
[7,6.5,20,65.9]
[8,7.7,20,64.7]
[9,8.8,20,62.6]
[10,9.4,20,61.9]
[11,9.9,21,59.7]
[12,16.1,22,58.1]
[13,17.6,22,58]
[14,18,23,57.6]
[15,19.1,24,56.3]
[16,20.5,24,53.9]
[17,24.7,24,51.6]
[18,24.9,25,50.7]
[19,37.5,26,47.5]
[20,45.6,28,29.5]

{"sheet":"Ueb5","index":9,"n_rows":58,"n_cols":4,"rows_kept":58,"flags":["formulas_cached_only"]}
["V1","V2",null,"Aufgabenstellng: Gibt es zwischen den beiden beiliegenden Variablen einen signifikanten Zusammenhang (metrisch skaliert)"]
[10.17,51.2]
[10.15,53.4]
[10.45,53.4]
[10.77,55.1]
[10.17,55.6]
[11.75,56]
[11.1,56.4]
[11.01,56.6]
[10.25,57.9]
[12.39,58.5]
[10.26,58.6]
[11.37,58.9]
[11.31,59.3]
[10.98,59.9]
[10.9,60.2]
[11.42,60.6]
[11.69,60.8]
[11.11,61.9]
[10.81,62.4]
[11.16,62.5]
[11.13,62.6]
[11.2,62.8]
[12.39,64.2]
[13.06,64.4]
[11.9,65.2]
[12.61,65.3]
[13.08,65.3]
[13.03,65.5]
[12.17,66.1]
[12.81,66.4]
[12.08,66.7]
[13.35,67]
[13.63,68]
[12.65,68.3]
[12.57,68.4]
[13.92,68.4]
[12.52,68.4]
[13.07,69.2]
[13.26,69.3]
[14.69,70.2]
[13.97,70.4]
[13.42,70.9]
[13.85,71.2]
[14.24,71.5]
[14.56,71.5]
[13.49,71.8]
[13.52,72.1]
[12.85,73.1]
[14.26,73.6]
[13.19,74.3]
[14.44,75.2]
[14.63,76.1]
[14.27,76.5]
[14.07,77.6]
[14.24,78.2]
[14.99,78.3]
[16.74,85.2]

{"sheet":"L Ue5","index":10,"n_rows":58,"n_cols":12,"rows_kept":58,"flags":["formulas_cached_only"]}
["V1","V2","Ränge V1","Ränge V2",null,"Quadrierte Abweichungen der Ränge"]
[10.17,51.2,2.5,1,null,2.25,null,"Die Überpüfung auf Normalverteilung ergab mit P-P-Plots"]
[10.15,53.4,1,2.5,null,2.25,null,"dass die Variable 1 vermutlich nicht normalverteilte Daten aufweist."]
[10.45,53.4,6,2.5,null,12.25,null,"Darum Spearman-Korrelations-Test"]
[10.77,55.1,7,4,null,9]
[10.17,55.6,2.5,5,null,6.25]
[11.75,56,21,6,null,225,null,null,"Beschreibung Vorgehen zum Auffinden verbundener Ränge: Am besten gibt man in eine neue Spalte"]
[11.1,56.4,12,7,null,25,null,null,"den Befehl (=wenn(Ax=A(x+1);1;)",null,null,"Hat es eine 1 zwischen Nullen, hat es dort zwei gleiche Ränge"]
[11.01,56.6,11,8,null,9,null,null,"Hat eine zwei 1 zwischen Nullen, hat es dort drei gleiche Ränge etc."]
[10.17,57.9,4,9,null,25]
[12.39,58.5,25.5,10,null,240.25,null,2617.5,"Testwert'","von D"]
[10.17,58.6,5,11,null,36,null,"n = ",57]
[11.37,58.9,18,12,null,36,null,"E(D)",30843]
[11.31,59.3,17,13,null,16,null,"V(D)",16969704.375]
[10.98,59.9,10,14,null,16]
[10.9,60.2,9,15,null,36,null,"Testwert bei mehr als 30 Daten",-6.851797285794289]
[11.42,60.6,19,16,null,9,null,"p-Wert",3.646392634249255e-12,"< 0.05"]
[11.69,60.8,20,17,null,9]
[11.11,61.9,13,18,null,25,null,"Variable x hat 1 Gruppe à 2 identischen Rängen, 2 Gruppen à drei identische Ränge und 1 Gruppe à vier identische Ränge"]
[10.81,62.4,8,19,null,121,null,"Variable y hat 3 Gruppen à 2 identischen Rängen und eine Gruppe à drei identischen Rängen"]
[11.16,62.5,15,20,null,25]
[11.13,62.6,14,21,null,49]
[11.2,62.8,16,22,null,36,null,"Man müsste nun noch die Spearman-Korrelation berechnen!"]
[12.39,64.2,25.5,23,null,6.25]
[13.06,64.4,34,24,null,100]
[11.9,65.2,22,25,null,9]
[12.61,65.3,29,26.5,null,6.25]
[13.08,65.3,36,26.5,null,90.25]
[13.03,65.5,33,28,null,25]
[12.17,66.1,24,29,null,25]
[12.81,66.4,31,30,null,1]
[12.08,66.7,23,31,null,64]
[13.35,67,39,32,null,49]
[13.63,68,43,33,null,100]
[12.65,68.3,30,34,null,16]
[12.39,68.4,27,36,null,81]
[12.57,68.4,28,36,null,64]
[13.92,68.4,45,36,null,81]
[13.07,69.2,35,38,null,9]
[13.26,69.3,38,39,null,1]
[14.69,70.2,55,40,null,225]
[13.97,70.4,46,41,null,25]
[13.42,70.9,40,42,null,4]
[13.85,71.2,44,43,null,1]
[14.24,71.5,48.5,44.5,null,16]
[14.56,71.5,53,44.5,null,72.25]
[13.49,71.8,41,46,null,25]
[13.52,72.1,42,47,null,25]
[12.85,73.1,32,48,null,256]
[14.24,73.6,50,49,null,1]
[13.19,74.3,37,50,null,169]
[14.44,75.2,52,51,null,1]
[14.63,76.1,54,52,null,4]
[14.27,76.5,51,53,null,4]
[14.07,77.6,47,54,null,49]
[14.24,78.2,48.5,55,null,42.25]
[14.69,78.3,56,56,null,0]
[16.74,85.2,57,57,null,0]

{"sheet":"Tabelle2","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Tabelle3","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}