{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Question","TentativeAnswer","trial","trial (2)","trial (3)","rironchi","AVEandSD","Record"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Question","index":0,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"DIME　Project　のShaker　で，確率",null,null,null,null,"で「ヒット」が生起する事象のことを"]
[]
[null,null,"紹介しました。さて，ここで問題です。この試行を，12回行うと",null,null,null,null,null,null,"何回ヒットがでますか？　"]

{"sheet":"TentativeAnswer","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"4回ですか？"]
[null,null,null,"12×",null,"=4","と考えたのですね。"]
[]
[null,null,"確かにそんな話をしましたね。　でもね，この4ってのは，"]
[]
[null,null,"期待値","って言うのでした。",null,null,"平均すれば，だいたいこのような回数"]
[]
[null,null,"起こるのだけど，実際にやってみると，実測値は，理論値である　これ"]
[]
[null,null,"の周囲にばらつくのですから，",null,null,null,"時によって違う・・・と答えた方がよろしいかも。"]
[]
[null,null,null,null,"次のシートで実際にやってみましょう。12回シェイカーを振る動作を"]
[null,null,null,null,"本数は適当ですけど，（見栄えを気にして）64本繰り返させてみます。"]

{"sheet":"trial","index":2,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2],[14,9,14,10]]}
["〇","起こった本数",null,5,10,15,20,25,30,35,40,45,"【64】"]
[null,"12回",0,{"$f":"REPT($A$1,C2)","v":""}]
[null,"11回",0,{"$f":"REPT($A$1,C3)","v":""}]
[null,"10回",0,""]
[null,"_9回",0,""]
[null,"_8回",1,"〇"]
[null,"_7回",1,"〇"]
[null,"_6回",6,"〇〇〇〇〇〇"]
[null,"_5回",12,"〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_4回",17,"〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_3回",18,"〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_2回",7,"〇〇〇〇〇〇〇"]
[null,"_1回",1,"〇"]
[null,"_0回",1,"〇"]
["ショートカットキーは［Ctrl］+a",null,null,64,"【平均】",3.875,"【S.D.】",1.4306903927824497,"【日付】","2024-12-20T21:08:33"]

{"sheet":"trial (2)","index":3,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2],[14,9,14,10]]}
["〇","起こった本数",null,5,10,15,20,25,30,35,40,45,"【64】"]
[null,"12回",0,{"$f":"REPT($A$1,C2)","v":""}]
[null,"11回",0,{"$f":"REPT($A$1,C3)","v":""}]
[null,"10回",0,""]
[null,"_9回",0,""]
[null,"_8回",2,"〇〇"]
[null,"_7回",1,"〇"]
[null,"_6回",4,"〇〇〇〇"]
[null,"_5回",13,"〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_4回",18,"〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_3回",13,"〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_2回",10,"〇〇〇〇〇〇〇〇〇〇"]
[null,"_1回",2,"〇〇"]
[null,"_0回",1,"〇"]
["ショートカットキーは［Ctrl］+a",null,null,64,"【平均】",3.828125,"【S.D.】",1.556786428632714,"【日付】","2024-12-20T21:07:59"]

{"sheet":"trial (3)","index":4,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2],[14,9,14,10]]}
["〇","起こった本数",null,5,10,15,20,25,30,35,40,45,"【64】"]
[null,"12回",0,{"$f":"REPT($A$1,C2)","v":""}]
[null,"11回",0,{"$f":"REPT($A$1,C3)","v":""}]
[null,"10回",0,""]
[null,"_9回",0,""]
[null,"_8回",1,"〇"]
[null,"_7回",1,"〇"]
[null,"_6回",6,"〇〇〇〇〇〇"]
[null,"_5回",12,"〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_4回",17,"〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_3回",18,"〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_2回",7,"〇〇〇〇〇〇〇"]
[null,"_1回",1,"〇"]
[null,"_0回",1,"〇"]
["ショートカットキーは［Ctrl］+a",null,null,64,"【平均】",3.875,"【S.D.】",1.4306903927824497,"【日付】","2024-12-20T21:08:33"]

{"sheet":"rironchi","index":5,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2],[14,9,14,10]]}
["〇","理論値の計算",null,5,10,15,20,25,30,35,40,45,"【64】"]
[null,"12回",0,{"$f":"REPT($A$1,C2)","v":""}]
[null,"11回",0,{"$f":"REPT($A$1,C3)","v":""}]
[null,"10回",0,""]
[null,"_9回",0,""]
[null,"_8回",1,"〇"]
[null,"_7回",3,"〇〇〇"]
[null,"_6回",7,"〇〇〇〇〇〇〇"]
[null,"_5回",12,"〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_4回",15,"〇〇〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_3回",14,"〇〇〇〇〇〇〇〇〇〇〇〇〇〇"]
[null,"_2回",8,"〇〇〇〇〇〇〇〇"]
[null,"_1回",3,"〇〇〇"]
[null,"_0回",0,""]
["ショートカットキーは［Ctrl］+a",null,null,64,"【平均】",4.0000000000000027,"【S.D.】",5.1889836006545398,"【日付】","2024-12-20T20:49:29"]

{"sheet":"AVEandSD","index":6,"n_rows":64,"n_cols":5,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[3,{"$f":"COUNT(A:A)","v":64},{"$f":"AVERAGE(A:A)","v":3.875},{"$f":"STDEVP(A:A)","v":1.4306903927824497},{"$f":"NOW()","v":"2024-12-20T21:17:58.290"}]
[2]
[4]
[1]
[6]
[4]
[3]
[3]
[4]
[0]
[5]
[4]
[4]
[4]
[6]
[4]
[5]
[5]
[4]
[3]
[4]
[3]
[5]
[4]
[6]
[3]
[8]
[2]
[3]
[5]
[5]
[5]
[3]
[3]
[6]
[2]
[5]
[4]
[4]
[5]
[2]
[3]
[4]
[5]
[4]
[3]
[4]
[3]
[5]
[3]
[3]
[2]
[3]
[6]
[3]
[3]
[3]
[2]
[2]
[4]
[4]
[6]
[7]
[5]

{"sheet":"Record","index":7,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,6,2,7]]}
[null,"新たに書き込む行",null,"➡",16]
[null,"回数","平均","標準偏差"]
[null,64,3.828125,1.9328952336779663,"2024-12-20T21:07:29"]
[null,64,3.734375,1.4920852386425516,"2024-12-20T21:07:33"]
[null,64,3.5625,1.5398356243443649,"2024-12-20T21:07:37"]
[null,64,4,1.6393596310755001,"2024-12-20T21:07:40"]
[null,64,4.4375,1.5699820858850588,"2024-12-20T21:07:42"]
[null,64,3.96875,1.5709148409446008,"2024-12-20T21:07:45"]
[null,64,4.171875,1.556786428632714,"2024-12-20T21:07:47"]
[null,64,4.125,1.6817030058842137,"2024-12-20T21:07:49"]
[null,64,4.203125,1.6219171478145855,"2024-12-20T21:07:52"]
[null,64,3.8125,1.4882351124738322,"2024-12-20T21:07:54"]
[null,64,4.40625,1.6556602723687006,"2024-12-20T21:07:57"]
[null,64,3.828125,1.556786428632714,"2024-12-20T21:07:59"]
[null,64,3.875,1.4306903927824497,"2024-12-20T21:08:33"]