{"text_format":"3","workbook":"xls","n_sheets":9,"sheets":["Immobiliendaten","Ueberstundenbezug","Beispiel Ordinalskala","Personalführung","Umsatz","Französischwörter","AugenfarbeKörpergrösse","Zufriedenheit","Körpergrösse"],"not_rendered":{"external_links":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Immobiliendaten","index":0,"n_rows":120,"n_cols":7,"rows_kept":120,"flags":["formulas_cached_only"]}
["Tabelle 1",null,"Beispiel für Unübersichtlichkeit von Datensätzen"]
["Quelle: AlbuquerqueHomePrices; Internet: http://www.stat.cmu.edu/DASL/"]
["1.PRICE=Sellingprice($hundreds)","2.SQFT=Squarefeet of livingspace","3.AGE=Age of home (years)","4.FEATS=Number out of 11 features (dishwasher, refrigerator, microwave, disposer, washer, intercom, skylight(s), compactor, dryer, handicapfit, cableTVaccess","5.NE=Located in north east sector of city(1) or not(0)","6.COR=Cornerlocation(1)or not(0)","7.TAX=Annualtaxes($)"]
[2050,2650,13,7,1,1,1639]
[2080,2600,"*",4,1,1,1088]
[2150,2664,6,5,1,1,1193]
[2150,2921,3,6,1,1,1635]
[1999,2580,4,4,1,1,1732]
[1900,2580,4,4,1,0,1534]
[1800,2774,2,4,1,0,1765]
[1560,1920,1,5,1,1,1161]
[1450,2150,"*",4,1,0,"*"]
[1449,1710,1,3,1,1,1010]
[1375,1837,4,5,1,0,1191]
[1270,1880,8,6,1,0,930]
[1250,2150,15,3,1,0,984]
[1235,1894,14,5,1,1,1112]
[1170,1928,18,8,1,1,600]
[1180,1830,"*",3,1,0,733]
[1155,1767,16,4,1,0,794]
[1110,1630,15,3,1,0,867]
[1139,1680,17,4,1,0,750]
[995,1725,"*",3,1,0,923]
[995,1500,15,4,1,0,743]
[975,1430,"*",3,1,0,752]
[975,1360,"*",4,1,0,696]
[900,1400,16,2,1,0,731]
[960,1573,17,6,1,0,768]
[860,1385,"*",2,1,0,653]
[1695,2931,28,3,1,0,1142]
[1553,2200,28,4,1,0,1035]
[1250,2277,"*",4,1,1,"*"]
[1300,2000,"*",3,1,1,1076]
[1020,1478,53,3,1,0,626]
[1020,1713,30,4,1,0,600]
[922,1326,"*",4,1,0,668]
[925,1050,"*",2,1,0,553]
[899,1464,"*",2,1,1,566]
[850,1190,41,1,1,0,600]
[876,1156,"*",1,1,0,"*"]
[890,1746,"*",2,1,0,591]
[870,1280,"*",1,1,0,599]
[700,1215,"*",3,1,0,477]
[720,1121,46,4,1,0,398]
[720,1050,"*",1,1,0,"*"]
[749,1733,43,6,1,0,656]
[731,1299,"*",6,1,0,585]
[725,1140,"*",3,1,0,490]
[670,1181,"*",4,1,0,440]
[2150,2848,4,6,1,1,1487]
[1599,2440,"*",5,1,1,1265]
[1350,2253,23,4,1,1,939]
[1299,2743,25,5,1,1,1232]
[1250,2180,17,4,1,0,1141]
[1239,1706,14,4,1,0,810]
[1200,1948,"*",4,1,0,899]
[1125,1710,16,4,1,1,800]
[1100,1657,"*",4,1,0,865]
[1080,2200,26,4,1,0,1076]
[1050,1680,13,4,1,0,875]
[1049,1900,34,3,1,0,690]
[955,1565,"*",3,1,1,648]
[934,1543,20,3,1,0,820]
[875,1173,6,4,1,0,456]
[889,1549,"*",4,1,0,723]
[855,1900,"*",3,1,0,780]
[835,1560,"*",5,1,0,638]
[810,1365,"*",2,1,0,673]
[805,1258,7,4,1,0,821]
[799,1314,"*",2,1,0,671]
[750,1338,"*",3,1,0,649]
[759,997,4,4,1,0,461]
[755,1275,"*",5,1,0,"*"]
[750,1030,"*",1,1,0,486]
[730,1027,"*",3,1,0,427]
[729,1007,19,6,1,0,513]
[710,1083,22,4,1,0,504]
[773,1320,"*",5,1,0,"*"]
[690,1348,15,2,1,1,"*"]
[670,1350,"*",2,1,0,622]
[619,837,"*",2,1,0,342]
[1295,3750,"*",4,0,1,1200]
[975,1500,7,3,0,1,700]
[939,1428,40,2,0,0,701]
[820,1375,"*",1,0,0,585]
[780,1080,"*",3,0,1,600]
[770,900,"*",3,0,0,391]
[700,1505,"*",2,0,0,591]
[620,1480,"*",4,0,0,"*"]
[540,1142,"*",0,0,0,223]
[1070,1464,"*",2,0,0,376]
[2100,2116,25,3,0,1,1209]
[725,1280,"*",3,0,0,447]
[660,1159,"*",0,0,0,225]
[600,1198,"*",4,0,0,"*"]
[580,1051,15,2,0,0,426]
[1844,2250,40,6,0,1,915]
[1580,2563,"*",2,0,1,1189]
[699,1400,45,1,0,1,481]
[1330,1850,5,5,0,1,"*"]
[1160,1720,5,4,0,0,867]
[1109,1740,4,3,0,0,816]
[1129,1700,6,4,0,0,725]
[1050,1620,6,4,0,0,800]
[1045,1630,6,4,0,0,750]
[1050,1920,8,4,0,0,944]
[1020,1606,5,4,0,0,811]
[1000,1535,7,5,0,0,668]
[1030,1540,6,2,0,0,826]
[975,1739,13,3,0,0,880]
[950,1715,"*",3,0,0,900]
[940,1305,5,3,0,0,647]
[920,1415,7,4,0,0,866]
[945,1580,9,3,0,0,810]
[874,1236,3,4,0,0,707]
[872,1229,6,3,0,0,721]
[870,1273,4,4,0,0,638]
[869,1165,7,4,0,0,694]
[766,1200,7,4,0,0,634]
[739,970,4,4,0,0,541]

{"sheet":"Ueberstundenbezug","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"flags":["formulas_cached_only"]}
["Tabelle 1.1.1: und Tabelle 1.2.1",{"$nulls":4},"Bezug von Überstunden"]
["Person","Bezug von Überstunden",null,null,"Person","Bezug durch Überstunden (1 Bezug durch Geld; 2 Bezug durch Ferien)"]
[1,"Bezug durch Geld",null,null,1,1]
[2,"Bezug durch Ferien",null,null,2,2]
[3,"Bezug durch Ferien",null,null,3,2]
[4,"Bezug durch Ferien",null,null,4,2]
[5,"Bezug durch Geld",null,null,5,1]
[6,"Bezug durch Geld",null,null,6,1]
[7,"Bezug durch Ferien",null,null,7,2]
[8,"Bezug durch Geld",null,null,8,1]
[9,"Bezug durch Geld",null,null,9,1]
[10,"Bezug durch Ferien",null,null,10,2]
[11,"Bezug durch Ferien",null,null,11,2]
[12,"Bezug durch Geld",null,null,12,1]
[13,"Bezug durch Geld",null,null,13,1]
[14,"Bezug durch Ferien",null,null,14,2]
[15,"Bezug durch Ferien",null,null,15,2]
[16,"Bezug durch Geld",null,null,16,1]
[17,"Bezug durch Geld",null,null,17,1]

{"sheet":"Beispiel Ordinalskala","index":2,"n_rows":23,"n_cols":2,"rows_kept":23,"flags":["formulas_cached_only"]}
["Tabelle 1.3.1: Beispiel für Daten einer ordinalskalierten Variable"]
[]
["Personen","Personalführung (4 = \"sehr gut\";  3 = \"gut\"; 2 = \"recht gut\", 1 = \"schlecht\")"]
[1,4]
[2,3]
[3,4]
[4,1]
[5,2]
[6,3]
[7,3]
[8,4]
[9,3]
[10,4]
[11,3]
[12,1]
[13,2]
[14,2]
[15,1]
[16,2]
[17,3]
[18,3]
[19,4]
[20,3]

{"sheet":"Personalführung","index":3,"n_rows":27,"n_cols":2,"rows_kept":27,"merged":[[2,0,6,0]],"flags":["formulas_cached_only"]}
["Tabelle 1.3.1  Beispiel Personalführung"]
[]
["Personen","Personalführung "]
[null,"(4 = \"sehr gut\";  "]
[null,"3 = \"gut\"; "]
[null,"2 = \"recht gut\", "]
[null,"1 = \"schlecht\")"]
[1,4]
[2,3]
[3,4]
[4,1]
[5,2]
[6,3]
[7,3]
[8,4]
[9,3]
[10,4]
[11,3]
[12,1]
[13,2]
[14,2]
[15,1]
[16,2]
[17,3]
[18,3]
[19,4]
[20,3]

{"sheet":"Umsatz","index":4,"n_rows":22,"n_cols":2,"rows_kept":22,"flags":["formulas_cached_only"]}
["Tabelle 1.4.1 Umsatz mit Unternehmungen"]
[]
[]
["Unternehmung","Umsatz in Fr."]
[1,54907.43]
[2,25187.51]
[3,61348.31]
[4,25001.79]
[5,84718.87]
[6,62441.16]
[7,48867.09]
[8,74686.72]
[9,36554.36]
[10,42621.76]
[11,46823.83]
[12,24619.05]
[13,14209.21]
[14,37737.41]
[15,71026.32]
[16,73230.15]
[17,119375.88]
[18,57365.19]

{"sheet":"Französischwörter","index":5,"n_rows":24,"n_cols":3,"rows_kept":24,"flags":["formulas_cached_only"]}
["Tabelle 1.6.1 Beispiel mit Französischwörtern"]
[]
[]
[]
["Metrisch, diskret skaliert"]
["Person","Anzahl Wörter","Skalenwerte"]
[2,1,1]
[10,1,1]
[4,2,2]
[11,2,2]
[15,2,2]
[7,3,3]
[13,3,3]
[8,4,4]
[14,4,4]
[1,5,5]
[18,5,5]
[17,7,6]
[3,8,7]
[9,8,7]
[16,8,7]
[5,9,8]
[6,10,9]
[12,11,10]

{"sheet":"AugenfarbeKörpergrösse","index":6,"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":"Zufriedenheit","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"flags":["formulas_cached_only"]}
["Tabelle 1.7.3 und 1.7.4 Beispiel für ordinalskalierte Variable (Zufriedenheit)"]
["Person","Zufriedenheitsgrad",null,"Person","Skalenwert"]
[1,"zufrieden",null,1,2]
[2,"zufrieden",null,2,2]
[3,"unzufrieden",null,3,1]
[4,"unzufrieden",null,4,1]
[5,"sehr zufrieden",null,5,3]
[6,"sehr zufrieden",null,6,3]
[7,"sehr zufrieden",null,7,3]
[8,"sehr zufrieden",null,8,3]
[9,"zufrieden",null,9,2]
[10,"zufrieden",null,10,2]

{"sheet":"Körpergrösse","index":8,"n_rows":19,"n_cols":2,"rows_kept":19,"flags":["formulas_cached_only"]}
["Tabelle 1.7.5 Daten einer metrisch skalierten Variable (Körpergrösse)"]
[]
["Metrisch stetig skaliert"]
["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]