{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Simpson","Lorenz unklassiert","Lorenz klassiert","Lorenz klassiert Angabe Anteile"],"not_rendered":{"charts":3,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Simpson","index":0,"n_rows":56,"n_cols":5,"rows_kept":56,"flags":["formulas_cached_only"]}
["Simpsonindex"]
[{"$nulls":3},"Simpsonindex: ",0.9553571428571428]
[]
["Streuungsmass für nominalskalierte Daten (für maximal 50 Klassen)"]
["Bilden Sie die Häufigkeitsauszählung der Daten und fügen Sie dann die Werte der absoluten Häufigkeitsverteilung in die folgende Spalte ein:"]
["H(xi)","(h(xi))^2","Anzahl Klassen",8]
[0,0]
[3,0.03515625]
[3,0.03515625]
[2,0.015625]
[3,0.03515625]
[1,0.00390625]
[3,0.03515625]
[1,0.00390625]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]

{"sheet":"Lorenz unklassiert","index":1,"n_rows":107,"n_cols":10,"rows_kept":107,"flags":["formulas_cached_only"]}
["Lorenzkurve und Lorenzkonzentration"]
[]
["(nicht klassifizierte Daten)",{"$nulls":5},"Lorenzkonzentration",null,null,0.2681818181818182]
["Darstellung und Masszahl für die Streuung von metrisch skalierten Daten",{"$nulls":5},"Normierte Lorenzkonzentration",null,null,0.297979797979798]
[]
[null,null,"Nummerierung","Anteile Anzahl","h(i)","Anteil an Summe",null,null,"(1+2i)/n","h(i/n)+h((i+1)/n)"]
["Eingabe geordnete Daten (Maximal 100)",null,0,0,null,0]
[1,"Anzahl Daten",1,0.1,1,0.022727272727272728,null,null,0.1,0.022727272727272728]
[2,10,2,0.2,3,0.06818181818181818,0,0,0.3,0.09090909090909091]
[3,"Summe Daten",3,0.3,6,0.13636363636363635,1,1,0.5,0.20454545454545453]
[3.5,44,4,0.4,9.5,0.2159090909090909,null,null,0.7,0.3522727272727273]
[4,null,5,0.5,13.5,0.3068181818181818,null,null,0.9,0.5227272727272727]
[4.5,null,6,0.6,18,0.4090909090909091,null,null,1.1,0.7159090909090909]
[5,null,7,0.7,23,0.5227272727272727,null,null,1.3,0.9318181818181819]
[6,null,8,0.8,29,0.6590909090909091,null,null,1.5,1.1818181818181817]
[7,null,9,0.9,36,0.8181818181818182,null,null,1.7,1.4772727272727273]
[8,null,10,1,44,1,null,null,1.9,1.8181818181818183]
[null,null,11,1,0,1,null,null,0,0]
[null,null,12,1,0,1,null,null,0,0]
[null,null,13,1,0,1,null,null,0,0]
[null,null,14,1,0,1,null,null,0,0]
[null,null,15,1,0,1,null,null,0,0]
[null,null,16,1,0,1,null,null,0,0]
[null,null,17,1,0,1,null,null,0,0]
[null,null,18,1,0,1,null,null,0,0]
[null,null,19,1,0,1,null,null,0,0]
[null,null,20,1,0,1,null,null,0,0]
[null,null,21,1,0,1,null,null,0,0]
[null,null,22,1,0,1,null,null,0,0]
[null,null,23,1,0,1,null,null,0,0]
[null,null,24,1,0,1,null,null,0,0]
[null,null,25,1,0,1,null,null,0,0]
[null,null,26,1,0,1,null,null,0,0]
[null,null,27,1,0,1,null,null,0,0]
[null,null,28,1,0,1,null,null,0,0]
[null,null,29,1,0,1,null,null,0,0]
[null,null,30,1,0,1,null,null,0,0]
[null,null,31,1,0,1,null,null,0,0]
[null,null,32,1,0,1,null,null,0,0]
[null,null,33,1,0,1,null,null,0,0]
[null,null,34,1,0,1,null,null,0,0]
[null,null,35,1,0,1,null,null,0,0]
[null,null,36,1,0,1,null,null,0,0]
[null,null,37,1,0,1,null,null,0,0]
[null,null,38,1,0,1,null,null,0,0]
[null,null,39,1,0,1,null,null,0,0]
[null,null,40,1,0,1,null,null,0,0]
[null,null,41,1,0,1,null,null,0,0]
[null,null,42,1,0,1,null,null,0,0]
[null,null,43,1,0,1,null,null,0,0]
[null,null,44,1,0,1,null,null,0,0]
[null,null,45,1,0,1,null,null,0,0]
[null,null,46,1,0,1,null,null,0,0]
[null,null,47,1,0,1,null,null,0,0]
[null,null,48,1,0,1,null,null,0,0]
[null,null,49,1,0,1,null,null,0,0]
[null,null,50,1,0,1,null,null,0,0]
[null,null,51,1,0,1,null,null,0,0]
[null,null,52,1,0,1,null,null,0,0]
[null,null,53,1,0,1,null,null,0,0]
[null,null,54,1,0,1,null,null,0,0]
[null,null,55,1,0,1,null,null,0,0]
[null,null,56,1,0,1,null,null,0,0]
[null,null,57,1,0,1,null,null,0,0]
[null,null,58,1,0,1,null,null,0,0]
[null,null,59,1,0,1,null,null,0,0]
[null,null,60,1,0,1,null,null,0,0]
[null,null,61,1,0,1,null,null,0,0]
[null,null,62,1,0,1,null,null,0,0]
[null,null,63,1,0,1,null,null,0,0]
[null,null,64,1,0,1,null,null,0,0]
[null,null,65,1,0,1,null,null,0,0]
[null,null,66,1,0,1,null,null,0,0]
[null,null,67,1,0,1,null,null,0,0]
[null,null,68,1,0,1,null,null,0,0]
[null,null,69,1,0,1,null,null,0,0]
[null,null,70,1,0,1,null,null,0,0]
[null,null,71,1,0,1,null,null,0,0]
[null,null,72,1,0,1,null,null,0,0]
[null,null,73,1,0,1,null,null,0,0]
[null,null,74,1,0,1,null,null,0,0]
[null,null,75,1,0,1,null,null,0,0]
[null,null,76,1,0,1,null,null,0,0]
[null,null,77,1,0,1,null,null,0,0]
[null,null,78,1,0,1,null,null,0,0]
[null,null,79,1,0,1,null,null,0,0]
[null,null,80,1,0,1,null,null,0,0]
[null,null,81,1,0,1,null,null,0,0]
[null,null,82,1,0,1,null,null,0,0]
[null,null,83,1,0,1,null,null,0,0]
[null,null,84,1,0,1,null,null,0,0]
[null,null,85,1,0,1,null,null,0,0]
[null,null,86,1,0,1,null,null,0,0]
[null,null,87,1,0,1,null,null,0,0]
[null,null,88,1,0,1,null,null,0,0]
[null,null,89,1,0,1,null,null,0,0]
[null,null,90,1,0,1,null,null,0,0]
[null,null,91,1,0,1,null,null,0,0]
[null,null,92,1,0,1,null,null,0,0]
[null,null,93,1,0,1,null,null,0,0]
[null,null,94,1,0,1,null,null,0,0]
[null,null,95,1,0,1,null,null,0,0]
[null,null,96,1,0,1,null,null,0,0]
[null,null,97,1,0,1,null,null,0,0]
[null,null,98,1,0,1,null,null,0,0]
[null,null,99,1,0,1,null,null,0,0]
[null,null,100,1,0,1,null,null,0,0]

