{"text_format":"3","workbook":"xls","n_sheets":9,"sheets":["Beispiel PearsonKorrelation","Beispiel SpearmanKorrelation","Unterschiede","IntraExtraGruppen","Uebung1","Uebung2","Uebung3","Uebung4","Uebung5"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Beispiel PearsonKorrelation","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"flags":["formulas_cached_only"]}
["Beispiel für Pearson-Korrelation (3.8.2)"]
["Person","Lebensdauer","Anzahl Zigaretten pro Tag"]
[1,70.8,25]
[2,84.3,13]
[3,91.9,10]
[4,83.9,14]
[5,63.7,29]
[6,70.4,27]
[7,72.5,24]
[8,73,23]
[9,91.3,10]
[10,68.2,28]
[11,89.2,10]
[12,74.7,21]
[13,82.3,14]
[14,85.7,12]
[15,84,13]
[16,63,33]
[17,78.1,17]
[18,79.4,15]
[19,76,19]
[20,62.2,34]
[]
["Überprüfen der Hypothese:"]
["Je mehr jemand raucht, desto weniger lange lebt er."]

{"sheet":"Beispiel SpearmanKorrelation","index":1,"n_rows":26,"n_cols":11,"rows_kept":26,"merged":[[3,0,3,4],[14,0,14,7]],"flags":["formulas_cached_only"]}
["Beispiel Spearman-Rangkkorrelation"]
[]
[]
["Wer spricht mit wem, wie oft?"]
[]
[null,null,"T","S","Mt","Ma","J","A","G",null,"Summen"]
["T=Tamara","T",0,3,1,5,2,4,10,null,25]
["S=Sophie","S",3,0,2,1,0,1,3,null,10]
["Mt=Martine","Mt",0,0,0,0,5,0,2,null,7]
["Ma=Marilyne","Ma",5,2,0,0,1,4,5,null,17]
["J=Jessica","J",0,0,4,1,0,2,1,null,8]
["A=Aline","A",4,1,0,4,2,0,3,null,14]
["G=Gesamt","G",0,0,0,0,0,0,0,null,0]
[]
["Anzahl der Vorschläge, die sich durchsetzen"]
[]
[null,null,"T","S","Mt","Ma","J","A","G"]
[null,"T",0,1,0,2,0,0,4,null,7]
[null,"S",1,0,0,0,0,1,2,null,4]
[null,"Mt",0,0,0,0,1,0,0,null,1]
[null,"Ma",3,0,0,0,0,2,1,null,6]
[null,"J",0,0,1,0,0,0,0,null,1]
[null,"A",0,0,0,1,0,0,0,null,1]
[null,"G",0,0,0,0,0,0,0,null,0]
[]
["Überprüfen der Hypothese: je mehr jemand spricht, desto mehr Einfluss hat er in der Gruppe."]

{"sheet":"Unterschiede","index":2,"n_rows":22,"n_cols":3,"rows_kept":22,"flags":["formulas_cached_only"]}
[null,"Anzahl Kommunikationsakte mit:","Geschlecht"]
["Anna",37,2]
["Beat",23,1]
["Ruth",21,2]
["Peter",21,1]
["Esther",28,2]
["Hans",30,1]
["Jens",24,1]
["Paul",25,1]
["Ida",17,2]
["Luise",29,2]
["Chris",27,1]
["Mél",23,2]
["Ernst",19,1]
["Erika",20,2]
["Walter",21,1]
["Beata",23,2]
["Edgar",25,1]
[]
[]
[]
["Überprüfung der Hypothese: Knaben reden mehr als Mädchen."]

{"sheet":"IntraExtraGruppen","index":3,"n_rows":23,"n_cols":20,"rows_kept":23,"flags":["formulas_cached_only"]}
[null,"Anzahl Kommunikationsakte mit:"]
[null,"Anna","Ernst","Walter","Edgar","Hans","Erika","Luise","Chris","Ruth","René","Mél","Ida","Esther","Peter","Jens","Beat","Beata","Paul","Guppen"]
["Anna",0,2,1,2,3,1,1,3,2,3,3,1,2,1,3,1,1,2,2]
["Ernst",3,0,1,3,1,1,1,1,1,4,1,1,3,2,1,3,2,3,2]
["Walter",1,1,0,2,0,0,3,0,1,1,3,0,0,0,0,1,2,1,1]
["Edgar",0,0,0,0,4,0,3,2,0,3,0,1,0,0,1,0,1,1,2]
["Hans",2,2,1,0,0,1,2,1,0,0,1,1,0,1,0,1,2,1,2]
["Erika",4,1,0,1,2,0,3,2,2,1,1,1,3,1,1,3,1,2,1]
["Luise",5,0,1,3,0,0,0,1,2,0,0,1,1,2,3,3,0,2,2]
["Chris",3,1,2,1,0,1,0,0,1,1,0,0,0,1,0,3,2,0,1]
["Ruth",1,0,4,3,3,3,2,0,0,1,0,1,4,3,1,1,3,1,1]
["René",0,0,2,0,1,1,1,0,2,0,1,0,3,1,1,0,3,0,2]
["Mél",1,0,1,1,0,0,0,1,1,0,0,1,2,0,0,0,0,2,1]
["Ida",1,0,0,0,1,0,1,1,1,0,3,0,1,3,1,0,1,1,1]
["Esther",5,2,1,2,1,2,3,3,0,1,2,0,0,0,1,1,1,0,1]
["Peter",3,0,3,1,4,4,3,3,1,1,0,1,3,0,3,2,1,1,1]
["Jens",2,4,0,0,2,0,2,1,2,1,1,1,2,1,0,1,0,1,2]
["Beat",4,4,3,2,2,5,3,4,3,3,5,4,1,2,1,0,3,3,1]
["Beata",2,1,1,3,5,1,1,1,1,4,1,3,3,1,6,2,0,4,2]
["Paul",0,1,0,1,1,0,0,3,1,0,1,0,0,2,1,1,0,0,2]
[]
[]
["Überprüfung der Hypothese: Knaben reden mehr mit Knaben als Mädchen mit Mädchen."]

{"sheet":"Uebung1","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"flags":["formulas_cached_only"]}
["Zigaretten und Lebensdauer"]
[]
["Person","Zigaretten pro Tag","Lebensdauer"]
[1,39,48]
[2,18,72]
[3,36,60]
[4,39,45]
[5,39,61]
[6,34,52]
[7,27,69]
[8,32,56]
[9,32,55]
[10,29,65]
[11,32,61]
[12,27,73]
[13,14,80]
[]
["Überprüfen Sie die folgende Hypothese:"]
["Je mehr jemand raucht, desto weniger lange lebt er."]

{"sheet":"Uebung2","index":5,"n_rows":19,"n_cols":3,"rows_kept":19,"flags":["formulas_cached_only"]}
["Person","Note Deutsch","Note Buchhaltung"]
[1,5,4.8]
[2,4,4.2]
[3,3.5,3]
[4,5.5,5.2]
[5,4.5,4]
[6,4.7,5]
[7,4.4,4.7]
[8,3.8,4]
[9,5.2,5.8]
[10,4.8,4.6]
[11,4.2,4]
[12,4,4.5]
[13,4.6,4]
[14,4.9,4.5]
[15,5.1,4.5]
[]
["Überprüfen Sie die folgende Hypothese:"]
["Je besser jemand in Deutsch ist, desto schlechter ist er in Buchhaltung"]

{"sheet":"Uebung3","index":6,"n_rows":22,"n_cols":3,"rows_kept":22,"flags":["formulas_cached_only"]}
["Hängige Verfahren der EU-Kommission gegen EU-Mitgliedstaaten und Bevölkerungsgrösse"]
[]
[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]
[]
[]
["Überprüfen Sie die folgende Hypothese:"]
["Je grösser ein EU-Mitgliedsland, desto weniger setzt es EU-Richtlinien um."]

{"sheet":"Uebung4","index":7,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[10,0,10,10]],"flags":["formulas_cached_only"]}
["Wer spricht wie häufig mit wem"]
[]
[null,"An","Au","C","E","L","S","{L, S}","{E,C}","G","Summen"]
["Anne (=An)",0,3,3,7,2,4,12,1,0,32]
["Audrey =(Au)",3,0,8,6,2,2,13,0,1,35]
["Céline (=C)",3,8,0,6,4,1,16,0,0,38]
["Evelyne (=E)",7,6,6,0,4,3,19,1,0,46]
["Laïna =(L)",2,2,4,4,0,2,15,0,0,29]
["Sophie (=S)",4,2,1,3,2,0,14,0,0,26]
[]
["Wer richtet wie viele Vorschläge an wen"]
[null,"An","Au","C","E","L","S","G",null,null,"Summen"]
["An",0,1,0,2,0,0,11,null,null,14]
["Au",0,0,0,0,0,0,5,null,null,5]
["C",0,0,0,0,0,0,5,null,null,5]
["E",0,0,0,0,0,0,7,null,null,7]
["L",0,0,0,0,0,0,1,null,null,1]
["S",0,0,0,0,0,0,4,null,null,4]
[]
[]
["Überprüfen Sie die folgende Hypothese:"]
["Je mehr jemand spricht, desto einflussreicher ist er in der Gruppe."]

{"sheet":"Uebung5","index":8,"n_rows":55,"n_cols":6,"rows_kept":55,"flags":["formulas_cached_only"]}
["Einkommen  (Steuerbares Nettoeinkommen in Tausend pro Monat)","Ausgaben für Schmuck (in Franken pro Jahr)",{"$nulls":3},"Überprüfen Sie die folgende Hypothese:"]
[6.845,281.23,{"$nulls":3},"Je mehr Einkommen jemand hat, desto mehr gibt er für Schmuck aus."]
[5.299,293.96]
[3.648,190.82]
[1.413,54.29]
[7.595,402.31]
[5.967,312.61]
[8.579,458.12]
[6.693,331.74]
[5.844,328.34]
[6.048,346.98]
[9.979,507.2]
[6.563,306.95]
[7.004,339.1]
[4.561,214.04]
[6.224,302.81]
[10.297,489.68]
[5.524,305.27]
[6.855,347.55]
[8.251,390.94]
[1.078,80.32]
[5.394,240.93]
[8.172,384.15]
[11.924,633.73]
[6.448,337.61]
[4.647,210.71]
[6.502,321.51]
[7.796,385.16]
[5.149,262.63]
[1.841,78.55]
[8.909,422.21]
[6.921,398.02]
[1.509,144.18]
[4.134,247.65]
[10.463,520.39]
[4.012,229.28]
[4.319,227.04]
[6.781,347.19]
[4.069,205.72]
[3.915,206.91]
[5.048,231.95]
[5.152,229.85]
[1.611,83.86]
[6.665,311.87]
[6.951,339.34]
[4.134,223.33]
[10.107,495.11]
[6.399,299.03]
[8.06,352.87]
[4.695,225.79]
[7.39,353.17]
[7.75,420.89]
[9.372,425.75]
[4.304,199.73]
[6.409,299.24]