{"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":8.4284320067529173},{"$f":"sbGetCell(C6,41)","v":"=AVERAGE(C8:C17)"},{"$f":"AVERAGE(E8:E17)","v":7},{"$f":"sbGetCell(E6,41)","v":"=AVERAGE(E8:E17)"}]
["StDev S",10,{"$f":"_xlfn.STDEV.S(C8:C17)","v":11.965817195760822},{"$f":"sbGetCell(C7,41)","v":"=STDEV.S(C8:C17)"},{"$f":"_xlfn.STDEV.S(E8:E17)","v":9.9999999999999982},{"$f":"sbGetCell(E7,41)","v":"=STDEV.S(E8:E17)"}]
[null,"Data",{"$f":"_xlfn.NORM.INV(RAND(),$B$6,$B$7)","v":21.942910679493536},{"$f":"sbGetCell(C8,41)","v":"=NORM.INV(RAND(),$B$6,$B$7)"},{"$f":"$B$6+(C8-$C$6)*$B$7/$C$7","v":18.294237954369258},{"$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":24.437551598081178},null,{"$f":"$B$6+(C9-$C$6)*$B$7/$C$7","v":20.379044096545179}]
[null,null,7.3535181941584788,null,6.1016795635359928]
[null,null,13.549816146464897,null,11.280012017504625]
[null,null,5.0417802871925979,null,4.169728014263729]
[null,null,-19.816127907226459,null,-16.604371896961364]
[null,null,5.3605087935531603,null,4.436093863871962]
[null,null,9.2249077623901368,null,7.6656258762831424]
[null,null,7.3733423728227763,null,6.1182469056071387]
[null,null,9.8161121405988787,null,8.1597036049803435]
[]
["Approach with VBA"]
[]
[null,null,null,"Formulae in column C",null,"Formulae in column E"]
[null,null,{"$f":"AVERAGE(C24:C33)","v":6.9999999999999973},{"$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":10.000000000000002},{"$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":9.6257322123004183},{"$f":"sbGetCell(C24,41)","v":"=sbGenNormDist(10,B6,B7)"},20.391897817976336,{"$f":"sbGetCell(E24,41)","v":"20.3918978179763"}]
[null,null,9.4256867553403474,null,24.682050673213155]
[null,null,2.4640308700415359,null,9.9537570583743822]
[null,null,21.888586038407592,null,8.8013654330346718]
[null,null,13.495228077824631,null,10.421673464498785]
[null,null,-7.123742937069121,null,-2.0845921738651505]
[null,null,5.2678668862214932,null,1.3298627815746453]
[null,null,20.451416852488208,null,3.8205947467789039]
[null,null,-6.577797586892574,null,-7.6793056356817626]
[null,null,1.0829928313374548,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":6.7944131069453615},{"$f":"sbGetCell(C6,6)","v":"=MITTELWERT(C8:C17)"},{"$f":"AVERAGE(E8:E17)","v":7.0000000000000018},{"$f":"sbGetCell(E6,6)","v":"=MITTELWERT(E8:E17)"}]
["StDev S",10,{"$f":"_xlfn.STDEV.S(C8:C17)","v":10.441055456854425},{"$f":"sbGetCell(C7,6)","v":"=STABW.S(C8:C17)"},{"$f":"_xlfn.STDEV.S(E8:E17)","v":9.9999999999999982},{"$f":"sbGetCell(E7,6)","v":"=STABW.S(E8:E17)"}]
[null,"Daten",{"$f":"_xlfn.NORM.INV(RAND(),$B$6,$B$7)","v":-4.5794828290916669},{"$f":"sbGetCell(C8,6)","v":"=NORM.INV(ZUFALLSZAHL();$B$6;$B$7)"},{"$f":"$B$6+(C8-$C$6)*$B$7/$C$7","v":-3.8934350392423269},{"$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":26.98645367559169},null,{"$f":"$B$6+(C9-$C$6)*$B$7/$C$7","v":26.339079896745975}]
[null,null,10.405618890413216,null,10.458659709634183]
[null,null,12.504898814523699,null,12.469260968084864]
[null,null,16.733573322556602,null,16.519306028670027]
[null,null,-3.5126697010484271,null,-2.8716866801309013]
[null,null,0.65375031636605474,null,1.1187336702171837]
[null,null,-2.9944088028942861,null,-2.3753183768537554]
[null,null,11.265664661292588,null,11.282375065264024]
[null,null,0.48073272174415216,null,0.95302475761073069]
[]
["Ansatz mit VBA"]
[]
[null,null,null,"Formeln in Spalte C",null,"Formeln in Spalte E"]
[null,null,{"$f":"AVERAGE(C24:C33)","v":6.9999999999999973},{"$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.000000000000004},{"$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":25.004198550805512},{"$f":"sbGetCell(C24,6)","v":"=sbGenNormDist(10;B6;B7)"},8.0698862035273589,{"$f":"sbGetCell(E24,6)","v":"8,06988620352736"}]
[null,null,12.092366774833799,null,12.160611553832593]
[null,null,8.8120696757727437,null,12.481340265445748]
[null,null,1.805633823813408,null,20.434927786829039]
[null,null,9.911965554034504,null,-11.110871341991889]
[null,null,-1.9171841270127636,null,7.6030251474838151]
[null,null,0.25564255123914847,null,-9.1601806879168279]
[null,null,2.1986687286382827,null,4.4125171825895251]
[null,null,19.349191815704163,null,13.926442179966799]
[null,null,-7.5125533478288062,null,11.182301710233839]