{"sheet":"Lorenz klassiert","index":2,"n_rows":106,"n_cols":12,"rows_kept":106,"flags":["formulas_cached_only"]}
["Lorenzkurve und Lorenzkonzentration"]
[{"$nulls":10},"Anzahl Daten","Anzahl Klassen"]
["(klassifizierte Daten)",{"$nulls":5},"Lorenzkonzentration",null,0.2611111111111111,null,100,5]
["Darstellung und Masszahl für die Streuung von metrisch skalierten Daten",{"$nulls":5},"Normierte Lorenzkonzentration",null,0.3263888888888889,null,"Summe Daten"]
[{"$nulls":4},"i/n","h(i/n)","Anzahl Daten kumuliert",{"$nulls":3},1350]
["Anzahl Daten pro Klasse ","Klassenwert geordnet(z.B. arithmetisches Mittel der Klasse)","Produkt A*B",null,0,0,0,"(ni+1-ni)/n","(ni+ni+1)/n"]
[7,2.5,17.5,null,0.07,0.012962962962962963,7,0.07,0.07,0.003992592592592594,0,0]
[24,7.5,180,null,0.31,0.14629629629629629,31,0.24,0.38,0.05297777777777778,1,1]
[35,12.5,437.5,null,0.66,0.4703703703703704,66,0.35,0.97,0.12366666666666666]
[18,17.5,315,null,0.84,0.7037037037037037,84,0.18,1.5,0.05866666666666667]
[16,25,400,null,1,1,100,0.16,1.84,0.021807407407407418]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]
[null,null,0,null,0,0,100,0,2,0]

{"sheet":"Lorenz klassiert Angabe Anteile","index":3,"n_rows":82,"n_cols":10,"rows_kept":82,"flags":["formulas_cached_only"]}
["Lorenzkurve und Lorenzkonzentration"]
[{"$nulls":7},"Lorzenzkontration: ",null,0.394134555028843]
["(klassifizierte Daten, Angabe von nicht-kumulierten Anteilen)",{"$nulls":6},"Normierte Lorenzkontration",null,0.4379272833653811]
["Darstellung und Masszahl für die Streuung von metrisch skalierten Daten"]
[{"$nulls":4},"kumuliert","kumuliert","Fläche","Anzahl"]
["Anteile an Grundgesamtheit","Anteile an untersuchter Grösse",null,null,0,0,null,10]
[0.1867924528301887,0.023527069483764138,0,0,0.1867924528301887,0.023527069483764138,0.015248370708769842]
[0.13207547169811318,0.05197807053750492,1,1,0.31886792452830187,0.07550514002126905,0.026852803537492462]
[0.11886792452830192,0.07428629699950955,null,null,0.4377358490566038,0.1497914370207786,0.031577691870000056]
[0.10943396226415092,0.09927500691972632,null,null,0.5471698113207547,0.24906644394050492,0.032066765288804096]
[0.10943396226415092,0.12607498555355384,null,null,0.6566037735849056,0.37514142949405876,0.03171208609936188]
[0.08867924528301885,0.12447737856487301,null,null,0.7452830188679245,0.4996188080589318,0.02337259252857779]
[0.10188679245283028,0.171827730378327,null,null,0.8471698113207548,0.6714465384372588,0.02146690954659851]
[0.060377358490566024,0.11621741051701273,null,null,0.9075471698113208,0.7876639489542715,0.008923969622356085]
[0.047169811320754707,0.10175154054959623,null,null,0.9547169811320755,0.8894154895038677,0.004367563973708891]
[0.04528301886792452,0.11058451049613227,null,null,1,1,0.0014785243387518733]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]
[{"$nulls":4},1,1,0]