{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Cover","MITTELWERT","MITTELWERTWENNS","GewMittelAbs","GewMittelRel","Dichte","GEOMITTEL","GewGeoMittel","HARMITTEL","GewHarMittel","QUADRATESUMME","RMS","GESTUTZTMITTEL","Konfidenzintervall","MODUS.EINF","MODUS.VIELF","Rang","MEDIAN","StetMedian","QUANTILE"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":17,"defined_names":96,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"Stochastik"]
[]
[]
[null,"Kapitel",7]
[null,"Thema","Statistische Kenngrößen"]
[]
[null,"Inhalt","Statistische Funktionen"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2021-10-15"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"MITTELWERT","index":1,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[5,4,6,3,4,null,"Mittelwert:",{"$f":"AVERAGE(MittelMatrix)","v":9.32}]
[4,6,1,2,6]
[12,5,14,11,15]
[7,9,8,21,22]
[14,18,11,5,20]

{"sheet":"MITTELWERTWENNS","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[5,4,6,3,4,null,"Untergrenze",9,">="]
[4,6,1,2,6,null,"Obergrenze",18,"<="]
[12,5,14,11,15,null,"Mittelwert",{"$f":"AVERAGEIFS(WennsMatrix,WennsMatrix,UOp&UGrenze,WennsMatrix,OOp&OGrenze)","v":13}]
[7,9,8,21,22]
[14,18,11,5,20]

{"sheet":"GewMittelAbs","index":3,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["x =",1,2,3,4,5,6,null,"Gew.Mittel",{"$f":"SUMPRODUCT(Noten,Studenten)/SUM(Studenten)","v":3.125}]
["H =",5,12,18,14,6,1]

{"sheet":"GewMittelRel","index":4,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["x =",1,2,3,4,5,6,null,"Gew.Mittel",{"$f":"SUMPRODUCT(Notenschlüssel,Notenverteilung)","v":3.45}]
["h =",0.1,0.2,0.2,0.25,0.15,0.1]

{"sheet":"Dichte","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[0,{"$f":"-0.08*A1+0.4","v":0.4}]
[1,0.32]
[2,0.24000000000000002]
[3,0.16000000000000003]
[4,8.0000000000000016E-2]
[5,0]

{"sheet":"GEOMITTEL","index":6,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Jahr",1,2,3,4,5,6,7,null,"Steigerungsrate",{"$f":"GEOMEAN(Steigerung)","v":1.0380067300401736}]
["Steigerung in %",9,3,6,5,-3,3,4]
["Dezimalanteil",1.0900000000000001,1.03,1.06,1.05,0.97,1.03,1.04]

{"sheet":"GewGeoMittel","index":7,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["n",10,25,5,8,32,14,28,null,"Schnitt",{"$f":"SUMPRODUCT(Schnitt,Mittel)","v":{"$error":"#VALUE!"}}]
["x",2.35,2.37,3.11,2.4300000000000002,2.41,2.39,2.42]
["h",{"$f":"Anzahl/SUM(Anzahl)","v":8.1967213114754092E-2},0.20491803278688525,4.0983606557377046E-2,6.5573770491803282E-2,0.26229508196721313,0.11475409836065574,0.22950819672131148,{"$f":"SUM(Mittel)","v":1}]

{"sheet":"HARMITTEL","index":8,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Tag",1,2,3,4,5,null,"Mittel",{"$f":"HARMEAN(Geschw)","v":89.75730098221257}]
["Strecke in km",180,210,240,160,190]
["Zeit in Std.",2.11,2.31,2.61,1.87,1.98]
["Geschw",{"$f":"Strecke/Zeit","v":85.308056872037923},{"$f":"Strecke/Zeit","v":90.909090909090907},{"$f":"Strecke/Zeit","v":91.954022988505756},{"$f":"Strecke/Zeit","v":85.561497326203209},{"$f":"Strecke/Zeit","v":95.959595959595958}]

{"sheet":"GewHarMittel","index":9,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Tag",1,2,3,4,5,null,"Mittel",90.07352941176471]
["Strecke in km",180,210,240,160,190,null,"Summe",{"$f":"SUM(Strecke1)","v":980}]
["Zeit in Std.",2.11,2.31,2.61,1.87,1.98,null,"Summe",{"$f":"SUM(Zeit1)","v":10.879999999999999}]
["Geschw ",{"$f":"Strecke1/Zeit1","v":85.308056872037923},{"$f":"Strecke1/Zeit1","v":90.909090909090907},{"$f":"Strecke1/Zeit1","v":91.954022988505756},{"$f":"Strecke1/Zeit1","v":85.561497326203209},{"$f":"Strecke1/Zeit1","v":95.959595959595958}]

{"sheet":"QUADRATESUMME","index":10,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Masse in t",145,163,176,138,198,173,212,156,145,221]
["Abweichung",{"$f":"Masse-Mittelwert","v":-27.699999999999989},-9.6999999999999886,3.3000000000000114,-34.699999999999989,25.300000000000011,0.30000000000001137,39.300000000000011,-16.699999999999989,-27.699999999999989,48.300000000000011]
[]
["Mittelwert",{"$f":"AVERAGE(Masse)","v":172.7}]
["quadr. Mittel",{"$f":"SQRT(SUMSQ(Abweichung)/(COUNT(Abweichung)-1))","v":29.135888522576415}]

{"sheet":"RMS","index":11,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Winkel in Grd",0,18,36,54,72,90,108,126,144,162,180]
["Spannung in V",0,6.2,11.8,16.2,19,20,19,16.2,11.8,6.2,0]

{"sheet":"GESTUTZTMITTEL","index":12,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Vormittags",159,218,199,220,429,338,174]
["Mittags",89,19,248,169,299]
["Nachmittags",149,257,948,139,219,412,187,209]
[]
["arithm.Mittel",{"$f":"AVERAGE(Verkäufe)","v":254.05}]
["getrim.Mittel",{"$f":"TRIMMEAN(Verkäufe,10%)","v":228.55555555555554}]

{"sheet":"Konfidenzintervall","index":13,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Alpha",0.05,null,null,null,"Konfidenzintervalle:"]
["StAbw",4.2,null,"Grundgesamtheit",null,"von","bis"]
["Umfang",100,null,"normalverteilt",{"$f":"_xlfn.CONFIDENCE.NORM(Alpha,StAbw,Umfang)","v":0.82318487350682257},{"$f":"Schnitt-E3","v":51.576815126493173},{"$f":"Schnitt+E3","v":53.223184873506824}]
["Durchschnitt",52.4,null,"t-verteilt",{"$f":"_xlfn.CONFIDENCE.T(Alpha,StAbw,Umfang)","v":0.83337111966629507},{"$f":"Schnitt-E4","v":51.566628880333703},{"$f":"Schnitt+E4","v":53.233371119666295}]

{"sheet":"MODUS.EINF","index":14,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[6,5,3,2,null,"Modus",{"$f":"_xlfn.MODE.SNGL(NotenMatrix)","v":2}]
[4,2,4,2]
[2,6,5,1]
[4,7,4,7]
[2,5,6,5]

{"sheet":"MODUS.VIELF","index":15,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[5,4,6,3,4,null,{"$f":"_xlfn.MODE.MULT(RegalMatrix)","v":5}]
[4,6,1,2,6,null,4]
[12,5,14,11,15,null,6]
[7,9,8,21,22,null,{"$error":"#N/A"}]
[14,18,11,5,20,null,{"$error":"#N/A"}]

{"sheet":"Rang","index":16,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Mat.Nr.","A-12-B-45","C-45-A-13","F-21-G-33","K-01-H-03","J-34-L-17","M-52-K-37","B-22-L-36","H-07-H-08","A-55-S-13"]
["Punkte",56,75,92,86,75,87,90,45,72]
["Rang",{"$f":"_xlfn.RANK.EQ(B2,TestPunkte,0)","v":8},5,1,4,5,3,2,9,7]
[]
["Range",{"$f":"MAX(TestPunkte)-MIN(TestPunkte)","v":47}]

{"sheet":"MEDIAN","index":17,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Alter",23,45,43,56,38,35,26,27,41,45,22,51,35,68,72]
["Median",{"$f":"MEDIAN(Alter)","v":41}]

{"sheet":"StetMedian","index":18,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["x","F(x)","f(x)"]
[0,{"$f":"1-EXP(-A2)","v":0},{"$f":"EXP(-A2)","v":1}]
[1,0.63212055882855767,{"$f":"EXP(-A3)","v":0.36787944117144233}]
[2,0.8646647167633873,0.1353352832366127]
[3,0.95021293163213605,4.9787068367863944E-2]
[4,0.98168436111126578,1.8315638888734179E-2]
[5,0.99326205300091452,6.737946999085467E-3]
[6,0.99752124782333362,2.4787521766663585E-3]

{"sheet":"QUANTILE","index":19,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Alter",23,45,43,56,38,35,26,27,41,45,22,51,35,68,72]
["Quantile 25%",{"$f":"_xlfn.PERCENTILE.EXC(Alter,0.25)","v":27}]
["Quantile 50%",{"$f":"_xlfn.PERCENTILE.EXC(Alter,0.5)","v":41}]
["Quantile 75%",{"$f":"_xlfn.PERCENTILE.EXC(Alter,0.75)","v":51}]