{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Beispiel 1","Beispiel 2","Beispiel 3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Beispiel 1","index":0,"n_rows":57,"n_cols":8,"rows_kept":57,"flags":["formulas_cached_only"]}
["Beispiel 1"]
[]
["k = Anzahl erhobener Variablen "]
["n = Anzahl Daten pro Variable"]
[]
["Datenmatrix A ="]
["Variable für Konstantenberechnung","Variable 1","Variable 3","Variable 3",null,"n x (k+1)"," = 5 x 4 im Beispiel"," (an erster Stelle bei j x i steht jeweils die Zeilennummerierung, an zweiter Stelle die Spaltennummerierung)"]
[1,5,4,1]
[1,3,3,1]
[1,2,1,0]
[1,1,2,0]
[1,3,2,1]
[]
[]
["Transponierte Matrix A' =",{"$nulls":4},"(k+1) x n"," = 4 x 5 im Beispiel"]
[1,1,1,1,1]
[5,3,2,1,3]
[4,3,1,2,2]
[1,1,0,0,1]
[]
[]
["A*A' =",{"$nulls":4},"(k + 1) x (k + 1)"," = 4 x 4 (im Beispiel)"]
[5,14,12,3]
[14,48,39,11]
[12,39,34,9]
[3,11,9,3]
[]
[]
["Inverse Matrix von A*A' ="]
[1.558823529411764,-0.2647058823529419,-0.4411764705882345,0.735294117647059,null,"(k + 1) x (k + 1)"," = 4 x 4 (im Beispiel)"]
[-0.2647058823529426,0.4411764705882356,-0.26470588235294046,-0.5588235294117666]
[-0.44117647058823367,-0.26470588235294124,0.5588235294117637,-0.26470588235293946]
[0.7352941176470602,-0.5588235294117652,-0.2647058823529417,2.4411764705882373]
[]
[]
["(A*A')-1*A' ="]
[-0.7941176470588246,0.17647058823529393,0.5882352941176457,0.41176470588235303,0.6176470588235283,"(k+1) x n"," = 4 x 5 ( im Beispiel)"]
[0.32352941176470684,-0.2941176470588237,0.3529411764705881,-0.3529411764705879,-0.029411764705883248]
[0.20588235294117563,0.1764705882352945,-0.4117647058823525,0.4117647058823526,-0.38235294117646934]
[-0.6764705882352953,0.7058823529411771,-0.6470588235294118,-0.3529411764705883,0.9705882352941186]
[]
[]
[]
["Vektor y = ",{"$nulls":4},"n x 1 "," = 5 x 1 (im Beispiel)"]
[160]
[140]
[130]
[100]
[110]
[]
[]
["(A*A')-1*A'*y=",{"$nulls":4},"n x 1"," = 5 X 1 (im Beispiel)"]
[83.23529411764659,null,-3.82]
[17.94117647058828,null,15.29]
[3.2352941176471504,null,7.65]
[-22.058823529411754,null,-7.65]
[null,null,-11.47]

{"sheet":"Beispiel 2","index":1,"n_rows":119,"n_cols":7,"rows_kept":119,"flags":["formulas_cached_only"]}
["Beispiel 2"]
["Verkaufspreis in 100 $","Wohnfläche in Quadratfuss","Alter in Jahren","Anzahl Objekte (Features)","Lage (1 Nordost; 0 Nicht Nordost)","Cor (Eckhaus 1; nicht 0)","Steuern in $"]
[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":"Beispiel 3","index":2,"n_rows":40,"n_cols":6,"rows_kept":40,"flags":["formulas_cached_only"]}
["Beispiel 3"]
["Aus: Backhaus et al, Multivariate Analysemethoden: eine anwendungsorientierte Einführung, Berlin, Springer, 2003 (10.Auflage)"]
["Menge","Preis","Ausgaben für Verkaufsförderung","Vertreterbesuche",null,"Für Ausgabe SPSS siehe Homepage pdf-Datei."]
[2585,12.5,2000,109]
[1819,10,550,107]
[1647,9.95,1000,99]
[1496,11.5,800,70]
[921,12,0,81]
[2278,10,1500,102]
[1810,8,800,110]
[1987,9,1200,92]
[1612,9.5,1100,87]
[1913,12.5,1300,79]
[2118,8.5,1550,75]
[1438,12,550,106]
[1834,9.5,1980,66]
[1869,9,1600,80]
[1574,7,500,90]
[2597,11,2000,120]
[2026,10,1680,95]
[2016,9.5,1700,92]
[1566,10,1400,65]
[2169,13,1800,90]
[1996,11,1600,76]
[2501,8,2000,89]
[2604,8.5,1800,108]
[1277,10,460,78]
[1789,9,800,88]
[1824,11,1460,87]
[1813,12,1300,103]
[1513,11.5,600,89]
[1172,13,750,68]
[1987,9,900,106]
[2056,10.5,1250,96]
[1513,9,850,78]
[1756,12.5,950,86]
[2007,13,1500,125]
[2079,11,1850,109]
[1664,9.9,1200,60]
[1699,12.5,1600,79]