{"text_format":"3","workbook":"xls","n_sheets":35,"sheets":["T4.1.1","T4.2.1","T4.2.2","T4.2.3","T4.2.4","T4.3.1.1","kontingenzkoeff","t4.3.2.1","t4.3.3.1","t4.3.4.1","Tabelle_5.3.16_Pearson","t4.3.6.1","Ü 1","L Ü 1","Ü 2","L Ü 2","Ü 3","L Ü 3","Ü 4","L Ü 4","Ü 5","L Ü 5","Ü 6","L Ü 6"," Ü 7","L Ü 7","Ü 8","L Ü 8","Ü9","Ü10","Ü11","Ü12","Ü 13","L_Ü 13","Üxx1"],"not_rendered":{"charts":8,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"T4.1.1","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"flags":["formulas_cached_only"]}
["Tabelle 1.7.1 und 1.7.2"]
["Augenfarbe","Körpergrösse",null,null,"Augenfarbe","Körpergrösse"]
["grün","< 1.70",null,null,1,1]
["blau","< 1.70",null,null,2,1]
["grün","< 1.70",null,null,1,1]
["andere","> 1.70",null,null,3,2]
["andere","> 1.70",null,null,3,2]
["grün","< 1.70",null,null,1,1]
["blau","> 1.70",null,null,2,2]
["blau","< 1.70",null,null,2,1]
["andere","< 1.70",null,null,3,1]
["grün","> 1.70",null,null,1,2]
["andere","< 1.70",null,null,3,1]
["andere","> 170",null,null,3,2]
["grün","> 1.70",null,null,1,2]

{"sheet":"T4.2.1","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"flags":["formulas_cached_only"]}
["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":"T4.2.2","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"flags":["formulas_cached_only"]}
["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":"T4.2.3","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"flags":["formulas_cached_only"]}
["Objekt","Alter","Prämien für Autounfallversicherung"]
[1,60,350]
[2,30,540]
[3,20,470]
[4,35,490]
[5,45,450]
[6,44,450]
[7,28,550]
[8,64,360]
[9,18,600]
[10,54,400]

{"sheet":"T4.2.4","index":4,"n_rows":50,"n_cols":4,"rows_kept":50,"flags":["formulas_cached_only"]}
["Beispiel für Boxplot (und spezielles Streudiagramm)"]
["Gruppe 1","Gruppe 2","Gruppe 3","Gruppe 4"]
[50000,42000,41000,50100]
[40000,38000,39000,51000]
[45000,50100,36000,38000]
[43000,52000,43500,49000]
[60200,48000,38000,45000]
[55000,37000,37500,55000]
[47000,25000,2800,42000]
[58000,37500,null,48000]
[null,41000,null,53000]
[{"$nulls":3},48000]
[]
["Darstellung in Tabelle der Urdaten"]
[]
[null,"Gruppen"]
[50000,1]
[40000,1]
[45000,1]
[43000,1]
[60200,1]
[55000,1]
[47000,1]
[58000,1]
[42000,2]
[38000,2]
[50100,2]
[52000,2]
[48000,2]
[37000,2]
[25000,2]
[37500,2]
[41000,2]
[41000,3]
[39000,3]
[36000,3]
[43500,3]
[38000,3]
[37500,3]
[28000,3]
[50100,4]
[51000,4]
[38000,4]
[49000,4]
[45000,4]
[55000,4]
[42000,4]
[48000,4]
[53000,4]
[48000,4]

{"sheet":"T4.3.1.1","index":5,"n_rows":111,"n_cols":4,"rows_kept":111,"flags":["formulas_cached_only"]}
["Tabelle 4.3.1.1"]
[null,null,"Rauchverhalten"]
[null,"Kreuztabelle","Nicht-Raucher","Raucher"]
["Geschlecht","männlich",20,30]
[null,"weiblich",25,26]
[]
[]
["Tabelle der Urdaten"]
["Geschlecht (1 = männlich; 2 = weiblich)","Rauchverhalten (1 = Nichtraucher; 2 = Raucher)"]
[]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]

{"sheet":"kontingenzkoeff","index":6,"n_rows":315,"n_cols":6,"rows_kept":315,"flags":["formulas_cached_only"]}
[]
["Kreuztabelle"]
[null,"schwarz","braun","rot","blond","Summen"]
["braun",37,62,14,5,118]
["blau",11,40,7,52,110]
["grau/gruen",12,42,13,10,77]
["Summen",60,144,34,67,305]
[]
["Als Urdaten:"]
["Augf","Haarf"]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]

{"sheet":"t4.3.2.1","index":7,"n_rows":912,"n_cols":6,"rows_kept":912,"flags":["formulas_cached_only"]}
["Beispiel Gamma"]
[null,null,"Zufriedenheit mit der Arbeit"]
[null,null,"sehr unzufrieden","etwas unzufrieden","ziemlich zufrieden","sehr zufrieden"]
[null,"< 6000",20,24,80,82]
[null,"6000-15000",22,38,104,125]
[null,"15000-25000",13,28,81,113]
[null,"> 25000",7,18,54,92]
[]
[]
["In Form der Tabelle der Urdaten"]
["Einkommen (1 = < 6000; 2 = 6000-15000; 3 = 15000 - 25000; 4 = > 25000)","Zufriedenheit (1 = sehr unzufrieden; 2 = etwas unzufrieden; 3 = ziemlich zufrieden; 4 = sehr zufrieden)"]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[1,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[2,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[3,1]
[4,1]
[4,1]
[4,1]
[4,1]
[4,1]
[4,1]
[4,1]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[1,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[2,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[3,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[4,2]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[1,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[2,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[3,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[4,3]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[1,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[2,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[3,4]
[4,4,null,113]
[4,4,null,92]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]
[4,4]

{"sheet":"t4.3.3.1","index":8,"n_rows":12,"n_cols":4,"rows_kept":12,"flags":["formulas_cached_only"]}
["Objekt","xi","yi","lnyi"]
[1,5,4]
[2,2,1.5]
[3,4,2]
[4,3,2.5]
[5,10,15]
[6,6,4.826809]
[7,7,7]
[8,8,8.15730721]
[9,9,11]
[10,1,1.3]
[11,11,18]

{"sheet":"t4.3.4.1","index":9,"n_rows":12,"n_cols":3,"rows_kept":12,"flags":["formulas_cached_only"]}
["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":"Tabelle_5.3.16_Pearson","index":10,"n_rows":18,"n_cols":2,"rows_kept":18,"flags":["formulas_cached_only"]}
["Tabelle 5.3.16 (Beispiel 5.3.15)"]
[]
["Einkommen","Ausgaben für Schmuck"]
[6.199,638]
[7.4,750.4]
[5.974,632.5]
[7.714,757.8]
[6.602,688.3]
[5.31,539.7]
[3.823,387.8]
[8.119,905.7]
[5.239,591.8]
[10.61,1058.6]
[9.804,945]
[3.411,350.2]
[6.391,637.7]
[4.205,415.6]
[7.702,716.1]

{"sheet":"t4.3.6.1","index":11,"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":"Ü 1","index":12,"n_rows":7,"n_cols":3,"rows_kept":7,"flags":["formulas_cached_only"]}
["Übung 1"]
["Proband","xi","yi"]
[1,1.5,3]
[2,2,10]
[3,3,12]
[4,4,20]
[5,5.2,25]

{"sheet":"L Ü 1","index":13,"n_rows":18,"n_cols":5,"rows_kept":18,"flags":["formulas_cached_only"]}
["Lösung Übung 1"]
["Proband","xi","yi",null,"Streudiagramm"]
[1,1.5,3]
[2,2,10]
[3,3,12]
[4,4,20]
[5,5.2,25]
{"$rows_empty":9}
[{"$nulls":4},"Korrelation: "]
[{"$nulls":4},0.9794261116248171]

{"sheet":"Ü 2","index":14,"n_rows":21,"n_cols":2,"rows_kept":21,"flags":["formulas_cached_only"]}
["Übung 2"]
["Zufriedenheit","Berufsgruppe"]
[2,5]
[3,2]
[2,4]
[2,3]
[2,3]
[1,4]
[1,3]
[3,1]
[1,4]
[3,4]
[3,1]
[3,3]
[2,3]
[2,2]
[3,2]
[2,3]
[2,3]
[1,3]
[1,3]

{"sheet":"L Ü 2","index":15,"n_rows":50,"n_cols":10,"rows_kept":50,"flags":["formulas_cached_only"]}
["Lösung Übung 2"]
["Zufriedenheit","Altergruppe",null,"Wir erstellen Kreuztabelle"]
[1,3,null,null,"Altergruppe",{"$nulls":4},"Randverteilung"]
[1,3,null,"Zufriedenheit",1,2,3,4,5]
[1,3,null,1,0,0,3,2,0,5]
[1,4,null,2,0,1,5,1,1,8]
[1,4,null,3,2,2,1,1,0,6]
[2,2,null,"Randverteilung",2,3,9,4,1,19]
[2,3]
[2,3,null,"(wir können die Tabelle ordnen nach Zufriedenheit, dann nach Alter "]
[2,3,null,"und dann nochmals nach Zufriedenheit,um das nebenstehende"]
[2,3,null,"Resultat zu erhalten. Dieses können wir nun leicht auszählen. "]
[2,3]
[2,4,null,"Graphische Darstellungen"]
[2,5,null,"1) Dreidimensional"]
[3,1]
[3,1]
[3,2]
[3,2]
[3,3]
[3,4]
{"$rows_empty":13}
[{"$nulls":3},"Zweidimensionales Säulendiagramm (nebeneinander)"]
{"$rows_empty":14}
[{"$nulls":3},"Zweidimensionles Säulendiagramm (übereinander)"]

{"sheet":"Ü 3","index":16,"n_rows":22,"n_cols":3,"rows_kept":22,"flags":["formulas_cached_only"]}
["Übung 3"]
["Person","Lebensalter","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]

{"sheet":"L Ü 3","index":17,"n_rows":24,"n_cols":5,"rows_kept":24,"flags":["formulas_cached_only"]}
[null,"Lösung Übung 3"]
["Person","Lebensalter","Zigaretten pro Tag"]
[1,70.8,25]
[2,84.3,13]
[3,91.9,10,null,"Streudiagramm:"]
[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]
[{"$nulls":4},"Korrelationskoeffizient"]
[{"$nulls":4},-0.9815856724784712]

{"sheet":"Ü 4","index":18,"n_rows":15,"n_cols":3,"rows_kept":15,"flags":["formulas_cached_only"]}
["Übung 4"]
["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]

{"sheet":"L Ü 4","index":19,"n_rows":17,"n_cols":7,"rows_kept":17,"flags":["formulas_cached_only"]}
["Übung Lösung 4"]
["Person","Zigaretten pro Tag","Lebensdauer","Ränge Zigaretten","Ränge Lebensdauer"]
[4,39,45,12,1,null,"Korrelation auf die Ränge"]
[1,39,48,12,2,null,-0.8440635370448925]
[6,34,52,9,3,null,"Deutlich negative Korrelation zwischen"]
[9,32,55,7,4,null,"Anzahl Zigaretten pro Tag und "]
[8,32,56,7,5,null,"Lebensdauer"]
[3,36,60,10,6]
[11,32,61,7,7.5]
[5,39,61,12,7.5]
[10,29,65,5,9]
[7,27,69,3.5,10]
[2,18,72,2,11]
[12,27,73,3.5,12]
[13,14,80,1,13]
[]
["Graphische Darstellung",null,"Nicht symetrisch: somit Rangkorrelation"]

{"sheet":"Ü 5","index":20,"n_rows":17,"n_cols":3,"rows_kept":17,"flags":["formulas_cached_only"]}
["Übung 5"]
["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]

{"sheet":"L Ü 5","index":21,"n_rows":20,"n_cols":7,"rows_kept":20,"flags":["formulas_cached_only"]}
["Lösung Übung 5"]
["Person","Note Deutsch","Note Buchhaltung","Ränge Deutsch","Ränge Buchhaltung",null,"Rankkorrelation"]
[3,3.5,3,1,1,null,0.7457529684539416]
[8,3.8,4,2,3.5]
[11,4.2,4,5,3.5]
[5,4.5,4,7,3.5]
[13,4.6,4,8,3.5]
[2,4,4.2,3.5,6]
[12,4,4.5,3.5,8]
[14,4.9,4.5,11,8]
[15,5.1,4.5,13,8]
[10,4.8,4.6,10,10]
[7,4.4,4.7,6,11]
[1,5,4.8,12,12]
[6,4.7,5,9,13]
[4,5.5,5.2,15,14]
[9,5.2,5.8,14,15]
[]
["Da die Daten ordinalskaliert sind, keine Streudiagramm. "]
["Wir müssen die Rangkorrelation verwenden. "]

{"sheet":"Ü 6","index":22,"n_rows":17,"n_cols":3,"rows_kept":17,"flags":["formulas_cached_only"]}
["Übung 6"]
[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":"L Ü 6","index":23,"n_rows":21,"n_cols":5,"rows_kept":21,"flags":["formulas_cached_only"]}
["Lösung Übung 6"]
[null,"Bevölkerung in Mio.","Hängige Verfahren","Ränge Bevölkererung","Ränge Verfahren"]
["Dänemark",5.1,75,3.5,1]
["Finnland",5.1,81,3.5,2]
["Schweden",8.8,101,6,3]
["Niederlande",15.5,114,10,4]
["Luxemburg",0.4,115,1,5]
["Irland",3.6,146,2,6]
["Österreich",8,163,5,7]
["GB",58.3,174,14,8]
["Portugal",9.8,199,7,9]
["Belgien",10.1,238,8,10]
["Griechenland",10.5,241,9,11]
["Spanien",39.8,291,11,12]
["Deutschland",81.6,293,15,13]
["Italien",57.2,329,12,14]
["Frankreich",58.1,419,13,15]
[]
[null,"Streudiagramm",null,null,"Rangkorrelation: "]
[null,"Nicht Symmetrisch",null,null,0.731010122105012]
[null,"Deshalb Rangkorrelation"]

{"sheet":" Ü 7","index":24,"n_rows":15,"n_cols":3,"rows_kept":15,"flags":["formulas_cached_only"]}
["Übung 7"]
[]
["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":"L Ü 7","index":25,"n_rows":17,"n_cols":5,"rows_kept":17,"flags":["formulas_cached_only"]}
["Lösung Übung 7"]
["Mitarbeiter","Vorgesetzer A","Vorgesetzter B","Ränge A","Ränge B"]
[6,4,3.5,1,1]
[1,5,4,2.5,3]
[4,5,4,2.5,3]
[9,9,4,10.5,3]
[3,7,5.5,6,5]
[12,7.5,6,7,6]
[2,6,7,4,8]
[11,6.5,7,5,8]
[8,8.5,7,9,8]
[5,8,7.5,8,10]
[7,9,8,10.5,11.5]
[10,9.5,8,12,11.5]
[]
["Sind ordinalskaliert. Somit Rangkorrelation"]
["Rangkorrelation",0.6791972603691117]

{"sheet":"Ü 8","index":26,"n_rows":20,"n_cols":6,"rows_kept":20,"flags":["formulas_cached_only"]}
["Übung 8",{"$nulls":4},"Hier wäre die Berechnung der multiplen Regression angebrachter."]
["Verkaufsstelle","Werbung pro Käufer","Verkauf pro Käufer in Franken","Preis pro Stück"]
[1,5,720,8]
[2,6,750,7]
[3,7,900,6]
[4,2,270,13]
[5,3,420,11]
[6,8,1215,5]
[7,6.2,900,7]
[8,7.4,1080,6]
[9,8.3,1245,5]
[10,2.8,375,11.5]
[11,3.4,480,10]
[12,4,450,9.5]
[13,4.8,600,8]
[14,5.1,735,7.5]
[15,6.7,975,6]
[16,2.4,350,12]
[17,3.3,450,10.5]
[18,4.7,675,9]

{"sheet":"L Ü 8","index":27,"n_rows":20,"n_cols":8,"rows_kept":20,"flags":["formulas_cached_only"]}
["Lösung Übung 8"]
["Verkaufsstelle","Werbung pro Käufer","Verkauf pro Käufer in Franken","Preis pro Stück",null,"Korr Werbung Verkauf","Korr Verkauf Preis","Korr Werbung Preis"]
[1,5,720,8,null,0.9846952805304005,-0.957093645168284,-0.9833017913589671]
[2,6,750,7]
[3,7,900,6,null,"rW,V/P=",0.8264660117567958]
[4,2,270,13,null,"rP,V/W=",0.351832428736684]
[5,3,420,11]
[6,8,1215,5]
[7,6.2,900,7]
[8,7.4,1080,6]
[9,8.3,1245,5]
[10,2.8,375,11.5]
[11,3.4,480,10]
[12,4,450,9.5]
[13,4.8,600,8]
[14,5.1,735,7.5]
[15,6.7,975,6]
[16,2.4,350,12]
[17,3.3,450,10.5]
[18,4.7,675,9]

{"sheet":"Ü9","index":28,"n_rows":7,"n_cols":5,"rows_kept":7,"flags":["formulas_cached_only"]}
["Übung 9"]
[]
[null,null,"Rauchverhalten"]
[null,null,"raucht nicht","raucht mässig","raucht viel"]
[null,"gut",120,50,20]
["Zustand der Zähne","mässig",80,60,30]
[null,"schlecht",30,65,50]

{"sheet":"Ü10","index":29,"n_rows":6,"n_cols":6,"rows_kept":6,"flags":["formulas_cached_only"]}
[]
[null,null,"Zufriedenheit mit Produkt"]
[null,null,"sehr zufrieden","zufrieden","knapp zufrieden","unzufrieden"]
["Produkt","Produkt A",20,30,10,5]
[null,"Produkt B",30,10,5,2]
[null,"Produkt C",10,20,30,15]

{"sheet":"Ü11","index":30,"n_rows":5,"n_cols":4,"rows_kept":5,"flags":["formulas_cached_only"]}
[]
[null,null,"Lungenkrebs"]
[null,null,"Kein","Lungenkrebs"]
["Rauchverhalten","Raucher",4,321]
[null,"Nichtraucher",2,554]

{"sheet":"Ü12","index":31,"n_rows":7,"n_cols":5,"rows_kept":7,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,"Wallis","Bern","übrige Schweiz"]
[null,"Marke A",8,6,32]
[null,"Marke B",2,10,44]
[null,"übrige",20,44,376]

{"sheet":"Ü 13","index":32,"n_rows":51,"n_cols":2,"rows_kept":51,"flags":["formulas_cached_only"]}
["Ausbildung in Jahren","Steurbares Netto-Einkommen pro Jahr"]
[18.1,52806.63]
[18.1,54384.1]
[14.3,44898.91]
[12.8,36481.05]
[15.2,45158.26]
[13,40688.39]
[16.3,56588.84]
[14,48797.95]
[16.1,50696.27]
[14.2,40370.74]
[15.6,46007.44]
[14.9,49857.39]
[16,48726.3]
[13.4,43887.67]
[13.4,52216.83]
[15.1,44597.14]
[11.9,35688.72]
[10.4,31406.24]
[12.5,33024.66]
[13.1,45107.25]
[8.1,30157.2]
[13.6,46062.01]
[10.8,30058.83]
[18.1,60695.44]
[15.3,44985.76]
[14.5,44065.53]
[15.7,53307.72]
[10,35638.44]
[14.9,52824.53]
[12,39414.05]
[13.8,54440]
[16.3,55159.39]
[15.4,50234.44]
[10.6,39889.03]
[13.9,47558.24]
[10.6,33342.92]
[15.4,50565.33]
[13.8,43286.47]
[11.4,25637.04]
[9.7,36196.56]
[12.6,35598.72]
[14.6,43447.21]
[9.9,31071.07]
[16.5,51024.66]
[16.2,51016.02]
[11.2,32525.94]
[17.4,57514.07]
[14.2,41023.27]
[12.1,41476.33]
[12.1,40087.05]

{"sheet":"L_Ü 13","index":33,"n_rows":51,"n_cols":13,"rows_kept":51,"flags":["formulas_cached_only"]}
["Ausbildung in Jahren","Steurbares Netto-Einkommen pro Jahr","xiyi","xi^2","residuen","xquer","yuer","n","sum xiyi","sum xi^2",null,3064.121810961459,"a mit Excel"]
[18.1,52806.63,955800.003,327.61000000000007,-4418.128979731562,13.782000000000005,43993.880999999994,50,31164619.72899999,9774.07,null,1764.1542013291546,"b mit Excel"]
[18.1,54384.1,984352.2100000001,327.61000000000007,-2840.658979731561,"a=",3064.121810961476]
[14.3,44898.91,642054.4130000001,204.49,-682.1860980780111,"b=",1764.1542013289145]
[12.8,36481.05,466957.44000000006,163.84000000000003,-4503.863381635827,"berechnung a und b."]
[15.2,45158.26,686405.552,231.04,-3180.545727943325]
[13,40688.39,528949.07,169,-909.3477438281188]
[16.3,56588.84,922398.092,265.69,4879.500279999062]
[14,48797.95,683171.2999999999,196,4136.090445210422,null,"Berechnung R^2:"]
[16.1,50696.27,816209.947,259.21000000000004,-400.2453578086497,null,"Var y-Daten",null,null,"Var Residuen"]
[14.2,40370.74,573264.5079999999,201.64,-4903.9439169818725,null,70133531.16027115,null,null,17078178.715639275]
[15.6,46007.44,717716.064,243.35999999999999,-3557.0144523279087,null,"SQT",null,null,"SQR"]
[14.9,49857.39,742875.111,222.01000000000002,2437.820815345105,null,3436543026.8532863,null,null,836830757.0663245]
[16,48726.3,779620.8,256,-2063.803176712492]
[13.4,43887.67,588094.778,179.56,1064.283531787296,null,"SQE=",2599712269.7869616]
[13.4,52216.83,699705.522,179.56,9393.4435317873]
[15.1,44597.14,673416.814,228.01,-3435.2535468471833]
[11.9,35688.72,424695.76800000004,141.61,-2538.4837517705164,null,"R^2",0.7564905340840212]
[10.4,31406.24,326624.896,108.16000000000001,-2224.781035328324,null,"Korrelation:","Korrelation^2"]
[12.5,33024.66,412808.25000000006,156.25,-7041.0168383473865,null,0.8697646429259003,0.7564905340840188]
[13.1,45107.25,590904.975,171.60999999999999,3203.1000750757375]
[8.1,30157.2,244273.32,65.61,3573.6591298830317,null,12.34]
[13.6,46062.01,626443.336,184.95999999999998,2625.7991695950113,null,39575.41734859355]
[10.8,30058.83,324635.36400000006,116.64000000000001,-4797.839759712908]
[18.1,60695.44,1098587.4640000002,327.61000000000007,3470.681020268443]
[15.3,44985.76,688282.128,234.09000000000003,-3659.4579090394764]
[14.5,44065.53,638950.1849999999,210.25,-2128.3904602703115]
[15.7,53307.72,836931.204,246.48999999999998,3436.853366575946]
[10,35638.44,356384.4,100,3233.067689056261]
[14.9,52824.53,787085.497,222.01000000000002,5404.9608153451045]
[12,39414.05,472968.60000000003,144,880.4340671333412]
[13.8,54440,751272,190.44000000000003,10390.964807402714]
[16.3,55159.39,899098.057,265.69,3450.0502799990645]
[15.4,50234.44,773610.376,237.16000000000003,1282.8099098643797]
[10.6,39889.03,422823.718,112.36,5645.184602479378]
[13.9,47558.24,661059.536,193.21,3202.7926263065674]
[10.6,33342.92,353434.952,112.36,-900.9253975206229]
[15.4,50565.33,778706.082,237.16000000000003,1613.6999098643792]
[13.8,43286.47,597353.2860000001,190.44000000000003,-762.5651925972852]
[11.4,25637.04,292262.256,129.96,-11058.102846289788]
[9.7,36196.56,351106.6319999999,94.08999999999999,4710.424232344696]
[12.6,35598.72,448543.872,158.76,-4773.369019443533,null,"Zeichnen Regressionsgerade:"]
[14.6,43447.21,634329.266,213.16,-3053.1226413664554,null,"x","y"]
[9.9,31071.07,307603.593,98.01,-1027.8901298475976,null,5,17084.763256136448]
[16.5,51024.66,841906.89,272.25,-1297.5040821932198,null,20,63046.59042055833]
[16.2,51016.02,826459.5239999999,262.44,-386.90753890478663]
[11.2,32525.94,364290.528,125.43999999999998,-3556.378484097495]
[17.4,57514.07,1000744.818,302.75999999999993,2434.196287941464]
[14.2,41023.27,582530.4339999999,201.64,-4251.413916981874]
[12.1,41476.33,501863.593,146.41,2636.301886037196]
[12.1,40087.05,485053.305,146.41,1247.021886037197]

{"sheet":"Üxx1","index":34,"n_rows":41,"n_cols":3,"rows_kept":41,"flags":["formulas_cached_only"]}
["Üxx1"]
[]
["In einer Firma werden zufällig Mitarbeiter ausgewählt und die Körpergröße bestimmt. Zudem muss jeder Befragte sein Einkommen angeben. "]
["Das Ergebnis der Untersuchung ist, dass Körpergröße und Einkommen positiv korrelieren, also größere Personen auch mehr verdienen. "]
["Bei einer genaueren Untersuchung stellt sich jedoch heraus, dass der Zusammenhang auf die Drittvariable Geschlecht zurückgeführt werden kann. "]
["Frauen sind im Durchschnitt kleiner als Männer, verdienen aber auch oftmals weniger. Berechnet man nun die Partialkorrelation zwischen Einkommen"]
[" und Körpergröße unter Kontrolle des Geschlechts, so verschwindet der Zusammenhang."]
[]
["Geschlecht (0 = männlich, 1 = weiblich)","Körpergrösse","Einkommen in Tausend"]
[0,1.7814972347590998,5.174456465992958]
[0,1.7750626848256483,5.1994777969060415]
[1,1.810343453758064,8.229153229369631]
[0,1.715367801566144,5.187017579549078]
[0,1.7916737840095058,5.240113385393455]
[0,1.7563354610343274,5.156672094526679]
[1,1.797254980129125,8.193924122896842]
[1,1.7726973757366835,8.227119681168391]
[0,1.7605815814992651,5.240524958148883]
[1,1.7809637731837689,8.175274559992467]
[0,1.7581073969921248,5.168087061313883]
[0,1.78519948189256,5.228545610733643]
[1,1.7953359108329243,8.195876262772465]
[0,1.7431949241158706,5.234886504868558]
[0,1.7758330603754988,5.215323627601549]
[0,1.7827217725678906,5.160851441988988]
[0,1.7843764253490144,5.173187994487739]
[0,1.7488016306195557,5.1999425474161285]
[1,1.823014659964684,8.164684870670317]
[1,1.7837031362964153,8.207282079732076]
[0,1.815287145651891,5.1684864214028305]
[1,1.7999364090270387,8.182828745803404]
[1,1.8241275624106765,8.189676203831873]
[1,1.8080872773976304,8.213567804209031]
[1,1.809029634956541,8.198953265544617]
[0,1.7927082401314631,5.218705062880376]
[1,1.822480491076091,8.204893111463083]
[1,1.7900701855732764,8.173402958326994]
[1,1.7860170085529543,8.205470439054093]
[1,1.7886471590239654,8.200446199779218]
[1,1.8180306511440696,8.205217462808143]
[0,1.8153872429764244,5.262486311287928]