{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Asociacni_tabulka","List2","List3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"Asociacni_tabulka","index":0,"n_rows":48,"n_cols":28,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,7,46,9],[47,7,47,9],[37,7,37,9],[38,7,38,9],[37,13,37,15],[38,13,38,15],[23,21,23,22],[24,21,24,22],[25,21,25,22],[27,21,27,22],[17,23,17,24],[18,21,18,22],[19,21,19,22],[20,21,20,22],[17,21,17,22],[22,21,22,22],[22,23,22,24],[20,0,20,1],[21,0,21,1],[1,1,1,14],[2,1,2,14],[3,1,3,13],[18,0,18,1],[19,0,19,1],[17,2,17,3],[12,7,12,9],[20,7,20,9]]}
["Asociační tabulky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Martina Litschmannová (2013)"]
["Autor:","Martina Litschmannová"]
["Email:","martina.litschmannova@vsb.cz"]
["Citace:","Litschmannová, M., 2011, Vybrané kapitoly z pravděpodobnosti, VŠB-TU Ostrava, multimediální výukový materiál vyhotoveny v rámci projektu projektu „Matematika pro inženýry 21. století -inovace výuky matematiky na technických školách v nových podmínkách rychle se vyvíjející informační a technické společnosti“ ( CZ.1.07/2.2.00/07.0332)"]
["Popis: Tento applet testuje nezávislost v asociační tabulce (Fisherův test) a určuje odhady měr závislosti v asociační tabulce."]
[]
["Návod:"]
["1) Stiskněte tlačítko RESET a tím, v případě potřeby, vymažte dříve použité nastavení. "]
["2) V polích B15:C17 zadejte názvy analyzovaných proměnných a jejich variant."]
["3) Zadejte hladinu významnosti pro výpočet intervalových odhadů relativní šance a relativního rizika."]
[]
[]
[null,"X","Y",null,null,null,null,"Hladina významnosti:",null,null,null,{"$f":"_xlfn.NORM.S.INV(1-K13/2)","v":{"$error":"#NUM!"}},{"$f":"ROUND(100*(1-K13),0)","v":100}]
["Název "]
["+"]
["-"]
[]
[null,null,{"$f":"IF(C14=\"\",\"Y\",C14)","v":"Y"},null,{"$f":"IF(OR(a=\"\",b=\"\",cc=\"\",d=\"\",K13=\"\"),1,0)","v":1},null,null,"Míry kontingence a míry asociace",null,null,null,null,null,null,null,null,null,null,null,null,null,"očekávané četnosti",null,{"$f":"C18","v":"Y"}]
[{"$f":"IF(B14=\"\",\"X\",B14)","v":"X"},null,{"$f":"IF(C15=\"\",\"+\",C15)","v":"+"},{"$f":"IF(C16=\"\",\"-\",C16)","v":"-"},"Celkem",null,null,"Míry kontingence:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A19","v":"X"},null,{"$f":"C19","v":"+"},{"$f":"D19","v":"-"}]
[{"$f":"IF(B15=\"\",\"+\",B15)","v":"+"},null,null,null,{"$f":"IF(OR(a=\"\",b=\"\"),\"\",a+b)","v":""},null,null,"Koeficient kontingence:",null,null,{"$f":"IF(id=1,\"\",ROUND(SQRT(K/(K+n)),4))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"A20","v":"+"},null,{"$f":"C$22*$E20/$E$22","v":{"$error":"#VALUE!"}},{"$f":"D$22*$E20/$E$22","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(B16=\"\",\"+\",B16)","v":"+"},null,null,null,{"$f":"IF(OR(cc=\"\",d=\"\"),\"\",cc+d)","v":""},null,null,"Cramerovo V:",null,null,{"$f":"IF(id=1,\"\",ROUND(SQRT(K/n),4))","v":""},null,null,null,null,null,null,null,null,null,null,"+",null,{"$f":"C$22*$E21/$E$22","v":{"$error":"#VALUE!"}},{"$f":"D$22*$E21/$E$22","v":{"$error":"#VALUE!"}}]
["Celkem",null,{"$f":"IF(OR(a=\"\",cc=\"\"),\"\",a+cc)","v":""},{"$f":"IF(OR(b=\"\",d=\"\"),\"\",b+d)","v":""},{"$f":"IF(OR(E20=\"\",E21=\"\"),\"\",E20+E21)","v":""}]
[null,null,null,null,null,null,null,"Míry asociace:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Chi",null,{"$f":"X18","v":"Y"}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"absolutní šance pro \",A20,\":\")","v":"absolutní šance pro +:"},null,null,{"$f":"IF(id=1,\"\",ROUND(a/b,3))","v":""},{"$f":"a/b","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"V19","v":"X"},null,{"$f":"X19","v":"+"},{"$f":"Y19","v":"-"}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"absolutní šance pro \",A21,\":\")","v":"absolutní šance pro +:"},null,null,{"$f":"IF(id=1,\"\",ROUND(cc/d,3))","v":""},{"$f":"cc/d","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"V20","v":"+"},null,{"$f":"((C20-X20)^2)/X20","v":{"$error":"#VALUE!"}},{"$f":"((D20-Y20)^2)/Y20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"relativní šance: ",null,null,{"$f":"IF(id=1,\"\",CONCATENATE(\"bodový odhad: \",Y30,\",       \",M13,\"% intervalový odhad: <\",X31,\";\",X32,\">\"))","v":""},null,null,null,null,null,null,null,null,null,null,"+",null,{"$f":"((C21-X21)^2)/X21","v":{"$error":"#VALUE!"}},{"$f":"((D21-Y21)^2)/Y21","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",null,{"$f":"SUM(X25:Y26)","v":{"$error":"#VALUE!"}},{"$f":"(n*((ABS(a*d-b*cc)-n/2)^2))/(E20*E21*C22*D22)","v":{"$error":"#VALUE!"}},{"$f":"((b-cc)^2)/(b+cc)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"absolutní riziko pro \",A20,\":\")","v":"absolutní riziko pro +:"},null,null,{"$f":"IF(id=1,\"\",ROUND(a/(a+b),3))","v":""},{"$f":"a/(a+b)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"absolutní riziko pro \",A21,\":\")","v":"absolutní riziko pro +:"},null,null,{"$f":"IF(id=1,\"\",ROUND(cc/(cc+d),3))","v":""},{"$f":"cc/(cc+d)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"OR",null,{"$f":"L24/L25","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(OR,3)","v":{"$error":"#DIV/0!"}},null,"pom",{"$f":"SQRT((1/a)+(1/b)+(1/cc)+(1/d))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"relativní riziko: ",null,null,{"$f":"IF(id=1,\"\",CONCATENATE(\"bodový odhad: \",Y34,\",       \",M13,\"% intervalový odhad: <\",X35,\";\",X36,\">\"))","v":""},null,null,null,null,null,null,null,null,null,null,"OR_dolní mez",null,{"$f":"ROUND(OR*AB31,3)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"EXP(-$AB$30*z)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR_horní mez",null,{"$f":"ROUND(OR*AB32,3)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"EXP($AB$30*z)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Testy nezávislosti"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RR",null,{"$f":"K29/K30","v":{"$error":"#VALUE!"}},{"$f":"ROUND(RR,3)","v":{"$error":"#VALUE!"}},null,"pom",{"$f":"SQRT((b/(a*(a+b)))+(d/(cc*(cc+d))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"χ2 test nezávislosti",null,null,null,null,null,"χ2 test nezávislosti s Yatesovou korekcí",null,null,null,null,null,null,null,"RR_dolní mez",null,{"$f":"ROUND(RR*AB35,3)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"EXP(-$AB$34*z)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RR_horní mez",null,{"$f":"ROUND(RR*AB36,3)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"EXP($AB$34*z)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Pozorovaná hodnota:",null,null,{"$f":"IF(id=1,\"\",ROUND(K,3))","v":""},null,null,"Pozorovaná hodnota:",null,null,{"$f":"IF(id=1,\"\",ROUND(Y28,3))","v":""}]
[null,null,null,null,null,null,null,"Stupně volnosti:",null,null,1,null,null,"Stupně volnosti:",null,null,1]
[null,null,null,null,null,null,null,"p-hodnota:",null,null,{"$f":"IF(id=1,\"\",ROUND(_xlfn.CHISQ.TEST(C20:D21,X20:Y21),3))","v":""},null,null,"p-hodnota:",null,null,{"$f":"IF(id=1,\"\",ROUND(_xlfn.CHISQ.DIST.RT(Y28,1),3))","v":""}]
[]
[null,null,null,null,null,null,null,"Pro výpočet Fisherova exaktního testu lze použít online calculator: ",null,null,null,null,null,null,"http://graphpad.com/quickcalcs/contingency1/"]
[]
[]
[null,null,null,null,null,null,null,"Mc Nemarův test o symetrii asociační tabulky"]
[]
[null,null,null,null,null,null,null,"Pozorovaná hodnota:",null,null,{"$f":"IF(id=1,\"\",ROUND(McNemar,3))","v":""}]
[null,null,null,null,null,null,null,"Stupně volnosti:",null,null,1]
[null,null,null,null,null,null,null,"p-hodnota:",null,null,{"$f":"IF(id=1,\"\",ROUND(_xlfn.CHISQ.DIST.RT(McNemar,1),3))","v":""}]

{"sheet":"List2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}