{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["CS 10.5.1","CS 10.5.2","CS 10.5.3","HW 10.5.6","smoking "],"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":"CS 10.5.1","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Ebert","Ratings"]
[null,null,"Down","Sideways","Up"]
["Siskel","Down",24,8,13,{"$f":"SUM(C3:E3)","v":45}]
["Ratings","Sideways",8,13,11,{"$f":"SUM(C4:E4)","v":32}]
[null,"Up",10,9,64,{"$f":"SUM(C5:E5)","v":83}]
[null,null,{"$f":"SUM(C3:C5)","v":42},{"$f":"SUM(D3:D5)","v":30},{"$f":"SUM(E3:E5)","v":88},{"$f":"SUM(C6:E6)","v":160}]
[]
["assuming",null,{"$f":"C$11*$F8/$F$11","v":11.8125},{"$f":"D$11*$F8/$F$11","v":8.4375},24.75,45]
["independence",null,{"$f":"C$11*$F9/$F$11","v":8.4},6,17.600000000000001,32]
[null,null,21.787500000000001,15.5625,45.65,83]
[null,null,42,30,88,160]
[]
[null,"(0-E)^2/E",{"$f":"(C3-C8)^2/C8","v":12.574404761904763},{"$f":"(D3-D8)^2/D8","v":2.2685185185185187E-2},5.5782828282828278]
[null,null,{"$f":"(C4-C9)^2/C9","v":1.9047619047619081E-2},8.1666666666666661,2.4750000000000005]
[null,null,{"$f":"(C5-C10)^2/C10","v":6.3772877223178437},2.7673192771084336,7.3761774370208109]
[null,"TS",{"$f":"SUM(C13:E15)","v":45.356871497534158}]
[null,"pvalue",{"$f":"_xlfn.CHISQ.DIST.RT(C16,4)","v":3.3514558653608654E-9}]
[null,"CV",{"$f":"_xlfn.CHISQ.INV.RT(0.05,4)","v":9.4877290367811575}]

