{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"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]]}
["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":5.4266262389244462},{"$f":"GETCELLC","v":"=AVERAGE(C8:C17)"},{"$f":"AVERAGE(E8:E17)","v":7},{"$f":"GETCELLC","v":"=AVERAGE(E8:E17)"}]
["StDev S",10,{"$f":"STDEV(C8:C17)","v":10.485378524140582},{"$f":"GETCELLC","v":"=STDEV(C8:C17)"},{"$f":"STDEV(E8:E17)","v":10.000000000000002},{"$f":"GETCELLC","v":"=STDEV(E8:E17)"}]
[null,"Data",{"$f":"NORMINV(RAND(),$B$6,$B$7)","v":9.4139402217056229},{"$f":"GETCELLC","v":"=NORMINV(RAND(),$B$6,$B$7)"},{"$f":"$B$6+(C8-$C$6)*$B$7/$C$7","v":10.802737281826449},{"$f":"GETCELLC","v":"=$B$6+(C8-$C$6)*$B$7/$C$7"}]
[null,null,{"$f":"NORMINV(RAND(),$B$6,$B$7)","v":3.3528850781166337},null,{"$f":"$B$6+(C9-$C$6)*$B$7/$C$7","v":5.022254364939311}]
[null,null,7.4217336011894464,null,8.9027518726879009]
[null,null,-11.144452987793581,null,-8.8039876086173532]
[null,null,-11.369473498925792,null,-9.0185916981255616]
[null,null,7.7103694441870188,null,9.1780264775417404]
[null,null,6.6621043103293349,null,8.1782865716868844]
[null,null,9.642157981555215,null,11.020390616252254]
[null,null,7.682508719965039,null,9.1514554537510051]
[null,null,24.89448951891552,null,25.566676668057369]
[]
["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":"GETCELLC","v":"=AVERAGE(C24:C33)"},{"$f":"AVERAGE(E24:E33)","v":7.0000000000000027},{"$f":"GETCELLC","v":"=AVERAGE(E24:E33)"}]
[null,null,{"$f":"STDEV(C24:C33)","v":10.000000000000002},{"$f":"GETCELLC","v":"=STDEV(C24:C33)"},{"$f":"STDEV(E24:E33)","v":9.9999999999999982},{"$f":"GETCELLC","v":"=STDEV(E24:E33)"}]
[null,null,{"$f":"sbGenNormDist(10,B6,B7)","v":9.6257322123004183},{"$f":"GETCELLC","v":"{=sbGenNormDist(10,B6,B7)}"},-6.768957531422906,{"$f":"GETCELLC","v":"-6.76895753142291"}]
[null,null,9.4256867553403474,null,7.8919607910245206]
[null,null,2.4640308700415359,null,-0.57206847152263762]
[null,null,21.888586038407592,null,22.054788386708026]
[null,null,13.495228077824631,null,3.8514074934670193]
[null,null,-7.123742937069121,null,-8.4887814965098052]
[null,null,5.2678668862214932,null,11.886820006929312]
[null,null,20.451416852488208,null,14.70389699410026]
[null,null,-6.577797586892574,null,9.0365266979592285]
[null,null,1.0829928313374548,null,16.404407129267014]