{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["주사위난수","배당액난수","기타난수","분산비교","확률구하기","정규분포그리기","표준정규분포표","예제 2.9","표준정규분포상위백분위수","표준점수","불량율"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["주사위눈",null,"표본",null,"계급","도수"]
[1]
[2]
[3]
[4]
[5]
[6]

{"sheet":"배당액난수","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["배당액","확률",null,"배당액 난수"]
[1000,{"$f":"1/10","v":0.1},null,null,null,"평균"]
[500,{"$f":"2/10","v":0.2}]
[100,{"$f":"3/10","v":0.3}]
[0,{"$f":"4/10","v":0.4}]
["합계",{"$f":"SUM(B2:B5)","v":1}]

{"sheet":"기타난수","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["일양분포","정규분포","베타분포","감마분포","로그노말"]
[0.91088595233008818,{"$f":"_xlfn.NORM.INV(A2,0,1)","v":1.3462307987459907},{"$f":"_xlfn.BETA.INV(A2,3,2)","v":0.86628245618922162},{"$f":"_xlfn.GAMMA.INV(A2,3,2)","v":10.976223874609587},{"$f":"_xlfn.LOGNORM.INV(A2,0,1)","v":3.842913484142362}]
[0.9685048982207709,{"$f":"_xlfn.NORM.INV(A3,0,1)","v":1.8592606370931022},{"$f":"_xlfn.BETA.INV(A3,3,2)","v":0.92367843966395924},{"$f":"_xlfn.GAMMA.INV(A3,3,2)","v":13.83833644866151},{"$f":"_xlfn.LOGNORM.INV(A3,0,1)","v":6.4189890540959897}]
[2.4353770561845761E-2,-1.9711428283874404,0.19233265072552985,1.2247177193208327,0.13929757199554524]
[0.33808404797509689,-0.41769777957606335,0.51678089284336415,4.1090925775066482,0.65856122900611092]
[0.95046845912045652,1.6494128607084029,0.90288064690594994,12.617336574238703,5.2039235020648409]
[0.9600207525864437,1.7509269445666156,0.91338979017735467,13.199214759125935,5.7599393467061226]
[0.36954863124484999,-0.33304904411981334,0.53675157715404287,4.3423597589467757,0.71673504165443691]
[0.39216284676656393,-0.27368631743916,0.55072298379248052,4.5112641169595804,0.76057061558435246]
[0.37272255623035372,-0.32465114697681313,0.53873029753982427,4.3659864544545739,0.72277945346406125]
[0.37907040620136112,-0.30792314677541749,0.54266977664050653,4.4133115328476835,0.73497180079146696]
[0.73613696707052823,0.63148100420091702,0.74873038237965694,7.662795678080899,1.8803933885874238]
[0.37604907376323743,-0.31587399970557301,0.54079768022649943,4.3907742085479295,0.72915131766054375]
[0.30509353923154392,-0.50980643288738869,0.49503757207198246,3.865245340572049,0.60061182625807075]
[0.52577288125247967,6.4648035977962259E-2,0.6289633967835272,5.5600637334177696,1.0667834888931842]
[0.67763298440504161,0.46109000660880195,0.71476122121762375,6.9835947436137156,1.5858015774795218]

{"sheet":"분산비교","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["X집단","Y집단"]
[-0.6,0.61699999999999999,null,null,"X집단","Y집단"]
[-2.5550000000000002,-1.5129999999999999,null,"표본평균"]
[0.48899999999999999,0.76500000000000001,null,"표본분산"]
[2.5529999999999999,0.82899999999999996]
[2.3969999999999998,1.1259999999999999]
[3.4660000000000002,1.7989999999999999]
[-4.367,-1.125]
[-0.46800000000000003,0.28100000000000003]
[2.19,0.70599999999999996]
[-2.173,-0.115]

{"sheet":"확률구하기","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["X~N(172, 3^2)",null,null,"Z~ N(0,1)"]
[]
["Pr(X≤170)=",null,null,"Pr(Z≤1)="]
[]
["Pr(X≤180)=",null,null,"Pr(Z≤1.645)="]
[]
["Pr(X>180)= ",null,null,"Pr(Z>-1)="]

{"sheet":"정규분포그리기","index":5,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,7,0,8]]}
["z","f(z)",{"$nulls":5},"X~N(172, 3^2)"]
[-3]
[-2.5,{"$nulls":6},"x","f(x)"]
[-2,{"$nulls":6},160]
[-1.5,{"$nulls":6},162]
[-1,{"$nulls":6},164]
[-0.5,{"$nulls":6},166]
[0,{"$nulls":6},168]
[0.5,{"$nulls":6},170]
[1,{"$nulls":6},172]
[1.5,{"$nulls":6},174]
[2,{"$nulls":6},176]
[2.5,{"$nulls":6},178]
[3,{"$nulls":6},180]
[{"$nulls":7},182]
[{"$nulls":7},184]

{"sheet":"표준정규분포표","index":6,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["z",0,0.01,0.02,0.03,0.04,0.05,0.06,7.0000000000000007E-2,0.08,0.09]
[0]
[0.1]
[0.2]
[0.3]
[0.4]
[0.5]
[0.6]
[0.7]
[0.8]
[0.9]
[1]
[1.1000000000000001]
[1.2]
[1.3]
[1.4]
[1.5]
[1.6]
[1.7]
[1.8]
[1.9]
[2]
[2.1]
[2.2000000000000002]
[2.2999999999999998]
[2.4]
[2.5]
[2.6]
[2.7]
[2.8]
[2.9]
[3]

{"sheet":"예제 2.9","index":7,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["1) Pr(X>=270)=","1-Pr(X<270)"]
[]
[]
["2) Pr(180<=X<=230)=","Pr(X<=230)-Pr(X<180)"]
[]
[]
["3) Pr(X>=k)=0.05"]
["k="]

{"sheet":"표준정규분포상위백분위수","index":8,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["1) Z0.025"]
[]
["2) Z0.05"]
[]
["3) Z0.01"]

{"sheet":"표준점수","index":9,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["번호","원점수","Z값","표준점수"]
[1,50]
[2,40]
[3,64]
[4,57]
[5,65]
[6,74]
[7,72]
[8,76]
[9,95]
[10,82]
[11,68]
[12,67]
[13,80]
[14,90]
[15,70]
["평균"]
["모표준편차"]

{"sheet":"불량율","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["6-시그마운동에서 불량율은 얼마가 되는가?"]