{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["예제7.1","예제7.2","예제7.3","예제7.4","예제7.5","연습문제"],"not_rendered":{"charts":0,"images":0,"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":"예제7.1","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,4,1]]}
["문",1,2,3]
["관찰도수",23,36,31]
["기대도수"]
[]
["카이제곱검정 p-값"]

{"sheet":"예제7.2","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["범주 ","남자","여자","합계"]
["관측빈도수",30,20,{"$f":"SUM(B2:C2)","v":50}]
["기대확률",0.5,0.5,{"$f":"SUM(B3:C3)","v":1}]
["기대도수",{"$f":"$D$2*B3","v":25},{"$f":"$D$2*C3","v":25},50]

{"sheet":"예제7.3","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,8]]}
["관찰도수",{"$nulls":4},"기대도수"]
[null,"A","B","합계",null,null,"A","B","합계"]
["청소년",20,30,{"$f":"SUM(B3:C3)","v":50},null,"청소년",{"$f":"$D$5*$D3/$D$5*B$5/$D$5","v":25},{"$f":"$D$5*$D3/$D$5*C$5/$D$5","v":25},{"$f":"SUM(G3:H3)","v":50}]
["장년",30,20,{"$f":"SUM(B4:C4)","v":50},null,"장년",{"$f":"$D$5*$D4/$D$5*B$5/$D$5","v":25},{"$f":"$D$5*$D4/$D$5*C$5/$D$5","v":25},{"$f":"SUM(G4:H4)","v":50}]
["합계",{"$f":"SUM(B3:B4)","v":50},{"$f":"SUM(C3:C4)","v":50},{"$f":"SUM(B5:C5)","v":100},null,"합계",{"$f":"SUM(G3:G4)","v":50},{"$f":"SUM(H3:H4)","v":50},{"$f":"SUM(G5:H5)","v":100}]

{"sheet":"예제7.4","index":3,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,6,0,10]]}
["관찰도수",{"$nulls":5},"기대도수"]
[null,"A1","A2","A3","합계",null,null,"A1","A2","A3","합계"]
["B1",8,15,18,{"$f":"SUM(B3:D3)","v":41},null,"B1",{"$f":"$E$5*$E3/$E$5*B$5/$E$5","v":12.3},{"$f":"$E$5*$E3/$E$5*C$5/$E$5","v":16.399999999999999},12.3,{"$f":"SUM(H3:J3)","v":41}]
["B2",22,25,12,{"$f":"SUM(B4:D4)","v":59},null,"B2",{"$f":"$E$5*$E4/$E$5*B$5/$E$5","v":17.7},23.6,17.7,{"$f":"SUM(H4:J4)","v":59}]
["합계",{"$f":"SUM(B3:B4)","v":30},{"$f":"SUM(C3:C4)","v":40},{"$f":"SUM(D3:D4)","v":30},{"$f":"SUM(B5:D5)","v":100},null,"합계",{"$f":"SUM(H3:H4)","v":30},{"$f":"SUM(I3:I4)","v":40},{"$f":"SUM(J3:J4)","v":30},{"$f":"SUM(H5:J5)","v":100}]

{"sheet":"예제7.5","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4],[7,0,7,4],[14,1,14,2]]}
["관찰도수"]
[null,"A","B","C","합계"]
["30이하",120,30,50,{"$f":"SUM(B3:D3)","v":200}]
["30~44",10,75,15,{"$f":"SUM(B4:D4)","v":100}]
["45이상",10,30,60,{"$f":"SUM(B5:D5)","v":100}]
["합계",{"$f":"SUM(B3:B5)","v":140},{"$f":"SUM(C3:C5)","v":135},{"$f":"SUM(D3:D5)","v":125},{"$f":"SUM(B6:D6)","v":400}]
[]
["기대도수"]
[null,"A","B","C","합계"]
["30이하",{"$f":"$E$6*$E3/$E$6*B$6/$E$6","v":70},{"$f":"$E$6*$E3/$E$6*C$6/$E$6","v":67.5},62.5,{"$f":"SUM(B10:D10)","v":200}]
["30~44",{"$f":"$E$6*$E4/$E$6*B$6/$E$6","v":35},33.75,31.25,{"$f":"SUM(B11:D11)","v":100}]
["45이상",35,33.75,31.25,{"$f":"SUM(B12:D12)","v":100}]
["합계",{"$f":"SUM(B10:B12)","v":140},{"$f":"SUM(C10:C12)","v":135},{"$f":"SUM(D10:D12)","v":125},{"$f":"SUM(B13:D13)","v":400}]
[]
[null,"카이제곱검정 p-값"]

{"sheet":"연습문제","index":5,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"응답자","성별","폰 색상","응답자","성별","폰 색상",null,null,"뉴스","연속극","스포츠","오락","영화","교양","합계",null,"행정구역","발생건수","인구수"]
[null,null,1,"남","백색",16,"여","백색",null,"남",513,109,172,103,75,28,{"$f":"SUM(K3:P3)","v":1000},null,"서울특별시",53569,9853972]
[null,null,2,"남","백색",17,"여","백색",null,"여",153,616,10,127,69,25,{"$f":"SUM(K4:P4)","v":1000},null,"부산광역시",14893,3655437]
[null,null,3,"남","백색",18,"여","백색",{"$nulls":10},"대구광역시",15562,2473990]
[null,null,4,"남","백색",19,"여","백색",{"$nulls":10},"인천광역시",17633,2466338]
[null,null,5,"남","검은색",20,"여","백색",null,null,"감상/관람","TV시청","취미/오락","스포츠/여행","수면/가사","합계",null,null,"광주광역시",7853,1350948]
[null,null,6,"남","검은색",21,"여","백색",null,"남",80,396,95,167,240,{"$f":"SUM(K8:O8)","v":978},null,null,"대전광역시",7728,1365961]
[null,null,7,"남","검은색",22,"여","백색",null,"여",88,428,41,64,346,{"$f":"SUM(K9:O9)","v":967},null,null,"울산광역시",5115,1012110]
[null,null,8,"남","검은색",23,"여","백색",null,"합계",{"$f":"SUM(K8:K9)","v":168},{"$f":"SUM(L8:L9)","v":824},{"$f":"SUM(M8:M9)","v":136},{"$f":"SUM(N8:N9)","v":231},{"$f":"SUM(O8:O9)","v":586},{"$f":"SUM(K10:O10)","v":1945},null,null,"경기도",53172,8937752]
[null,null,9,"남","검은색",24,"여","백색",{"$nulls":10},"강원도",13179,1484536]
[null,null,10,"남","검은색",25,"여","검은색",{"$nulls":10},"충청북도",11850,1462621]
[null,null,11,"남","검은색",26,"여","검은색",null,null,"감상/관람","TV시청","취미/오락","스포츠/여행","수면/가사","합계",null,null,"충청남도",13830,1840410]
[null,null,12,"남","유채색",27,"여","유채색",null,"중졸이하",25,234,29,33,172,{"$f":"SUM(K14:O14)","v":493},null,null,"전라북도",14526,1887239]
[null,null,13,"남","유채색",28,"여","유채색",null,"고졸",93,425,71,112,285,{"$f":"SUM(K15:O15)","v":986},null,null,"전라남도",13017,1994287]
[null,null,14,"남","유채색",29,"여","유채색",null,"대재이상",50,165,36,86,129,{"$f":"SUM(K16:O16)","v":466},null,null,"경상북도",21948,2716218]
[null,null,15,"남","유채색",30,"여","유채색",null,"합계",{"$f":"SUM(K14:K16)","v":168},{"$f":"SUM(L14:L16)","v":824},{"$f":"SUM(M14:M16)","v":136},{"$f":"SUM(N14:N16)","v":231},{"$f":"SUM(O14:O16)","v":586},{"$f":"SUM(K17:O17)","v":1945},null,null,"경상남도",16218,2970929]
[{"$nulls":18},"제주도",3048,512541]
[]
[]
[]
[]
[null,null,null," "]