{"sheet":"CS 10.5.2","index":1,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["city","stability","suicide",null,"stability","suicide"]
["New York",54.3,19.3,"mean",{"$f":"AVERAGE(B:B)","v":55.991999999999997},{"$f":"AVERAGE(C:C)","v":20.76}]
["Chicago",51.5,17,"median",{"$f":"MEDIAN(B:B)","v":56.5},{"$f":"MEDIAN(C:C)","v":19.3}]
["Philadelphia",64.599999999999994,17.5]
["Detroit",42.5,16.5]
["Los Angeles",20.3,23.8]
["Cleveland",52.2,20.100000000000001]
["St. Louis",62.4,24.8]
["Baltimore",72,18]
["Boston",59.4,14.8]
["Pittsburgh",70,14.9]
["San Francisco",43.8,40]
["Milwaukee",66.2,19.3]
["Buffalo",67.599999999999994,13.8]
["Washington",37.1,22.5]
["Minneapolis",56.3,23.8]
["New Orleans",82.9,17.2]
["Cincinnati",62.2,23.9]
["Newark",51.9,21.4]
["Kansas City",49.4,24.5]
["Seattle",30.7,31.7]
["Indianapolis",66.099999999999994,21,null,null,null,0,50,65,90]
["Rochester",68,17.2,null,"too many ",null,17,{"$f":"COUNTIFS($C:$C,\"<=\"&$G23,$C:$C,\">\"&$G22,$B:$B,\"<=\"&H$22,$B:$B,\">\"&G$22)","v":1},3,3,{"$f":"SUM(H23:J23)","v":7}]
["Jersey City",56.5,10.1,null,"interior cells",null,22,0,4,5,{"$f":"SUM(H24:J24)","v":9}]
["Louisville",78.7,16.600000000000001,null,"only 25 data",null,40,6,3,0,{"$f":"SUM(H25:J25)","v":9}]
["Portland",33.200000000000003,29.3,null,"points ",null,null,{"$f":"SUM(H23:H25)","v":7},{"$f":"SUM(I23:I25)","v":10},{"$f":"SUM(J23:J25)","v":8},{"$f":"SUM(H26:J26)","v":25}]
[null,null,null,null,"25/n2>=5"]
[null,null,null,null,null,"using",0,56,90]
[null,null,null,null,null,"means",21,{"$f":"COUNTIFS($C:$C,\"<=\"&$G29,$C:$C,\">\"&$G28,$B:$B,\"<=\"&H$28,$B:$B,\">\"&G$28)","v":4},{"$f":"COUNTIFS($C:$C,\"<=\"&$G29,$C:$C,\">\"&$G28,$B:$B,\"<=\"&I$28,$B:$B,\">\"&H$28)","v":11},{"$f":"SUM(H29:I29)","v":15}]
[null,null,null,null,null,null,40,{"$f":"COUNTIFS($C:$C,\"<=\"&$G30,$C:$C,\">\"&$G29,$B:$B,\"<=\"&H$28,$B:$B,\">\"&G$28)","v":7},{"$f":"COUNTIFS($C:$C,\"<=\"&$G30,$C:$C,\">\"&$G29,$B:$B,\"<=\"&I$28,$B:$B,\">\"&H$28)","v":3},{"$f":"SUM(H30:I30)","v":10}]
[null,null,null,null,null,null,null,{"$f":"SUM(H29:H30)","v":11},{"$f":"SUM(I29:I30)","v":14},{"$f":"SUM(H31:I31)","v":25}]
[]
[null,null,null,null,null,"using ",0,56.5,90,null,null,"(E-O)^2/E",{"$f":"(H34-H39)^2/H39","v":1.1268639053254437},{"$f":"(I34-I39)^2/I39","v":1.2207692307692306}]
[null,null,null,null,null,"medians",19.5,{"$f":"COUNTIFS($C:$C,\"<=\"&$G34,$C:$C,\">\"&$G33,$B:$B,\"<=\"&H$33,$B:$B,\">\"&G$33)","v":4},{"$f":"COUNTIFS($C:$C,\"<=\"&$G34,$C:$C,\">\"&$G33,$B:$B,\"<=\"&I$33,$B:$B,\">\"&H$33)","v":9},{"$f":"SUM(H34:I34)","v":13},null,null,{"$f":"(H35-H40)^2/H40","v":1.2207692307692306},{"$f":"(I35-I40)^2/I40","v":1.3224999999999998}]
[null,null,null,null,null,null,40,{"$f":"COUNTIFS($C:$C,\"<=\"&$G35,$C:$C,\">\"&$G34,$B:$B,\"<=\"&H$33,$B:$B,\">\"&G$33)","v":9},{"$f":"COUNTIFS($C:$C,\"<=\"&$G35,$C:$C,\">\"&$G34,$B:$B,\"<=\"&I$33,$B:$B,\">\"&H$33)","v":3},{"$f":"SUM(H35:I35)","v":12},null,"TS",{"$f":"SUM(M33:N34)","v":4.8909023668639051}]
[null,null,null,null,null,null,null,{"$f":"SUM(H34:H35)","v":13},{"$f":"SUM(I34:I35)","v":12},{"$f":"SUM(H36:I36)","v":25},null,"pvalue",{"$f":"_xlfn.CHISQ.DIST.RT(M35,1)","v":2.6998571522057875E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"CV",{"$f":"_xlfn.CHISQ.INV.RT(0.05,1)","v":3.8414588206941236}]
[null,null,null,null,null,"Assuming",0,56.5,90]
[null,null,null,null,null,"indep",19.5,{"$f":"$J39*H$41/$J$41","v":6.76},{"$f":"$J39*I$41/$J$41","v":6.24},13]
[null,null,null,null,null,null,40,{"$f":"$J40*H$41/$J$41","v":6.24},{"$f":"$J40*I$41/$J$41","v":5.76},12]
[null,null,null,null,null,null,null,13,12,25]

{"sheet":"CS 10.5.3","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Accused Witches",null,null,"Gender"]
[null,null,"female","male",null,null,"(E-O)^2/E",{"$f":"(C3-C8)^2/C8","v":1.5982163574548791E-2},{"$f":"(D3-D8)^2/D8","v":5.1215569636622264E-2}]
[null,"Y",14,5,{"$f":"SUM(C3:D3)","v":19},null,null,{"$f":"(C4-C9)^2/C9","v":1.8292837826291192E-3},{"$f":"(D4-D9)^2/D9","v":5.8620230306976858E-3}]
["Executed","N",127,39,{"$f":"SUM(C4:D4)","v":166},null,"TS",{"$f":"SUM(H2:I3)","v":7.4889040024497866E-2}]
[null,null,{"$f":"SUM(C3:C4)","v":141},{"$f":"SUM(D3:D4)","v":44},{"$f":"SUM(C5:D5)","v":185},null,"pvalue",{"$f":"_xlfn.CHISQ.DIST.RT(H4,1)","v":0.78434698100002354}]
[null,null,null,null,null,null,"CV",{"$f":"_xlfn.CHISQ.INV.RT(0.05,1)","v":3.8414588206941236}]
[null,null,"female","male"]
["assuming","Y",{"$f":"C$10*$E8/$E$10","v":14.481081081081081},{"$f":"D$10*$E8/$E$10","v":4.5189189189189189},19]
["independence","N",{"$f":"C$10*$E9/$E$10","v":126.51891891891891},{"$f":"D$10*$E9/$E$10","v":39.481081081081079},166]
[null,null,141,44,185]

{"sheet":"HW 10.5.6","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Child’s","Blood","Pressure"]
[null,null,"Lower","Middle","Upper"]
["Father’s","Lower",14,11,8,{"$f":"SUM(C4:E4)","v":33}]
["blood","Middle",11,11,9,{"$f":"SUM(C5:E5)","v":31}]
["pressure","Upper",6,10,12,{"$f":"SUM(C6:E6)","v":28}]
[null,null,{"$f":"SUM(C4:C6)","v":31},{"$f":"SUM(D4:D6)","v":32},{"$f":"SUM(E4:E6)","v":29},{"$f":"SUM(C7:E7)","v":92}]
[]
[null,null,{"$f":"C$12*$F9/$F$12","v":11.119565217391305},{"$f":"D$12*$F9/$F$12","v":11.478260869565217},10.402173913043478,33]
[null,null,{"$f":"C$12*$F10/$F$12","v":10.445652173913043},10.782608695652174,9.7717391304347831,31]
[null,null,9.4347826086956523,9.7391304347826093,8.8260869565217384,28]
[null,null,31,32,29,92]
[]
[null,"(0-E)^2/E",{"$f":"(C4-C9)^2/C9","v":0.74615368268944682},{"$f":"(D4-D9)^2/D9","v":1.9927536231884015E-2},0.55473399663804479]
[null,null,{"$f":"(C5-C10)^2/C10","v":2.9419083382346337E-2},4.3828892005610132E-3,6.0949364027663676E-2]
[null,null,1.2504508114606292,6.9875776397515191E-3,1.1413578924823309]
[null,"TS",{"$f":"SUM(C14:E16)","v":3.8143628337526589}]
[null,"pvalue",{"$f":"_xlfn.CHISQ.DIST.RT(C17,4)","v":0.43171165004796697}]
[null,"CV",{"$f":"_xlfn.CHISQ.INV.RT(0.05,4)","v":9.4877290367811575}]

{"sheet":"smoking ","index":4,"n_rows":341,"n_cols":8,"rows_kept":341,"cut":false,"hidden":false,"merged":[]}
["Smoker","Read",null,null,"read","headline","some","most"]
[1,1,null,"smoker",null,1,2,3]
[4,2,null,"heavy",1]
[4,3,null,"moderate",2]
[3,3,null,"light",3]
[4,2,null,"non",4]
[4,3]
[2,3]
[2,3]
[1,3]
[4,3]
[3,2]
[3,3]
[3,3]
[4,3]
[2,1]
[3,3]
[1,2]
[4,2]
[1,3]
[4,1]
[4,2]
[1,1]
[4,3]
[4,1]
[2,1]
[3,2]
[1,3]
[1,1]
[1,2]
[4,3]
[3,2]
[2,3]
[3,1]
[3,3]
[4,3]
[3,3]
[3,3]
[3,2]
[1,2]
[2,3]
[3,2]
[3,1]
[4,3]
[3,3]
[4,3]
[2,2]
[4,2]
[1,1]
[1,1]
[3,2]
[1,1]
[4,3]
[4,3]
[1,1]
[3,2]
[1,1]
[2,3]
[1,1]
[2,2]
[1,2]
[1,2]
[4,2]
[3,3]
[4,3]
[1,3]
[3,1]
[3,1]
[4,3]
[4,2]
[4,2]
[3,3]
[4,2]
[4,1]
[4,3]
[2,3]
[4,3]
[4,3]
[3,2]
[4,3]
[3,2]
[1,1]
[4,2]
[4,1]
[2,2]
[1,3]
[4,1]
[3,3]
[2,1]
[3,3]
[3,3]
[2,1]
[2,3]
[1,2]
[1,3]
[3,3]
[1,2]
[4,2]
[2,3]
[1,1]
[3,3]
[1,1]
[2,3]
[1,2]
[4,1]
[3,3]
[4,3]
[1,2]
[3,2]
[3,3]
[4,1]
[4,2]
[2,1]
[2,3]
[3,1]
[1,3]
[3,1]
[3,1]
[4,2]
[2,1]
[4,3]
[4,3]
[3,3]
[1,2]
[3,1]
[3,2]
[4,2]
[4,3]
[4,3]
[4,1]
[4,3]
[3,3]
[3,3]
[3,3]
[1,1]
[4,2]
[1,3]
[4,3]
[4,3]
[1,1]
[2,1]
[4,3]
[1,2]
[1,1]
[3,1]
[2,3]
[4,1]
[2,1]
[3,2]
[3,3]
[4,1]
[1,1]
[4,3]
[1,1]
[1,2]
[2,3]
[1,1]
[2,3]
[1,3]
[4,2]
[3,2]
[4,3]
[4,3]
[4,2]
[3,2]
[2,1]
[2,1]
[3,3]
[2,2]
[3,2]
[1,3]
[4,3]
[1,2]
[2,1]
[4,3]
[3,2]
[1,1]
[2,2]
[4,1]
[4,2]
[4,3]
[3,2]
[2,3]
[3,3]
[3,2]
[3,3]
[4,3]
[1,1]
[3,2]
[3,2]
[4,2]
[2,3]
[4,2]
[4,3]
[3,2]
[4,3]
[1,3]
[2,3]
[1,1]
[1,3]
[4,3]
[2,3]
[4,2]
[2,1]
[2,2]
[4,2]
[3,3]
[4,2]
[2,3]
[1,2]
[1,1]
[1,3]
[2,2]
[4,2]
[2,3]
[3,1]
[1,3]
[1,3]
[3,3]
[2,2]
[1,1]
[3,3]
[1,1]
[1,2]
[4,2]
[1,1]
[4,1]
[1,2]
[4,2]
[3,3]
[2,2]
[4,2]
[3,3]
[2,2]
[2,1]
[2,2]
[2,2]
[2,2]
[3,3]
[3,3]
[2,1]
[1,2]
[4,3]
[2,1]
[4,2]
[4,2]
[4,3]
[4,3]
[2,1]
[1,1]
[4,2]
[4,3]
[4,3]
[2,2]
[1,2]
[2,3]
[1,1]
[3,1]
[4,2]
[3,3]
[3,3]
[4,1]
[3,1]
[4,3]
[3,3]
[4,3]
[2,2]
[3,3]
[4,3]
[2,1]
[1,2]
[2,3]
[1,3]
[1,2]
[1,3]
[1,1]
[4,2]
[1,2]
[3,3]
[4,3]
[3,2]
[3,1]
[3,2]
[4,3]
[3,2]
[4,2]
[4,3]
[1,1]
[4,3]
[4,3]
[1,1]
[2,1]
[1,3]
[2,3]
[2,3]
[1,1]
[3,3]
[4,3]
[3,1]
[1,2]
[3,2]
[3,3]
[1,2]
[4,3]
[2,2]
[4,2]
[2,3]
[3,3]
[4,2]
[4,1]
[4,3]
[3,3]
[1,1]
[2,1]
[1,3]
[3,2]
[4,3]
[4,3]
[3,2]
[2,1]
[3,3]
[4,3]
[4,2]
[4,2]
[3,3]
[2,3]
[2,2]
[3,3]
[4,3]
[2,1]
[3,3]
[3,1]
[3,3]
[3,1]
[2,1]
[2,3]
[1,2]
[2,1]
[1,1]
[4,3]
[4,2]