{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["χ2分布"],"not_rendered":{"charts":1,"images":0,"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":"χ2分布","index":0,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[11,3,11,5],[10,3,10,5],[0,4,0,7],[10,1,10,2]]}
["i","確率 pi","yi","yi2","サンプリングした確率変数xの値→",null,null,null,null,null,"区間","階級下限","度数",null,"階級値","相対度数","計算値"]
[1,{"$f":"IF(A2<=B$10,RAND(),\"\")","v":0.70227309625155165},{"$f":"IF(A2<=B$10,_xlfn.NORM.INV(B2,0,1),\"\")","v":0.53094945238935487},{"$f":"IF(A2<=B$10,C2^2,\"\")","v":0.28190732099255583},null,null,null,null,null,null,"0≦χ2≦1",1,{"$f":"FREQUENCY(I:I,L2:L26)","v":0},null,0.5,{"$f":"M2/G$11","v":{"$error":"#DIV/0!"}},{"$f":"1/(2*_xlfn.GAMMA(B$10/2))*(O2/2)^(B$10/2-1)*EXP(-O2/2)","v":9.735009788392561E-2}]
[2,{"$f":"IF(A3<=B$10,RAND(),\"\")","v":0.87946741218908731},{"$f":"IF(A3<=B$10,_xlfn.NORM.INV(B3,0,1),\"\")","v":1.1723285445121758},{"$f":"IF(A3<=B$10,C3^2,\"\")","v":1.3743542162780367},null,null,null,null,null,null,"1<χ2≦2",2,0,null,1.5,{"$f":"M3/G$11","v":{"$error":"#DIV/0!"}},{"$f":"1/(2*_xlfn.GAMMA(B$10/2))*(O3/2)^(B$10/2-1)*EXP(-O3/2)","v":0.17713745727788049}]
[3,0.86588603703531541,1.1071526719465701,1.2257870389984293,null,null,null,null,null,null,"2<χ2≦3",3,0,null,2.5,{"$error":"#DIV/0!"},0.17906549803761881]
[4,6.5372920169928683E-2,-1.5111672650518502,2.2836265029642888,null,null,null,null,null,null,"3<χ2≦4",4,0,null,3.5,{"$error":"#DIV/0!"},0.15205220051913951]
[5,"","","",null,null,null,null,null,null,"4<χ2≦5",5,0,null,4.5,{"$error":"#DIV/0!"},0.11857412763209738]
[6,"","","",null,null,null,null,null,null,"5<χ2≦6",6,0,null,5.5,{"$error":"#DIV/0!"},8.7900809159222909E-2]
[7,"","","",null,null,null,null,null,null,"6<χ2≦7",7,0,null,6.5,{"$error":"#DIV/0!"},6.300808772654827E-2]
[8,"","","",null,null,null,null,null,null,"7<χ2≦8",8,0,null,7.5,{"$error":"#DIV/0!"},4.4095773480017073E-2]
["n=",4,"x＝",{"$f":"SUM(D2:D9)","v":5.1656750792333108},null,null,null,null,null,null,"8<χ2≦9",9,0,null,8.5,{"$error":"#DIV/0!"},3.0311497056623418E-2]
["使い方⇒","ウェブページへ",null,"累積サンプリング回数",null,null,0,null,null,null,"9<χ2≦10",10,0,null,9.5,{"$error":"#DIV/0!"},2.0547776107411507E-2]
[null,null,null,"サンプリング回数",null,null,1,null,null,null,"10<χ2≦11",11,0,null,10.5,{"$error":"#DIV/0!"},1.3774735797851134E-2]
[null,null,null,null,null,null,null,null,null,null,"11<χ2≦12",12,0,null,11.5,{"$error":"#DIV/0!"},9.1504947899652932E-3]
[null,null,null,null,null,null,null,null,null,null,"12<χ2≦13",13,0,null,12.5,{"$error":"#DIV/0!"},6.0326691757115912E-3]
[null,null,null,null,null,null,null,null,null,null,"13<χ2≦14",14,0,null,13.5,{"$error":"#DIV/0!"},3.9517187201702133E-3]
[null,null,null,null,null,null,null,null,null,null,"14<χ2≦15",15,0,null,14.5,{"$error":"#DIV/0!"},2.5743821595542401E-3]
[null,null,null,null,null,null,null,null,null,null,"15<χ2≦16",16,0,null,15.5,{"$error":"#DIV/0!"},1.6691273447307891E-3]
[null,null,null,null,null,null,null,null,null,null,"16<χ2≦17",17,0,null,16.5,{"$error":"#DIV/0!"},1.0776915488693785E-3]
[null,null,null,null,null,null,null,null,null,null,"17<χ2≦18",18,0,null,17.5,{"$error":"#DIV/0!"},6.9326829738141174E-4]
[null,null,null,null,null,null,null,null,null,null,"18<χ2≦19",19,0,null,18.5,{"$error":"#DIV/0!"},4.4451639078395044E-4]
[null,null,null,null,null,null,null,null,null,null,"19<χ2≦20",20,0,null,19.5,{"$error":"#DIV/0!"},2.8418648568798546E-4]
[null,null,null,null,null,null,null,null,null,null,"20<χ2≦21",21,0,null,20.5,{"$error":"#DIV/0!"},1.8120719185835116E-4]
[null,null,null,null,null,null,null,null,null,null,"21<χ2≦22",22,0,null,21.5,{"$error":"#DIV/0!"},1.1526906970166676E-4]
[null,null,null,null,null,null,null,null,null,null,"22<χ2≦23",23,0,null,22.5,{"$error":"#DIV/0!"},7.3166049304130369E-5]
[null,null,null,null,null,null,null,null,null,null,"23<χ2≦24",24,0,null,23.5,{"$error":"#DIV/0!"},4.6349783359801308E-5]
["©金沢工業大学",null,null,null,null,null,null,null,null,null,"24<χ2≦25",25,0,null,24.5,{"$error":"#DIV/0!"},2.9308844026790178E-5]
[null,null,null,null,null,null,null,null,null,null,"25<χ2",null,0]