{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["Beispiel 1","Beispiel 2","Beispiel 3","Beispiel 4","Beispiel 5","summe_quadr_Abw_Mittel","Übung 1","Übung 2"],"not_rendered":{"charts":1,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Beispiel 1","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"flags":["formulas_cached_only"]}
["Beispiel 1"]
["Preis","Abgesetzte Menge","Produkt"]
[7.3,120,876]
[7.5,80,600]
[7.6,30,228]
[7.2,500,3600]
[7.8,20,156]
["Summen",750,5460]
["Durschnitt","5460:750=",7.28]

{"sheet":"Beispiel 2","index":1,"n_rows":17,"n_cols":1,"rows_kept":17,"flags":["formulas_cached_only"]}
["Beispiel 2"]
[164]
[165]
[182]
[164]
[160]
[175]
[174]
[169]
[168]
[163]
[156]
[161]
[168]
[175]
[170]
[165]

{"sheet":"Beispiel 3","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"flags":["formulas_cached_only"]}
["Beispiel 3"]
[]
[null,"Anzahl Steuerpflichtige",null,"Intervallmittel","Produkte"]
["Intervalle","Dorf A","Dorf B",null,"Dorf A","Dorf B"]
["[0,10'000[",2,0,5000,10000,0]
["[10'000,20'000[",10,2,15000,150000,30000]
["[20'000,30'000[",35,12,25000,875000,300000]
["[30'000,40'000[",30,24,35000,1050000,840000]
["[40'000,50'000[",14,42,45000,630000,1890000]
["[50'000,60'000[",8,15,55000,440000,825000]
[{"v":1100000,"d":"1,100,000"},1,0,1100000,1100000,0]

{"sheet":"Beispiel 4","index":3,"n_rows":39,"n_cols":2,"rows_kept":39,"flags":["formulas_cached_only"]}
["Beispiel 4"]
["Nationalität","Häufigkeit"]
["A",6]
["D",8]
["S",10]
["ND",6]
[]
[]
["Urliste"]
["A",1]
["A",1]
["A",1]
["A",1]
["A",1]
["A",1]
["D",2]
["D",2]
["D",2]
["D",2]
["D",2]
["D",2]
["D",2]
["D",2]
["S",3]
["S",3]
["S",3]
["S",3]
["S",3]
["S",3]
["S",3]
["S",3]
["S",3]
["S",3]
["ND",4]
["ND",4]
["ND",4]
["ND",4]
["ND",4]
["ND",4]

{"sheet":"Beispiel 5","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"flags":["formulas_cached_only"]}
["Beispiel 5"]
["Betriebszugehörigkeit in Jahren","Anzahl Angestellte"]
[3,1]
[4,2]
[5,7]
[6,5]
[7,6]
[8,7]
[9,4]

{"sheet":"summe_quadr_Abw_Mittel","index":5,"n_rows":68,"n_cols":13,"rows_kept":68,"flags":["formulas_cached_only"]}
["Beispiel für die Aussage, dass durch den Mittelwert die Summe der quadrierten Abweichungen minimiert wird.",{"$nulls":9},"Summen quadrierter Abweichungen"]
[null,null,"Eingabe",2,null,"Mittelwert",5.158214285714286,{"$nulls":3},"Liest man die Daten in R ein unter dat, erhält man mit den folgenden Befehlen: "]
[null,null,"Summe:",303.5151,null,"Summe",24.234210714285712,{"$nulls":3},"vek=numeric()"]
["Daten","quadrierte Abweichungen von einem Werte verschieden vom Mittelwert",{"$nulls":3},"Daten","quadrierte Abweichungen vom Mittelwert",{"$nulls":3},"a=seq(2,8,0.1)"]
[6.15,17.222500000000004,{"$nulls":4},0.9836389030612245,{"$nulls":3},"for (i in 1:61) vek[i]= sum((a[i]-dat))^2"]
[3.2,1.4400000000000004,{"$nulls":4},3.8346031887755108,{"$nulls":3},"cbind(a,vek)",null,"a sind die möglichen Werte, bei vek stehen die Summen der quadrierte Abweichungen. "]
[4.64,6.969599999999998,{"$nulls":4},0.26854604591836806,{"$nulls":3},"        a      vek"]
[5.36,11.289600000000002,{"$nulls":4},0.040717474489795895,{"$nulls":3},"[1,]",2,303.5151]
[3.6,2.5600000000000005,{"$nulls":4},2.4280317602040826,{"$nulls":3},"[2,]",2.1,286.1091]
[5.62,13.1044,{"$nulls":4},0.2132460459183671,{"$nulls":3},"[3,]",2.2,269.2631]
[4.11,4.4521000000000015,{"$nulls":4},1.0987531887755102,{"$nulls":3},"[4,]",2.3,252.9771]
[6.01,16.080099999999998,{"$nulls":4},0.7255389030612235,{"$nulls":3},"[5,]",2.4,237.2511]
[5.53,12.460900000000002,{"$nulls":4},0.1382246173469387,{"$nulls":3},"[6,]",2.5,222.0851]
[6.16,17.305600000000002,{"$nulls":4},1.0035746173469384,{"$nulls":3},"[7,]",2.6,207.4791]
[5.39,11.492099999999997,{"$nulls":4},0.05372461734693845,{"$nulls":3},"[8,]",2.7,193.4331]
[5.02,9.120399999999998,{"$nulls":4},0.019103188775510423,{"$nulls":3},"[9,]",2.8,179.9471]
[6.2,17.64,{"$nulls":4},1.0853174744897955,{"$nulls":3},"[10,]",2.9,167.0211]
[3.79,3.2041,{"$nulls":4},1.872010331632654,{"$nulls":3},"[11,]",3,154.6551]
[5.81,14.516099999999996,{"$nulls":4},0.42482461734693777,{"$nulls":3},"[12,]",3.1,142.8491]
[4.98,8.880400000000003,{"$nulls":4},0.031760331632653044,{"$nulls":3},"[13,]",3.2,131.6031]
[5.68,13.542399999999997,{"$nulls":4},0.2722603316326524,{"$nulls":3},"[14,]",3.3,120.9171]
[5.76,14.137599999999999,{"$nulls":4},0.36214604591836663,{"$nulls":3},"[15,]",3.4,110.7911]
[4.86,8.179600000000002,{"$nulls":4},0.08893176020408167,{"$nulls":3},"[16,]",3.5,101.2251]
[6.24,17.977600000000002,{"$nulls":4},1.1702603316326528,{"$nulls":3},"[17,]",3.6,92.2191]
[5.13,9.796899999999999,{"$nulls":4},0.0007960459183673739,{"$nulls":3},"[18,]",3.7,83.7731]
[3.72,2.9584000000000006,{"$nulls":4},2.0684603316326537,{"$nulls":3},"[19,]",3.8,75.8871]
[3.64,2.6896000000000004,{"$nulls":4},2.3049746173469394,{"$nulls":3},"[20,]",3.9,68.5611]
[6.2,17.64,{"$nulls":4},1.0853174744897955,{"$nulls":3},"[21,]",4,61.7951]
[5.58,12.8164,{"$nulls":4},0.17790318877550995,{"$nulls":3},"[22,]",4.1,55.5891]
[4.35,5.522499999999998,{"$nulls":4},0.6532103316326542,{"$nulls":3},"[23,]",4.2,49.9431]
[5.19,10.176100000000002,{"$nulls":4},0.0010103316326530625,{"$nulls":3},"[24,]",4.3,44.8571]
[6.51,20.3401,{"$nulls":4},1.8273246173469373,{"$nulls":3},"[25,]",4.4,40.3311]
[{"$nulls":10},"[26,]",4.5,36.3651]
[{"$nulls":10},"[27,]",4.6,32.9591]
[{"$nulls":10},"[28,]",4.7,30.1131]
[{"$nulls":10},"[29,]",4.8,27.8271]
[{"$nulls":10},"[30,]",4.9,26.1011]
[{"$nulls":10},"[31,]",5,24.9351]
[{"$nulls":10},"[32,]",5.1,24.3291]
[{"$nulls":10},"[33,]",5.2,24.2831]
[{"$nulls":10},"[34,]",5.3,24.7971]
[{"$nulls":10},"[35,]",5.4,25.8711]
[{"$nulls":10},"[36,]",5.5,27.5051]
[{"$nulls":10},"[37,]",5.6,29.6991]
[{"$nulls":10},"[38,]",5.7,32.4531]
[{"$nulls":10},"[39,]",5.8,35.7671]
[{"$nulls":10},"[40,]",5.9,39.6411]
[{"$nulls":10},"[41,]",6,44.0751]
[{"$nulls":10},"[42,]",6.1,49.0691]
[{"$nulls":10},"[43,]",6.2,54.6231]
[{"$nulls":10},"[44,]",6.3,60.7371]
[{"$nulls":10},"[45,]",6.4,67.4111]
[{"$nulls":10},"[46,]",6.5,74.6451]
[{"$nulls":10},"[47,]",6.6,82.4391]
[{"$nulls":10},"[48,]",6.7,90.7931]
[{"$nulls":10},"[49,]",6.8,99.7071]
[{"$nulls":10},"[50,]",6.9,109.1811]
[{"$nulls":10},"[51,]",7,119.2151]
[{"$nulls":10},"[52,]",7.1,129.8091]
[{"$nulls":10},"[53,]",7.2,140.9631]
[{"$nulls":10},"[54,]",7.3,152.6771]
[{"$nulls":10},"[55,]",7.4,164.9511]
[{"$nulls":10},"[56,]",7.5,177.7851]
[{"$nulls":10},"[57,]",7.6,191.1791]
[{"$nulls":10},"[58,]",7.7,205.1331]
[{"$nulls":10},"[59,]",7.8,219.6471]
[{"$nulls":10},"[60,]",7.9,234.7211]
[{"$nulls":10},"[61,]",8,250.3551]

{"sheet":"Übung 1","index":6,"n_rows":9,"n_cols":4,"rows_kept":9,"flags":["formulas_cached_only"]}
["Übungen 1"]
["Person","Geschlecht","Alter (Jahre)","Religion"]
[1,"m",17,"C"]
[2,"m",30,"P"]
[3,"m",73,"C"]
[4,"w",35,"C"]
[5,"m",21,"C"]
[6,"m",15,"P"]
[7,"w",19,"A"]

{"sheet":"Übung 2","index":7,"n_rows":8,"n_cols":2,"rows_kept":8,"flags":["formulas_cached_only"]}
["Übungen 2"]
["Intervalle","Relative Häufigkeiten"]
["[0, 20[",0.15]
["[20, 40[",0.2]
["[40, 60[",0.3]
["[60, 80[",0.2]
["[80, 100[",0.1]
["[100, 200]",0.05]