{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Pisa","Schmuckbeispiel","Summe quadrierter Abweichungen ","BerechnungsBeispiel_Von_Hand"],"not_rendered":{"charts":4,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Pisa","index":0,"n_rows":50,"n_cols":15,"rows_kept":50,"flags":["formulas_cached_only"]}
["Pisa-Studie Zusammenhang zwischen Gesamtbildungsinvestitionen pro Kopf und mittleren Resultaten"]
[]
[null,"Land",null,"xi Ausgaben pro Kopf","yi Mittlere Fähigkeit","xi*yi","(xi^2)*yi","xi^2","xi^3","xi^4","quadrierte Abweichungen lineares Modell","quadrierte Abweichungen quadratisches Modell","Residuen","erklärte Varianz"]
[1,"Australia",null,{"v":44623.3142835675,"d":"44623"},{"v":528.28,"d":"528"},{"v":23573604.46972304,"d":"23573604.47"},{"v":1051932361048.9628,"d":"1,051,932,361,049"},1991240177.6500394,88855736261344.5,3.9650374450877604e+18,786.2471033623932,{"v":209.20766210042507,"d":"209"},{"v":14.464012655567785,"d":"14"},{"v":0.23990186603487018,"d":"0"}]
[2,"Austria",null,{"v":71386.63407501757,"d":"71387"},{"v":507.13,"d":"507"},{"v":36202303.73846366,"d":"36202303.74"},{"v":2584360609650.346,"d":"2,584,360,609,650"},5096051524.56046,363789965411233,2.596974114097499e+19,109.9334783703865,{"v":266.8399893220379,"d":"267"},{"v":16.335237657347932,"d":"16"},{"v":17.6149167078421,"d":"18"}]
[3,"Belgium",null,46338,{"v":507.13,"d":"507"},23499389.94,{"v":1088914731039.72,"d":"1,088,914,731,040"},2147210244,99497428286472,4.6105118319385395e+18,33.372654717725396,{"v":52.68525723193289,"d":"53"},{"v":-7.258461078764071,"d":"-7"},{"v":1.3530929799999853,"d":"1"}]
[4,"Czech Republic",null,{"v":21384.459714688062,"d":"21384"},{"v":491.58,"d":"492"},{"v":10512172.706546357,"d":"10512172.71"},{"v":224797133756.98395,"d":"224,797,133,757"},457295117.2891166,9779009013392.666,2.091188242964669e+17,41.30626355552206,{"v":173.33072003100327,"d":"173"},{"v":13.16551252443304,"d":"13"},{"v":-14.84699490862738,"d":"-15"}]
[5,"Denmark",null,{"v":65794.21863575588,"d":"65794"},{"v":496.87,"d":"497"},{"v":32691173.413548026,"d":"32691173.41"},{"v":2150890211030.3887,"d":"2,150,890,211,030"},4328879205.889647,284815224920080.7,1.8739195179183776e+19,292.898055554864,{"v":19.1763306248078,"d":"19"},{"v":-4.379078741562864,"d":"-4"},{"v":13.984264680519118,"d":"14"}]
[6,"Finland",null,{"v":45362.91724715251,"d":"45363"},{"v":546.47,"d":"546"},{"v":24789473.38805143,"d":"24789473.39"},{"v":1124522829902.6665,"d":"1,124,522,829,903"},2057794261.1720066,93347550781211.08,4.2345172213124444e+18,2093.0570552023605,{"v":1047.9921833267645,"d":"1048"},{"v":32.37270738333086,"d":"32"},{"v":0.7200595060238584,"d":"1"}]
[7,"France",null,{"v":50480.722416965145,"d":"50481"},{"v":504.74,"d":"505"},{"v":25479639.832738988,"d":"25479639.83"},{"v":1286230625680.745,"d":"1,286,230,625,681"},2548303335.7386875,128640193325651.02,6.493849890936922e+18,0.48638098662056195,{"v":97.51273961859062,"d":"98"},{"v":-9.87485390365805,"d":"-10"},{"v":4.0425898003179555,"d":"4"}]
[8,"Germany",null,{"v":41978.09289312306,"d":"41978"},{"v":483.99,"d":"484"},{"v":20316977.17934263,"d":"20316977.18"},{"v":852867955341.9061,"d":"852,867,955,342"},1762160282.9436686,73972128049981.33,3.10520886278411e+18,211.19639553639485,{"v":806.1668484419351,"d":"806"},{"v":-28.393077473953667,"d":"-28"},{"v":-1.4774023128555882,"d":"-1"}]
[9,"Greece",null,{"v":27356.29096258388,"d":"27356"},{"v":473.8,"d":"474"},{"v":12961410.658072243,"d":"12961410.66"},{"v":354576121247.7601,"d":"354,576,121,248"},748366655.2295485,20472535967155.223,5.600526506594618e+17,231.95221939674684,{"v":346.97455723309383,"d":"347"},{"v":-18.627253078033107,"d":"-19"},{"v":-10.970022344180961,"d":"-11"}]
[10,"Hungary",null,{"v":20276.72338323882,"d":"20277"},{"v":479.97,"d":"480"},{"v":9732218.922253137,"d":"9732218.92"},{"v":197337510991.64948,"d":"197,337,510,992"},411145511.1603839,8336683800059.433,1.6904063134733334e+17,19.925970996408342,{"v":20.50844297875698,"d":"21"},{"v":4.52862484411736,"d":"5"},{"v":-15.566148412367568,"d":"-16"}]
[11,"Ireland",null,{"v":31015.146921554322,"d":"31015"},{"v":526.67,"d":"527"},{"v":16334747.429175014,"d":"16334747.43"},{"v":506624591442.3448,"d":"506,624,591,442"},961939338.5656005,29834689915234.887,9.25327291080025e+17,1243.5959957395949,{"v":747.3143968030263,"d":"747"},{"v":27.337051721117007,"d":"27"},{"v":-8.594656467057746,"d":"-9"}]
[12,"Italy",null,{"v":60824.01266316812,"d":"60824"},{"v":487.47,"d":"487"},{"v":29649881.452914566,"d":"29649881.45"},{"v":1803424764953.509,"d":"1,803,424,764,954"},3699560516.449236,225022115700665.12,1.3686748014870137e+19,542.3103231869306,{"v":423.0305497285594,"d":"423"},{"v":-20.567706477110164,"d":"-21"},{"v":10.757557261055354,"d":"11"}]
[13,"Japan",null,{"v":53254.664056884925,"d":"53255"},{"v":522.23,"d":"522"},{"v":27811183.210427016,"d":"27811183.21"},{"v":1481075218895.769,"d":"1,481,075,218,896"},2836059243.8116713,151033382274613.66,8.043232034409629e+18,268.5186783460339,{"v":70.19343787240926,"d":"70"},{"v":8.378152414011652,"d":"8"},{"v":5.843460452370266,"d":"6"}]
[14,"Korea",null,{"v":30844.19967573212,"d":"30844"},{"v":524.75,"d":"525"},{"v":16185493.77984043,"d":"16185493.78"},{"v":499228601995.71844,"d":"499,228,601,996"},951364653.6364335,29344081341195.883,9.050947041887711e+17,1119.2796556750716,{"v":661.0695905708238,"d":"661"},{"v":25.711273608493684,"d":"26"},{"v":-8.705637128517992,"d":"-9"}]
[15,"Mexico",null,{"v":11238.526458208506,"d":"11239"},{"v":421.96,"d":"422"},{"v":4742208.624305661,"d":"4742208.62"},{"v":53295437094.60373,"d":"53,295,437,095"},126304476.95185262,1419476206013.582,1.595282089808107e+16,3204.2577758428383,{"v":617.6212377364541,"d":"618"},{"v":-24.85198659537008,"d":"-25"},{"v":-21.433836238066476,"d":"-21"}]
[16,"Norway",null,{"v":61677.06340703509,"d":"61677"},{"v":505.28,"d":"505"},{"v":31164186.59830669,"d":"31164186.60"},{"v":1922115512852.435,"d":"1,922,115,512,852"},3804060150.5154276,234623259107515.5,1.4470873628739457e+19,36.377379860714115,{"v":3.097512315989134,"d":"3"},{"v":-1.759975089593354,"d":"-2"},{"v":11.31136633448125,"d":"11"}]
[17,"Poland",null,{"v":16153.92676584594,"d":"16154"},{"v":479.12,"d":"479"},{"v":7739669.392052107,"d":"7739669.39"},{"v":125026052551.06909,"d":"125,026,052,551"},260949349.95631385,4215356688789.397,6.809456324262275e+16,6.955302740845785,{"v":248.75509948316508,"d":"249"},{"v":15.771971959243558,"d":"16"},{"v":-18.242709204345147,"d":"-18"}]
[18,"Portugal",null,{"v":36521.029906656375,"d":"36521"},{"v":470.15,"d":"470"},{"v":17170362.210614495,"d":"17170362.21"},{"v":627079311801.9745,"d":"627,079,311,802"},1333785625.4428895,48711224715868.14,1.7789840946380797e+18,616.5198532574688,{"v":1381.5591359034142,"d":"1382"},{"v":-37.169330581857594,"d":"-37"},{"v":-5.020182174299634,"d":"-5"}]
[19,"Spain",null,{"v":36698.57134803824,"d":"36699"},{"v":492.55,"d":"493"},{"v":18075881.317476235,"d":"18075881.32"},{"v":663359020208.073,"d":"663,359,020,208"},1346785138.9870532,49425090513593.97,1.813830210596376e+18,6.477429686057764,{"v":224.3631776766729,"d":"224"},{"v":-14.978757547829957,"d":"-15"},{"v":-4.904920495140118,"d":"-5"}]
[20,"Sweden",null,{"v":53386.35705280193,"d":"53386"},{"v":516.33,"d":"516"},{"v":27564977.737073224,"d":"27564977.74"},{"v":1471593743623.9272,"d":"1,471,593,743,624"},2850103119.3692546,152156622767951.6,8.123087791038355e+18,108.18169835334659,{"v":6.414147837068903,"d":"6"},{"v":2.5326167963331727,"d":"3"},{"v":5.928956862249549,"d":"6"}]
[21,"Switzerland",null,{"v":64265.938270455015,"d":"64266"},{"v":494.37,"d":"494"},{"v":31771151.902764846,"d":"31771151.90"},{"v":2041802886964.3352,"d":"2,041,802,886,964"},4130110821.7819347,265425447122776.06,1.7057815400200247e+19,346.78222794428973,{"v":84.95774117253919,"d":"85"},{"v":-9.21725236567488,"d":"-9"},{"v":12.99208978456204,"d":"13"}]
[22,"United Kingdom",null,{"v":42793.09308837724,"d":"42793"},{"v":523.44,"d":"523"},{"v":22399616.646180183,"d":"22399616.65"},{"v":958548880283.9529,"d":"958,548,880,284"},1831248816.0705197,78364801054086.36,3.35347222635968e+18,594.7889835441919,{"v":111.18298793591673,"d":"111"},{"v":10.544334399852687,"d":"11"},{"v":-0.9482960360946322,"d":"-1"}]
[23,"United States",null,{"v":67312.70472992107,"d":"67313"},{"v":504.42,"d":"504"},{"v":33953874.51986679,"d":"33953874.52"},{"v":2285527129992.5835,"d":"2,285,527,129,993"},4531000218.057538,304993879809315,2.0529962976037458e+19,111.30420990229041,{"v":32.65721978020614,"d":"33"},{"v":5.714649576326281,"d":"6"},{"v":14.97008103771202,"d":"15"}]
[null,"Summen",null,{"v":1000966.6079567714,"d":"1000967"},{"v":11488.7,"d":"11489"},{"v":504321599.0697368,"d":"504321599"},{"v":25355131242351.426,"d":"25355131242351"},{"v":50211717785.22929,"d":"50211717785"},{"v":504321599.0697368,"d":"504321599.07"},{"v":25355131242351.426,"d":"25,355,131,242,351"},{"v":12025.725091759095,"d":"12,026"},{"v":7652.610965725593,"d":"7,653"}]
[{"$nulls":3},{"v":11488.7,"d":"11489"},{"v":1000966.6079567714,"d":"1,000,967"},{"$nulls":7},{"v":347.84585595003125,"d":"348"},{"v":127.38778642909956,"d":"127"},"(erklärte Varianz ist kleiner als Restvarianz!!)"]
[null,"Mittelwerte",null,{"v":43520.28730246832,"d":"43520"},{"v":499.50869565217397,"d":"500"}]
[]
[{"$nulls":4},"Zeichnung der Geraden",null,null,"Zeichnung Parabel"]
["Gleichungssystem für Berechnung der Geraden",{"$nulls":3},{"v":0,"d":"0.00"},{"v":471.27,"d":"471.270000000"},null,400.35]
["23b+","1000967a=",11489,null,{"v":5000,"d":"5000.00"},{"v":474.51605,"d":"474.516050000"},null,422.507775]
["1000967b+","50211717785a=",504321599.07,null,{"v":10000,"d":"10000.00"},{"v":477.7621,"d":"477.762100000"},null,442.2821]
[{"$nulls":4},{"v":15000,"d":"15000.00"},{"v":481.00815,"d":"481.008150000"},null,459.672975]
["Steigung a der Geraden",null,{"v":0.00064921,"d":"0.0006492"},null,{"v":20000,"d":"20000.00"},{"v":484.25419999999997,"d":"484.254200000"},null,474.6804000000001]
["Ordinatenabschnitt",null,471.27,null,{"v":25000,"d":"25000.00"},{"v":487.50025,"d":"487.500250000"},null,487.3043750000001]
[{"$nulls":4},{"v":30000,"d":"30000.00"},{"v":490.74629999999996,"d":"490.746300000"},null,497.5449]
[{"$nulls":4},{"v":35000,"d":"35000.00"},{"v":493.99235,"d":"493.992350000"},null,505.40197500000005]
["Gleichungssysteme für Berechnung des Polynoms",{"$nulls":3},{"v":40000,"d":"40000.00"},{"v":497.23839999999996,"d":"497.238400000"},null,510.8756000000001]
["zweiten Grades",{"$nulls":3},{"v":45000,"d":"45000.00"},{"v":500.48445,"d":"500.484450000"},null,513.965775]
["23c+","1000967b+","50211717785a=",11489,{"v":50000,"d":"50000.00"},{"v":503.7305,"d":"503.730500000"},null,514.6725]
["1000967c+","50211717785b+","2746075883034200a=",504321599.07,{"v":55000,"d":"55000.00"},{"v":506.97655,"d":"506.976550000"},null,512.9957750000001]
["50211717785c+","2746075883034200b+","158828749434821000000a=",25355131242351,{"v":60000,"d":"60000.00"},{"v":510.2226,"d":"510.222600000"},null,508.93560000000014]
[{"$nulls":4},{"v":65000,"d":"65000.00"},{"v":513.46865,"d":"513.468650000"},null,502.491975]
[null,"Dies ergibt die Gleichung",null,null,{"v":70000,"d":"70000.00"},{"v":516.7147,"d":"516.714700000"},null,493.66490000000005]
["c=",400.35,null,null,{"v":75000,"d":"75000.00"},{"v":519.96075,"d":"519.960750000"},null,482.45437499999997]
["b=",0.0046699,null,null,{"v":80000,"d":"80000.00"},{"v":523.2067999999999,"d":"523.206800000"},null,468.8604]
["a=",-4.7668999999999995e-08]
["y=-4.7669*10^(-8)x^2+4.6699*10^(-3)+400.35"]

