{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["확률"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"확률","index":0,"n_rows":20,"n_cols":28,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,1,17,3],[0,1,0,2],[13,25,13,28],[4,2,6,2],[14,25,14,26],[9,1,9,3],[11,1,11,3],[13,1,13,3],[14,1,14,3]]}
[null,"경우의 수",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"withseok.tistory.com"]
[null,6,"가지",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"목표횟수","횟수"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,339]
[null,null,"결과",null,1,{"$f":"E4+1","v":2},{"$f":"IF(ISERROR(IF(F4+1>$B$2,\"\",F4+1)),\"\",IF(F4+1>$B$2,\"\",F4+1))","v":3},{"$f":"IF(ISERROR(IF(G4+1>$B$2,\"\",G4+1)),\"\",IF(G4+1>$B$2,\"\",G4+1))","v":4},5,6,{"$f":"IF(ISERROR(IF(J4+1>$B$2,\"\",J4+1)),\"\",IF(J4+1>$B$2,\"\",J4+1))","v":""},{"$f":"IF(ISERROR(IF(K4+1>$B$2,\"\",K4+1)),\"\",IF(K4+1>$B$2,\"\",K4+1))","v":""},{"$f":"IF(ISERROR(IF(L4+1>$B$2,\"\",L4+1)),\"\",IF(L4+1>$B$2,\"\",L4+1))","v":""},{"$f":"IF(ISERROR(IF(M4+1>$B$2,\"\",M4+1)),\"\",IF(M4+1>$B$2,\"\",M4+1))","v":""},{"$f":"IF(ISERROR(IF(N4+1>$B$2,\"\",N4+1)),\"\",IF(N4+1>$B$2,\"\",N4+1))","v":""},{"$f":"IF(ISERROR(IF(O4+1>$B$2,\"\",O4+1)),\"\",IF(O4+1>$B$2,\"\",O4+1))","v":""},{"$f":"IF(ISERROR(IF(P4+1>$B$2,\"\",P4+1)),\"\",IF(P4+1>$B$2,\"\",P4+1))","v":""},{"$f":"IF(ISERROR(IF(Q4+1>$B$2,\"\",Q4+1)),\"\",IF(Q4+1>$B$2,\"\",Q4+1))","v":""},{"$f":"IF(ISERROR(IF(R4+1>$B$2,\"\",R4+1)),\"\",IF(R4+1>$B$2,\"\",R4+1))","v":""},{"$f":"IF(ISERROR(IF(S4+1>$B$2,\"\",S4+1)),\"\",IF(S4+1>$B$2,\"\",S4+1))","v":""},{"$f":"IF(ISERROR(IF(T4+1>$B$2,\"\",T4+1)),\"\",IF(T4+1>$B$2,\"\",T4+1))","v":""},{"$f":"IF(ISERROR(IF(U4+1>$B$2,\"\",U4+1)),\"\",IF(U4+1>$B$2,\"\",U4+1))","v":""},{"$f":"IF(ISERROR(IF(V4+1>$B$2,\"\",V4+1)),\"\",IF(V4+1>$B$2,\"\",V4+1))","v":""},{"$f":"IF(ISERROR(IF(W4+1>$B$2,\"\",W4+1)),\"\",IF(W4+1>$B$2,\"\",W4+1))","v":""},{"$f":"IF(ISERROR(IF(X4+1>$B$2,\"\",X4+1)),\"\",IF(X4+1>$B$2,\"\",X4+1))","v":""}]
[null,null,{"$f":"INT(RAND()*B2)+1","v":5},null,{"$f":"IF(E6=1,1,\"\")","v":""},{"$f":"IF(F6=1,1,\"\")","v":""},"","",1,"","","","","","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(E4=\"\",\"\",IF($C$5=E4,1,0))","v":0},{"$f":"IF(F4=\"\",\"\",IF($C$5=F4,1,0))","v":0},0,0,1,0,{"$f":"IF(K4=\"\",\"\",IF($C$5=K4,1,0))","v":""},"","","","","","","","","","","","","",""]
[null,null,null,null,70,59,50,52,50,58,"","","","","","","","","","","","","","",""]
[null,null,null,"누계원본",{"$f":"IF(E4=\"\",\"\",E6+E7)","v":70},{"$f":"IF(F4=\"\",\"\",F6+F7)","v":59},50,52,51,58,{"$f":"IF(K4=\"\",\"\",K6+K7)","v":""},"","","","","","","","","","","","","",""]
[null,null,null,"초기원본",{"$f":"IF(E4=\"\",\"\",0)","v":0},{"$f":"IF(F4=\"\",\"\",0)","v":0},0,0,0,0,{"$f":"IF(K4=\"\",\"\",0)","v":""},"","","","","","","","","","","","","",""]
[null,"총횟수",null,null,{"$f":"IF(E4=\"\",\"\",SUM($E$7:$Y$7))","v":339},339,339,339,339,339,{"$f":"IF(K4=\"\",\"\",SUM($E$7:$Y$7))","v":""},"","","","","","","","","","","","","","","최고값","최저값","차이"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"최고값","최저값","차이"]
[null,"통계적 확률",null,null,{"$f":"IF(SUM($E$7:$Y$7)=0,\"\",IF(E4=\"\",\"\",E7/SUM($E$7:$Y$7)))","v":0.20648967551622419},0.17404129793510326,0.14749262536873156,0.15339233038348082,0.14749262536873156,0.17109144542772861,{"$f":"IF(SUM($E$7:$Y$7)=0,\"\",IF(K4=\"\",\"\",K7/SUM($E$7:$Y$7)))","v":""},"","","","","","","","","","","","","","",{"$f":"MAX($E$12:$Y$12)","v":0.20648967551622419},{"$f":"MIN($E$12:$Y$12)","v":0.14749262536873156},{"$f":"Z12-AA12","v":5.8997050147492625E-2}]
[]
[null,"수학적 확률",null,null,{"$f":"IF(E4=\"\",\"\",1/$B$2)","v":0.16666666666666666},{"$f":"IF(F4=\"\",\"\",1/$B$2)","v":0.16666666666666666},0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,{"$f":"IF(K4=\"\",\"\",1/$B$2)","v":""},"","","","","","","","","","","","","","","ESC키를 누르고, \"종료\"를 선택하면, 매크로 작동이 정지 됩니다."]
[null,"오차",null,null,{"$f":"IF(SUM($E$10:$Y$10)=0,\"\",IF(E4=\"\",\"\",E14-E12))","v":-3.9823008849557529E-2},-7.3746312684365989E-3,1.9174041297935096E-2,1.3274336283185834E-2,1.9174041297935096E-2,-4.4247787610619538E-3,{"$f":"IF(SUM($E$10:$Y$10)=0,\"\",IF(K4=\"\",\"\",K14-K12))","v":""},"","","","","","","","","","","","","","","절댓값 최대 오차",null,{"$f":"IF(ISERROR(INDEX(E19:Y19,,MATCH(1,E20:Y20,0))),\"\",INDEX(E19:Y19,,MATCH(1,E20:Y20,0)))","v":3.9823008849557529E-2}]
[]
[]
[null,"순위",null,null,{"$f":"IF(OR(SUM($E$7:$Y$7)=0,E7=\"\"),\"\",RANK(E7,$E$7:$Y$7))","v":1},2,5,4,5,3,{"$f":"IF(OR(SUM($E$7:$Y$7)=0,K7=\"\"),\"\",RANK(K7,$E$7:$Y$7))","v":""},"","","","","","","","","","","","","",""]
[null,null,"오차절댓값",null,{"$f":"IF(E15=\"\",\"\",ABS(E15))","v":3.9823008849557529E-2},{"$f":"IF(F15=\"\",\"\",ABS(F15))","v":7.3746312684365989E-3},1.9174041297935096E-2,1.3274336283185834E-2,1.9174041297935096E-2,4.4247787610619538E-3,"",{"$f":"IF(L15=\"\",\"\",ABS(L15))","v":""},"","","","","","",{"$f":"IF(S15=\"\",\"\",ABS(S15))","v":""},"","","","","",""]
[null,null,"절댓값순위",null,{"$f":"IF(E19=\"\",\"\",RANK(E19,$E$19:$Y$19))","v":1},5,2,4,2,6,"",{"$f":"IF(L19=\"\",\"\",RANK(L19,$E$19:$Y$19))","v":""},"","","","","","",{"$f":"IF(S19=\"\",\"\",RANK(S19,$E$19:$Y$19))","v":""},"","","","","",""]