{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["solutions","text","bullets.xls"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"solutions","index":0,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["powder","velocity",null,null,null,"powder","velocity",null,"Column1",null,null,null,2,28.3]
[1,27.3,null,null,null,1,27.3,null,null,null,null,null,2,27.9]
[1,28.1,null,null,null,1,28.1,null,"Mean",27.637499999999999,null,null,2,28.1,null,"Column1"]
[1,27.4,null,null,null,1,27.4,null,"Standard Error",0.13879262537016471,null,null,2,28.3]
[1,27.7,null,null,null,1,27.7,null,"Median",27.549999999999997,null,null,2,27.9,null,"Mean",28.060000000000002]
[1,28,null,null,null,1,28,null,"Mode",28.1,null,null,2,27.6,null,"Standard Error",9.683892697555968E-2]
[1,28.1,null,null,null,1,28.1,null,"Standard Deviation",0.39256482631171008,null,null,2,28.5,null,"Median",28]
[1,27.4,null,null,null,1,27.4,null,"Sample Variance",0.15410714285714308,null,null,2,27.9,null,"Mode",27.9]
[1,27.1,null,null,null,1,27.1,null,"Kurtosis",-1.8452046204930705,null,null,2,28.4,null,"Standard Deviation",0.30623157540948942]
[2,28.3,null,null,null,null,null,null,"Skewness",7.9401754685825832E-2,null,null,2,27.7,null,"Sample Variance",9.3777777777777821E-2]
[2,27.9,null,null,null,null,null,null,"Range",1,null,null,null,null,null,"Kurtosis",-1.3358623699249605]
[2,28.1,null,null,null,null,null,null,"Minimum",27.1,null,null,null,null,null,"Skewness",-1.9732302328276542E-2]
[2,28.3,null,null,null,null,null,null,"Maximum",28.1,null,null,null,null,null,"Range",0.89999999999999858]
[2,27.9,null,null,null,null,null,null,"Sum",221.1,null,null,null,null,null,"Minimum",27.6]
[2,27.6,null,null,null,null,null,null,"Count",8,null,null,null,null,null,"Maximum",28.5]
[2,28.5,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",280.60000000000002]
[2,27.9,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count",10]
[2,28.4]
[2,27.7]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Average of velocity"]
[null,null,null,null,null,null,null,"powder","Total"]
[null,null,null,null,null,null,null,1,27.637499999999999]
[null,null,null,null,null,null,null,2,28.060000000000002]
[null,null,null,null,null,null,null,"Grand Total",27.87222222222222]

{"sheet":"text","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["A goverment agency, assigned to compare the efficiency of weaponry used by state -level law enforcement with thay of weaponry used by the general public, performed an experiment where the muzzle velocities of cartriges made from two types of gunpowder were recorded. The same type of firearm and cartridge was used for both types of gunpowder in the study. However, one type of powder (powder 1) is avaliable for the general public and the other (powder 2) is made avaliable primarily to law enforcement officials. Determina the mean adn standard deviation, and give five number summary for each type of gunpowder. "]

{"sheet":"bullets.xls","index":2,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["powder","velocity"]
[1,27.3]
[1,28.1]
[1,27.4]
[1,27.7]
[1,28]
[1,28.1]
[1,27.4]
[1,27.1]
[2,28.3]
[2,27.9]
[2,28.1]
[2,28.3]
[2,27.9]
[2,27.6]
[2,28.5]
[2,27.9]
[2,28.4]
[2,27.7]