{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["peppers.xls","text","solution"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"peppers.xls","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["angle"]
[3]
[11]
[-7]
[2]
[3]
[8]
[-3]
[-2]
[13]
[4]
[7]
[-1]
[4]
[7]
[-1]
[4]
[12]
[-3]
[7]
[5]
[3]
[-1]
[9]
[-7]
[2]
[4]
[8]
[-2]

{"sheet":"text","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["An agricultural company interested in cutting down the time needed to harvest its crops hired a mechanical engineer to design a mechanical harvester for bell peppers.  To heighten the precision of his machine, the engineer measured and recorded the angle at which peppers hang on the plant. Perform one sample t-test to determine whether the data gives good evidence that peppers hang on plants at an anngle (different from zero)"]

{"sheet":"solution","index":2,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["angle"]
[3]
[11]
[-7]
[2,null,null,null,"z.test",{"$f":"_xlfn.Z.TEST(A2:A29,0)","v":7.5137753077373054E-4}]
[3]
[8]
[-3]
[-2]
[13]
[4]
[7]
[-1]
[4]
[7]
[-1]
[4]
[12]
[-3]
[7]
[5]
[3]
[-1]
[9]
[-7]
[2]
[4]
[8]
[-2]