{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["English","German"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"English","index":0,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,5],[7,1,16,1],[18,0,18,5]]}
["How to create a series of random numbers with given mean M and standard deviation S"]
[]
["Approach with Worksheet Functions"]
[]
[null,null,null,"Formulae in column C",null,"Formulae in column E"]
["Mean M",7,{"$f":"AVERAGE(C8:C17)","v":2.2624035066442785},{"$f":"sbGetCell(C6,41)","v":"=AVERAGE(C8:C17)"},{"$f":"AVERAGE(E8:E17)","v":7.0000000000000018},{"$f":"sbGetCell(E6,41)","v":"=AVERAGE(E8:E17)"}]
["StDev S",10,{"$f":"_xlfn.STDEV.S(C8:C17)","v":6.8477441022199841},{"$f":"sbGetCell(C7,41)","v":"=STDEV.S(C8:C17)"},{"$f":"_xlfn.STDEV.S(E8:E17)","v":10},{"$f":"sbGetCell(E7,41)","v":"=STDEV.S(E8:E17)"}]
[null,"Data",{"$f":"_xlfn.NORM.INV(RAND(),$B$6,$B$7)","v":-0.61368382749762773},{"$f":"sbGetCell(C8,41)","v":"=NORM.INV(RAND(),$B$6,$B$7)"},{"$f":"$B$6+(C8-$C$6)*$B$7/$C$7","v":2.799949163974305},{"$f":"sbGetCell(E8,41)","v":"=$B$6+(C8-$C$6)*$B$7/$C$7"}]
[null,null,{"$f":"_xlfn.NORM.INV(RAND(),$B$6,$B$7)","v":-1.5682353369089093},null,{"$f":"$B$6+(C9-$C$6)*$B$7/$C$7","v":1.4059842389388857}]
[null,null,4.4282465153189818,null,10.16285622877256]
[null,null,1.355601372933144,null,5.6757651568533989]
[null,null,15.973705216782008,null,27.023093014957489]
[null,null,-2.0758524621562273,null,0.66469321277049787]
[null,null,0.87631255356679194,null,4.9758429456671331]
[null,null,10.973542611596315,null,19.721180836953231]
[null,null,-8.1405751896353209,null,-8.1918333118012363]
[null,null,1.4149736124436325,null,5.7624685129137401]
[]
["Approach with VBA"]
[]
[null,null,null,"Formulae in column C",null,"Formulae in column E"]
[null,null,{"$f":"AVERAGE(C24:C33)","v":7},{"$f":"sbGetCell(C22,41)","v":"=AVERAGE(C24:C33)"},{"$f":"AVERAGE(E24:E33)","v":7},{"$f":"sbGetCell(E22,41)","v":"=AVERAGE(E24:E33)"}]
[null,null,{"$f":"_xlfn.STDEV.S(C24:C33)","v":9.9999999999999982},{"$f":"sbGetCell(C23,41)","v":"=STDEV.S(C24:C33)"},{"$f":"_xlfn.STDEV.S(E24:E33)","v":9.9999999999999982},{"$f":"sbGetCell(E23,41)","v":"=STDEV.S(E24:E33)"}]
[null,null,{"$f":"sbGenNormDist(10,B6,B7)","v":-8.3381183797670904},{"$f":"sbGetCell(C24,41)","v":"=sbGenNormDist(10,B6,B7)"},20.391897817976336,{"$f":"sbGetCell(E24,41)","v":"20.3918978179763"}]
[null,null,3.442042044714082,null,24.682050673213155]
[null,null,13.902719616445323,null,9.9537570583743822]
[null,null,11.633174831369558,null,8.8013654330346718]
[null,null,2.6006264876063501,null,10.421673464498785]
[null,null,19.34859829341724,null,-2.0845921738651505]
[null,null,14.230988779383747,null,1.3298627815746453]
[null,null,-7.503116004016519,null,3.8205947467789039]
[null,null,18.284068995138895,null,-7.6793056356817626]
[null,null,2.3990153357084125,null,0.36269583409602024]

