{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Data","Totals","Stats"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"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":"1904","formulas":"cached_only"}

{"sheet":"Data","index":0,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,6]],"flags":["formulas_cached_only"]}
[null,"PGM"]
[null,"SS","SM","SF","MM","MF","FF",null,null,"MX(Xtra-fast)"]
["Tuesday AM Lab"]
["Arb",0,3,0,18,4,0,null,null,0]
["McKnight",0,1,0,22,2,0,null,null,0]
["Tuesday PM Lab"]
["Arb",1,6,3,19,5,1,null,null,0]
["McKnight",0,3,1,28,3,0,null,null,0]
["Wednesday Lab"]
["Arb",0,5,0,31,2,0,null,null,1]
["McKnight",0,0,0,37,2,0,null,null,2]
["Thursday AM Lab"]
["Arb",0,3,0,32,4,0,null,null,0]
["McKnight",0,0,0,33,5,0,null,null,0]
["Thursday PM Lab"]
["Arb",0,6,0,22,8,1,null,null,0]
["McKnight",0,0,0,32,1,0,null,null,0]

{"sheet":"Totals","index":1,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,7]],"flags":["formulas_cached_only"]}
[null,"PGM"]
[null,"SS","SM","SF","MM","MF","FF","MX(Xtra-fast)"]
["Tuesday AM Lab"]
["Arb",0,3,0,18,4,0,0]
["McKnight",0,1,0,22,2,0,0]
["Tuesday PM Lab"]
["Arb",1,6,3,19,5,1,0]
["McKnight",0,3,1,28,3,0,0]
["Wednesday Lab"]
["Arb",0,5,0,31,2,0,1]
["McKnight",0,0,0,37,2,0,2]
["Thursday AM Lab"]
["Arb",0,3,0,32,4,0,0]
["McKnight",0,0,0,33,5,0,0]
["Thursday PM Lab"]
["Arb",0,6,0,22,8,1,0]
["McKnight",0,0,0,32,1,0,0]
[]
[]
["TOTAL"]
["Arb",1,23,3,122,23,2]
["McKnight",0,4,1,152,13,0]
[]
[]
[null,"S","M","F","Row Totals"]
["Arb",28,290,30,348]
["McKnight",5,321,14,340]
["Column Totals",33,611,44,688]

{"sheet":"Stats","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[14,0,14,1],[18,0,18,1],[8,0,9,0],[10,0,11,0]],"flags":["formulas_cached_only"]}
["Calculation of Chi Square Statistic for Gall Fly PGM Allele Data, Winter 2006"]
[null,null,"S","M","F","Row Totals",null,"%M"]
[null,"Arb",28,290,30,348,null,83.33333333333333]
[null,"McKnight",5,321,14,340,null,94.41176470588235]
[null,"Column Totals",33,611,44,688]
[]
[]
[null,null,"S","M","F"]
["Arb","observed",28,290,30]
[null,"expected",16.691860465116278,309.05232558139534,22.25581395348837]
["McKnight","observed",5,321,14]
[null,"expected",16.308139534883722,301.94767441860466,21.74418604651163]
[]
[]
["Chi Square Calculation",null,"S","M","F"]
[null,"Arb",7.660860813426974,1.1745296184930016,2.694685426842605]
[null,"McKnight",7.841116361978196,1.2021656095163662,2.7580897898271366]
[]
["Chi Square Statistic",null,23.33144762008428]
[]
[null,null,"> 5.991, so two groups of gall fly larvae significantly different"]