{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["zadani","reseni"],"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","formulas":"cached_only"}

{"sheet":"zadani","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,"Určete objem dřevěného kvádru. v tabulce najdete rozměry jeho jednotlivých hran."]
[]
[null,null,"Nezapomeňte na:"]
[null,null,null,"- určení aritmetických průměrů z naměřených hodnot"]
[null,null,null,"- určení středních kvadratických odchylek"]
[null,null,null,"- vyloučení hrubých chyb ( ty v tabulce zvýrazněte třeba šedou barvou)"]
[null,null,null,"- to, že objem měříme nepřímo a tudíž je potřeba určit chybu nepřímého měření."]
[]
[]
[null,null,null,"V="]
[]
[null,null,null,"a (mm)","b (mm)","c (mm)"]
[]
[null,null,null,12.56,24.22,35.44]
[null,null,null,12.58,24.11,35.28]
[null,null,null,12.32,24.27,35.22]
[null,null,null,12.66,24.18,35.31]
[null,null,null,12.62,24.28,35.34]
[null,null,null,12.43,24.16,35.32]
[null,null,null,12.6,24.17,35.33]
[null,null,null,12.49,24.18,35.36]
[null,null,null,12.45,24.2,35.18]
[null,null,null,12.71,24.19,35.31]
[null,null,null,12.12,24.23,35.26]
[null,null,null,12.46,24.19,35.23]
[null,null,null,12.47,24.25,35.27]
[null,null,null,12.37,24.21,35.49]
[null,null,null,12.57,24.16,35.39]
[null,null,null,12.42,24.22,35.09]
[null,null,null,12.38,24.24,35.37]
[null,null,null,12.55,24.19,35.43]
[null,null,null,12.41,24.21,35.25]
[null,null,null,12.65,24.19,35.72]
[null,null,null,12.51,24.18,35.42]
[null,null,null,12.37,24.17,35.4]
[null,null,null,12.59,24.11,35.21]
[null,null,null,12.54,24.23,35.37]
[null,null,null,12.45,24.2,35.33]
[null,null,null,12.64,24.26,35.42]
[null,null,null,12.56,24.23,35.23]
[null,null,null,12.49,24.24,35.25]
[null,null,null,12.65,24.19,35.16]
[null,null,null,12.51,24.12,35.36]

{"sheet":"reseni","index":1,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Původní data:",null,null,null,"Data po vyřazení hrubých chyb"]
[]
[null,"a (mm)","b (mm)","c (mm)",null,null,"a (mm)","b (mm)","c (mm)",null,"zjištěné rozměry tedy jsou:"]
[{"$nulls":13},"rel. Chyba"]
[1,12.56,24.22,35.44,null,1,12.56,24.22,35.44,null,"a","12,52+-0,02","mm",0.0015974440894568692]
[2,12.58,24.11,35.28,null,2,12.58,24.11,35.28,null,"b","24,20+-0,01","mm",0.0004132231404958678]
[3,12.32,24.27,35.22,null,3,12.32,24.27,35.22,null,"c","35,31+-0,02","mm",0.0005664117813650524]
[4,12.66,24.18,35.31,null,4,12.66,24.18,35.31]
[5,12.62,24.28,35.34,null,5,12.62,24.28,35.34]
[6,12.43,24.16,35.32,null,6,12.43,24.16,35.32,null,"Objem je"]
[7,12.6,24.17,35.33,null,7,12.6,24.17,35.33,null,"a*b*c"]
[8,12.49,24.18,35.36,null,8,12.49,24.18,35.36]
[9,12.45,24.2,35.18,null,9,12.45,24.2,35.18,null,"V= ",72.03,"mm3"]
[10,12.71,24.19,35.31,null,10,12.71,24.19,35.31]
[11,12.12,24.23,35.26,null,11,null,24.23,35.26,null,"rel. Chyba určení objemu",null,0.002577079011317789]
[12,12.46,24.19,35.23,null,12,12.46,24.19,35.23,null,"abs. Chyba určení objemu",null,0.18562700118522035]
[13,12.47,24.25,35.27,null,13,12.47,24.25,35.27]
[14,12.37,24.21,35.49,null,14,12.37,24.21,35.49,null,"tedy objem je ","72,0+-0,2","mm3"]
[15,12.57,24.16,35.39,null,15,12.57,24.16,35.39]
[16,12.42,24.22,35.09,null,16,12.42,24.22,35.09]
[17,12.38,24.24,35.37,null,17,12.38,24.24,35.37]
[18,12.55,24.19,35.43,null,18,12.55,24.19,35.43]
[19,12.41,24.21,35.25,null,19,12.41,24.21,35.25]
[20,12.65,24.19,35.72,null,20,12.65,24.19]
[21,12.51,24.18,35.42,null,21,12.51,24.18,35.42]
[22,12.37,24.17,35.4,null,22,12.37,24.17,35.4]
[23,12.59,24.11,35.21,null,23,12.59,24.11,35.21]
[24,12.54,24.23,35.37,null,24,12.54,24.23,35.37]
[25,12.45,24.2,35.33,null,25,12.45,24.2,35.33]
[26,12.64,24.26,35.42,null,26,12.64,24.26,35.42]
[27,12.56,24.23,35.23,null,27,12.56,24.23,35.23]
[28,12.49,24.24,35.25,null,28,12.49,24.24,35.25]
[29,12.65,24.19,35.16,null,29,12.65,24.19,35.16]
[30,12.51,24.12,35.36,null,30,12.51,24.12,35.36]
[]
["průměr",12.504333333333332,24.19933333333334,35.324666666666666,null,"průměr",12.51758620689655,24.19933333333334,35.31103448275862]
["stř. kv. Od.",0.12333535257765386,0.042986231423026794,0.11875019661205742,null,"stř. kv. Od.",0.10147678032837285,0.042986231423026794,0.09397358396250852]
[]
["3s interval je",{"$nulls":4},"3s interval je"]
["od",12.13432727560037,24.07037463906426,34.96841607683049,null,"od",12.21315586591143,24.07037463906426,35.029113730871096]
["do",12.874339391066293,24.32829202760242,35.68091725650284,null,"do",12.822016547881669,24.32829202760242,35.59295523464615]
[]
["je tedy nutno vyloučit hodnoty:",{"$nulls":4},"odchylky ar. Průměru:"]
[null,12.12,null,35.72,null,null,0.018843765040195602,0.007848176204176391,0.017450456453627597]