{"sheet":"German","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[7,1,16,1],[0,0,0,5],[18,0,18,5],[2,0,2,5]]}
["Erzeuge eine Menge von Zufallszahlen mit dem Mittelwert M und der Standardabweichung S"]
[]
["Ansatz mit Tabellenblattfunktionen"]
[]
[null,null,null,"Formeln in Spalte C",null,"Formeln in Spalte E"]
["Mean M",7,{"$f":"AVERAGE(C8:C17)","v":7.5728255383614655},{"$f":"sbGetCell(C6,6)","v":"=MITTELWERT(C8:C17)"},{"$f":"AVERAGE(E8:E17)","v":6.9999999999999982},{"$f":"sbGetCell(E6,6)","v":"=MITTELWERT(E8:E17)"}]
["StDev S",10,{"$f":"_xlfn.STDEV.S(C8:C17)","v":9.2206503840853173},{"$f":"sbGetCell(C7,6)","v":"=STABW.S(C8:C17)"},{"$f":"_xlfn.STDEV.S(E8:E17)","v":10.000000000000002},{"$f":"sbGetCell(E7,6)","v":"=STABW.S(E8:E17)"}]
[null,"Daten",{"$f":"_xlfn.NORM.INV(RAND(),$B$6,$B$7)","v":20.332239014892114},{"$f":"sbGetCell(C8,6)","v":"=NORM.INV(ZUFALLSZAHL();$B$6;$B$7)"},{"$f":"$B$6+(C8-$C$6)*$B$7/$C$7","v":20.837867118954186},{"$f":"sbGetCell(E8,6)","v":"=$B$6+(C8-$C$6)*$B$7/$C$7"}]
[null,null,{"$f":"_xlfn.NORM.INV(RAND(),$B$6,$B$7)","v":1.3447523580888792},null,{"$f":"$B$6+(C9-$C$6)*$B$7/$C$7","v":0.24551639977356388}]
[null,null,0.85880704562776522,null,-0.28150207746948031]
[null,null,9.8732813840412827,null,9.4948954247851809]
[null,null,10.697156922418156,null,10.388406732619677]
[null,null,10.757902852299901,null,10.454287041872691]
[null,null,-8.3520080529712892,null,-10.270835492058932]
[null,null,17.101710687797588,null,17.334287444498287]
[null,null,-2.0117130491469695,null,-3.3946448333527339]
[null,null,15.126126220567215,null,15.191722240377551]
[]
["Ansatz mit VBA"]
[]
[null,null,null,"Formeln in Spalte C",null,"Formeln in Spalte E"]
[null,null,{"$f":"AVERAGE(C24:C33)","v":7},{"$f":"sbGetCell(C22,6)","v":"=MITTELWERT(C24:C33)"},{"$f":"AVERAGE(E24:E33)","v":7},{"$f":"sbGetCell(E22,6)","v":"=MITTELWERT(E24:E33)"}]
[null,null,{"$f":"_xlfn.STDEV.S(C24:C33)","v":10},{"$f":"sbGetCell(C23,6)","v":"=STABW.S(C24:C33)"},{"$f":"_xlfn.STDEV.S(E24:E33)","v":9.9999999999999982},{"$f":"sbGetCell(E23,6)","v":"=STABW.S(E24:E33)"}]
[null,null,{"$f":"sbGenNormDist(10,B6,B7)","v":12.275510334607713},{"$f":"sbGetCell(C24,6)","v":"=sbGenNormDist(10;B6;B7)"},8.0698862035273589,{"$f":"sbGetCell(E24,6)","v":"8,06988620352736"}]
[null,null,7.401196303878641,null,12.160611553832593]
[null,null,8.6480288681775885,null,12.481340265445748]
[null,null,0.58375408228716807,null,20.434927786829039]
[null,null,0.96658722690004684,null,-11.110871341991889]
[null,null,14.561629720688046,null,7.6030251474838151]
[null,null,-16.948526402494895,null,-9.1601806879168279]
[null,null,14.071398217178302,null,4.4125171825895251]
[null,null,16.056515454718706,null,13.926442179966799]
[null,null,12.383906194058682,null,11.182301710233839]