{"text_format":"3","workbook":"xls","n_sheets":12,"sheets":["Überstunden","AugenfarbeKörpergrösse","Büroräume","Schulnoten","Zufriedenheit","Körpergrösse","Einkommen","Maschinenlebzeiten","Übung 2","Übung 3","Klassifizieren mit Excel","empirische Verteilungsfunktion"],"not_rendered":{"charts":3,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Überstunden","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"flags":["formulas_cached_only"]}
["Tabelle 2.1.1. Beispiel Bezug von Überstunden"]
["Mitarbeiter","Bezug von Überstunden",null,"(1 = Bezug durch Geld, 2 = Bezug durch Freizeit)"]
[1,1]
[2,2]
[3,2]
[4,2]
[5,1]
[6,1]
[7,2]
[8,1]
[9,1]
[10,2]
[11,2]
[12,1]
[13,1]
[14,2]
[15,2]
[16,1]
[17,1]

{"sheet":"AugenfarbeKörpergrösse","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"flags":["formulas_cached_only"]}
["Daten für Beispiel 2.1.3.",{"$nulls":3},"              Ausprägungen"]
[{"$nulls":4},"Drei Ausprägungen","zwei Ausprägungen"]
[{"$nulls":4},"1 = grün","1 für < 1.70 m"]
[{"$nulls":4},"2 = blau","2 für > 1.70 m"]
[{"$nulls":4},"3 = andere"]
[]
["StudentInnen","Augenfarbe","Körpergrösse"]
[1,1,1]
[2,2,1,null,null," "]
[3,1,1]
[4,3,2]
[5,3,2]
[6,1,1]
[7,2,2]
[8,2,1]
[9,3,1]
[10,1,2]
[11,3,1]
[12,3,2]
[13,1,2]

{"sheet":"Büroräume","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"flags":["formulas_cached_only"]}
["Tabelle 2.1.3. Beispiel Büroräume"]
["Firma","Anzahl Büroräume"]
[4,1]
[11,1]
[12,1]
[1,2]
[7,2]
[10,2]
[6,3]
[9,3]
[13,3]
[14,3]
[3,4]
[5,4]
[8,4]
[15,4]
[18,4]
[2,5]
[16,5]
[17,5]
[19,6]

{"sheet":"Schulnoten","index":3,"n_rows":16,"n_cols":2,"rows_kept":16,"flags":["formulas_cached_only"]}
["Tabelle 2.1.4. Beispiel Noten in der Schule"]
["Person","Noten"]
[1,5.2]
[2,4.1]
[3,3.8]
[4,3.1]
[5,4.8]
[6,5.6]
[7,5.3]
[8,3.5]
[9,4.3]
[10,4.6]
[11,4.2]
[12,3.7]
[13,4.6]
[14,4.5]

{"sheet":"Zufriedenheit","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"flags":["formulas_cached_only"]}
["Tabelle 2.1.5 Zufriedenheitsgrad"]
["Person","Zufriedensheitsgrad",null,null,"Person","Zufriedensheitsgrad"]
[1,"zufrieden",null,null,1,2]
[2,"zufrieden",null,null,2,2]
[3,"unzufrieden",null,null,3,1]
[4,"unzufrieden",null,null,4,1]
[5,"sehr zufrieden",null,null,5,3]
[6,"sehr zufrieden",null,null,6,3]
[7,"sehr zufrieden",null,null,7,3]
[8,"sehr zufrieden",null,null,8,3]
[9,"zufrieden",null,null,9,2]
[10,"zufrieden",null,null,10,2]

{"sheet":"Körpergrösse","index":5,"n_rows":17,"n_cols":2,"rows_kept":17,"flags":["formulas_cached_only"]}
["Tabelle 2.1.6 Beispiel Körpergrösse"]
["Person","Grösse"]
[1,176.25]
[2,179.59]
[3,163.31]
[4,189.95]
[5,161.55]
[6,169.23]
[7,188.37]
[8,183.16]
[9,178.41]
[10,190.11]
[11,183.14]
[12,171.65]
[13,179.31]
[14,175.57]
[15,180.03]

{"sheet":"Einkommen","index":6,"n_rows":52,"n_cols":1,"rows_kept":52,"flags":["formulas_cached_only"]}
["Tabelle 2.1.7 Beispiel Steuerbares Nettoeinkommen"]
["Steuerbares Einkommen"]
[15414.2]
[33574.7]
[41923.3]
[37068.6]
[50651.5]
[49524.6]
[28374.4]
[28259.1]
[44239.4]
[32790.8]
[38009.3]
[44958.3]
[33479.3]
[45956.8]
[38023.1]
[54790.3]
[35444]
[8155.2]
[64980.4]
[38558.9]
[24256.4]
[-5100.1]
[20504.3]
[24933.8]
[18271.2]
[35104.2]
[45663.2]
[30391.8]
[35791]
[19116.2]
[50165.9]
[25497]
[22652.7]
[9818.9]
[10491.3]
[17927.5]
[35007.3]
[35134]
[25165.6]
[41378.4]
[41639.5]
[32043]
[34620.8]
[29005.2]
[53899.3]
[1059815.1]
[523444.5]
[213860.7]
[142576.8]
[800433]

{"sheet":"Maschinenlebzeiten","index":7,"n_rows":14,"n_cols":2,"rows_kept":14,"flags":["formulas_cached_only"]}
["Tabelle 2.5.1 Beispiel Lebendauer von Maschinen"]
["Maschine","Lebenszeit von "]
[null,"Maschinen "]
[null,"(in Monaten)"]
[1,3]
[2,5]
[3,5.5]
[4,6]
[5,8]
[6,11]
[7,15]
[8,16]
[9,19]
[10,21]

{"sheet":"Übung 2","index":8,"n_rows":39,"n_cols":9,"rows_kept":39,"flags":["formulas_cached_only"]}
["Tabelle 2.8.1 "]
[]
[0.12]
[0.3]
[0.06]
[0.36]
[0.29]
[0.24]
[0.33]
[]
["Lösung mit Excel"]
["Geordnete Daten","rel. Häufigkeiten"]
[0.06,0.14285714285714285]
[0.12,0.2857142857142857]
[0.24,0.428571428571429]
[0.29,0.571428571428572]
[0.3,0.714285714285714]
[0.33,0.857142857142857]
[0.36,1]
{"$rows_empty":13}
["\\psline( ",0.06,",",0.14285714285714285,")(",0.12,",",0.14285714285714285,")"]
["\\psline( ",0.12,",",0.2857142857142857,")(",0.24,",",0.2857142857142857,")"]
["\\psline( ",0.24,",",0.42857142857142855,")(",0.29,",",0.42857142857142855,")"]
["\\psline( ",0.29,",",0.5714285714285714,")(",0.3,",",0.5714285714285714,")"]
["\\psline( ",0.3,",",0.7142857142857143,")(",0.33,",",0.7142857142857143,")"]
["\\psline( ",0.33,",",0.8571428571428571,")(",0.36,",",0.8571428571428571,")"]
["\\psline( ",0.36,",",1,")(",0.4,",",1,")"]

{"sheet":"Übung 3","index":9,"n_rows":52,"n_cols":3,"rows_kept":52,"flags":["formulas_cached_only"]}
["Übung 3"]
[]
["Lösung (Daten Siehe Beispiel Einkommen 2.1.7)"]
["geordnete Daten","Anzahlen","rel. Kum. Häufigkeiten"]
[-5100.1,1,0.020833333333333332]
[8155.2,2,0.041666666666666664]
[9818.9,3,0.0625]
[10491.3,4,0.08333333333333333]
[15414.2,5,0.10416666666666667]
[17927.5,6,0.125]
[18271.2,7,0.14583333333333334]
[19116.2,8,0.16666666666666666]
[20504.3,9,0.1875]
[22652.7,10,0.20833333333333334]
[24256.4,11,0.22916666666666666]
[24933.8,12,0.25]
[25165.6,13,0.2708333333333333]
[25497,14,0.2916666666666667]
[28259.1,15,0.3125]
[28374.4,16,0.3333333333333333]
[29005.2,17,0.3541666666666667]
[30391.8,18,0.375]
[32043,19,0.3958333333333333]
[32790.8,20,0.4166666666666667]
[33479.3,21,0.4375]
[33574.7,22,0.4583333333333333]
[34620.8,23,0.4791666666666667]
[35007.3,24,0.5]
[35104.2,25,0.5208333333333334]
[35134,26,0.5416666666666666]
[35444,27,0.5625]
[35791,28,0.5833333333333334]
[37068.6,29,0.6041666666666666]
[38009.3,30,0.625]
[38023.1,31,0.6458333333333334]
[38558.9,32,0.6666666666666666]
[41378.4,33,0.6875]
[41639.5,34,0.7083333333333334]
[41923.3,35,0.7291666666666666]
[44239.4,36,0.75]
[44958.3,37,0.7708333333333334]
[45663.2,38,0.7916666666666666]
[45956.8,39,0.8125]
[49524.6,40,0.8333333333333334]
[50165.9,41,0.8541666666666666]
[50651.5,42,0.875]
[53899.3,43,0.8958333333333334]
[54790.3,44,0.9166666666666666]
[64980.4,45,0.9375]
[142576.8,46,0.9583333333333334]
[213860.7,47,0.9791666666666666]
[523444.5,48,1]

{"sheet":"Klassifizieren mit Excel","index":10,"n_rows":45,"n_cols":10,"rows_kept":45,"flags":["formulas_cached_only"]}
["Beispiele für das Klassieren von Daten mit Excel"]
["(Daten von Beispiel 4)"]
[]
["Person","Noten",null,"5 incl. Bis und mit 6","4 incl bis ohne 5","3 incl bis ohne 4",{"$nulls":3},"Summen"]
[1,5.2,null,5.5,0,0,{"$nulls":3},5.5]
[2,4.1,null,0,4.5,0,{"$nulls":3},4.5]
[3,3.8,null,0,0,3.5,{"$nulls":3},3.5]
[4,3.1,null,0,0,3.5,{"$nulls":3},3.5]
[5,4.8,null,0,4.5,0,{"$nulls":3},4.5]
[6,5.6,null,5.5,0,0,{"$nulls":3},5.5]
[7,5.3,null,5.5,0,0,{"$nulls":3},5.5]
[8,3.5,null,0,0,3.5,{"$nulls":3},3.5]
[9,4.3,null,0,4.5,0,{"$nulls":3},4.5]
[10,4.6,null,0,4.5,0,{"$nulls":3},4.5]
[11,4.2,null,0,4.5,0,{"$nulls":3},4.5]
[12,3.7,null,0,0,3.5,{"$nulls":3},3.5]
[13,4.6,null,0,4.5,0,{"$nulls":3},4.5]
[14,4.5,null,0,4.5,0,{"$nulls":3},4.5]
[]
[]
[]
[]
[]
["Daten"]
[3]
[3,null,null,"Beispiel 2:"]
[4,null,null,"Klassengrenzen","Häufigkeiten","Wie Excel die Klassengrenzen interpretiert"]
[4,null,null,0,0,"< 0"]
[4,null,null,10,9,"0<x<10"]
[5,null,null,20,4,"10<x<20"]
[5,null,null,30,1,"20<x<30"]
[6,{"$nulls":3},3,"30<x"]
[10]
[11,null,null,"Beispiel 3: "]
[12,null,null,"Klassengrenzen","Häufigkeiten","Wie Excell die Klassengrenzen interpretiert"]
[13,null,null,3,2,"< 3"]
[20,null,null,10,7,"3 < x < 10"]
[23,null,null,17,3,"10 < x < 17"]
[31,null,null,24,2,"17 < x < 24"]
[34,null,null,31,1,"24 < x < 31"]
[54,{"$nulls":3},2,"31 < x"]
[]
["Vorgehen: Sei m die Anzahl der Klassengrenzen. In einer Spalte m Zellen beleuchten."]
["Dann rufen wir den Befehl Häufigkeiten auf, geben die Datenmatrix und die Matrix "]
["mit den Klassengrenzen ein. Dann CTRL+ Shift und Enter. "]

{"sheet":"empirische Verteilungsfunktion","index":11,"n_rows":20,"n_cols":3,"rows_kept":20,"flags":["formulas_cached_only"]}
["Empirische Verteilungsfunktion Daten Körpergrösse 2.1.6"]
[]
[null,"Person","i/n"]
[5,161.55,0.06666666666666667]
[3,163.31,0.13333333333333333]
[6,169.23,0.2]
[12,171.65,0.266666666666667]
[14,175.57,0.333333333333334]
[1,176.25,0.4]
[9,178.41,0.466666666666667]
[13,179.31,0.533333333333334]
[2,179.59,0.6]
[15,180.03,0.666666666666667]
[11,183.14,0.733333333333334]
[8,183.16,0.8]
[7,188.37,0.866666666666667]
[4,189.95,0.933333333333334]
[10,190.11,1]
[]
["Anzahl Daten",15]