{"sheet":"Schmuckbeispiel","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"flags":["formulas_cached_only"]}
["Schuckbeispiel"]
[null,null,"xi(yi-yquer)","xi(xi-xquer)","Residuen (= yi-f(xi))","f(xi)-yquer"]
[3.1,350,-2039.8,-21.823999999999998,-51.75726314861305,-709.757263148613]
[4.5,410,-2691,-25.379999999999995,29.38764713662249,-568.6123528633775]
[4.9,510,-2440.2000000000003,-25.675999999999995,-30.28523563902445,-528.2852356390244]
[6.8,580,-2910.4,-22.711999999999993,91.26857117665236,-336.73142882334764]
[7.1,700,-2186.7999999999997,-21.583999999999993,1.5139090949170395,-306.48609090508296]
[8.2,780,-1869.6,-15.907999999999994,32.41348146188784,-195.58651853811216]
[9.1,950,-527.8,-9.463999999999992,-46.850504783317774,-104.85050478331777]
[10,980,-280,-1.399999999999988,13.885508971476497,-14.114491028523503]
[11.3,1180,1943.6000000000001,13.108000000000022,-55.05136004937617,116.94863995062383]
[11.9,1150,1689.8,20.94400000000002,35.43931578715342,177.43931578715342]
[12.8,1300,3737.6000000000004,34.04800000000002,-23.824670458052196,268.1753295419478]
[14,1350,4788,54.04000000000002,47.156681215006756,389.15668121500676]
[14.7,1500,7232.4,67.03200000000001,-32.270863642375616,459.7291363576244]
[16.2,1680,10886.4,98.172,-61.04417405105164,610.9558259489484]
[17.5,1700,12110,128.8,50.01895692809558,742.0189569280956]
[null,"Summen",27442.2,272.19600000000014]
[10.139999999999999,1008,"Mittelwerte",null,"Restvarianz","erklärte Varianz","Summe"]
[19.442571428571423,199802.85714285713,"Varianz",null,2184.1399474748227,197618.71719538214,199802.85714285696]
[4.409373133289065,446.99312874232993,"Standardabweichung"]
[]
[null,"a = ",100.81779306088255]
[null,"b = ",-14.29242163734898]

{"sheet":"Summe quadrierter Abweichungen ","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"flags":["formulas_cached_only"]}
["Einkommen","Ausgaben für Schmuck","quadrierte Abweichung der Daten von der Gerade"]
[3.1,350,400,0]
[4.5,410,10000,0,null,0,20]
[4.9,510,1600,0,null,60,2060]
[6.8,580,25600,0]
[7.1,700,4900,0]
[8.2,780,9999.999999999978,0]
[9.1,950,400,0]
[10,980,6400,0]
[11.3,1180,100,0]
[11.9,1150,10000,0]
[12.8,1300,1600,0]
[14,1350,12100,0]
[14.7,1500,900,0]
[16.2,1680,0,0]
[17.5,1700,12100,0]
[null,"Summe",96099.99999999997]
["a =",100,350500]
["b =",60]
[]
["Minimales Summenquadrat bei"]
["a="]
["b="]

{"sheet":"BerechnungsBeispiel_Von_Hand","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"flags":["formulas_cached_only"]}
["xi","yi","xi(yi-yquer)","xi(xi-xquer)"]
[1,6,-5,-5,-0.4629629629629628,0,5.555555555555555]
[4,10,-4,-8,0.8148148148148149,12,16.444444444444443]
[9,13,18,27,-0.7222222222222232]
[10,15,40,40,0.37037037037037024]
[6,11,49,54,0.5123456790123461]
[null,15.333333333333334]
["a=",0.9074074074074074]
["b=",5.555555555555555]