{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["bloodpressure.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":"bloodpressure.xls","index":0,"n_rows":61,"n_cols":4,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Subject","Age","BaselineBP","NewBP"]
["N1",68,100.3,79.900000000000006]
["N2",59,91.6,85.9]
["N3",60,90,85.7]
["N4",57,93.7,85.8]
["N5",58,95.4,85.3]
["N6",59,99.6,83.2]
["N7",69,97.9,82.9]
["N8",65,96,84.9]
["N9",59,96.9,86.1]
["N10",41,95.4,90]
["N11",65,93.9,85.2]
["N12",61,89.7,86.9]
["N13",64,94.6,84.3]
["N14",65,98,84.8]
["N15",70,93.4,83.5]
["N16",66,93.4,83.9]
["N17",65,101.7,83.4]
["N18",61,101.6,82.8]
["N19",61,98.1,83.9]
["N20",62,98.8,83.7]
["N21",69,101.5,81.3]
["N22",56,96.4,85.2]
["N23",54,89,78]
["N24",48,98.1,85.8]
["N25",56,96.6,86]
["N26",60,98.1,86.3]
["N27",61,94.1,85.6]
["N28",66,101.2,82.8]
["N29",56,95.9,85.6]
["N30",49,98.7,86.3]
["N31",54,93.9,87.4]
["A1",62,97.4,91.1]
["A2",56,93.2,89.4]
["A3",52,92.8,88.6]
["A4",68,95,90.3]
["A5",75,88.8,89.3]
["A6",60,98.4,89.7]
["A7",61,92.1,92.4]
["A8",60,95.7,91.4]
["A9",75,95.8,90.1]
["A10",57,98.6,91.5]
["A11",48,97.2,91]
["A12",63,94,89.3]
["A13",61,94.4,91.8]
["A14",66,96.1,92.1]
["A15",56,91.6,91.9]
["A16",65,91.2,90.9]
["A17",64,95.5,87.9]
["A18",51,93.2,88.2]
["A19",68,91.6,90]
["A20",66,96.9,91.4]
["A21",65,102.6,91.5]
["A22",65,96.9,89.8]
["A23",70,93.7,91.2]
["A24",68,90.9,88.4]
["A25",68,99.1,91.4]
["A26",58,95.9,89.8]
["A27",63,94.4,90.4]
["A28",70,91.4,93.6]
["A29",56,93.4,91.6]

{"sheet":"text","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["To observe the effectiveness of a medication in reductiong blood pressure, an experiment was conducted in which researches collected data from a random sample of individuals who were considered to have high blood pressure. The diastolic blood pressure of these individuals was recorded, after which they were placed on the medication. One month later, their diastolic pressure was recorded again. Determine whether the data gives good evidence that the medication was effective in reducing blood presssure."]

{"sheet":"solution","index":2,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Subject","Age","BaselineBP","NewBP"]
["N1",68,100.3,79.900000000000006]
["N2",59,91.6,85.9]
["N3",60,90,85.7]
["N4",57,93.7,85.8,null,null,null,"t-Test: Paired Two Sample for Means"]
["N5",58,95.4,85.3]
["N6",59,99.6,83.2,null,null,null,null,"BaselineBP","NewBP"]
["N7",69,97.9,82.9,null,null,null,"Mean",95.521666666666633,87.473333333333343]
["N8",65,96,84.9,null,null,null,"Variance",11.005454802259882,12.51181920903954]
["N9",59,96.9,86.1,null,null,null,"Observations",60,60]
["N10",41,95.4,90,null,null,null,"Pearson Correlation",-0.24400810601848186]
["N11",65,93.9,85.2,null,null,null,"Hypothesized Mean Difference",0]
["N12",61,89.7,86.9,null,null,null,"df",59]
["N13",64,94.6,84.3,null,null,null,"t Stat",11.528265468552416]
["N14",65,98,84.8,null,null,null,"P(T<=t) one-tail",4.7827042783132805E-17]
["N15",70,93.4,83.5,null,null,null,"t Critical one-tail",1.6710930321038957]
["N16",66,93.4,83.9,null,null,null,"P(T<=t) two-tail",9.5654085566265611E-17]
["N17",65,101.7,83.4,null,null,null,"t Critical two-tail",2.0009953780882688]
["N18",61,101.6,82.8]
["N19",61,98.1,83.9]
["N20",62,98.8,83.7]
["N21",69,101.5,81.3]
["N22",56,96.4,85.2]
["N23",54,89,78]
["N24",48,98.1,85.8]
["N25",56,96.6,86]
["N26",60,98.1,86.3]
["N27",61,94.1,85.6]
["N28",66,101.2,82.8]
["N29",56,95.9,85.6]
["N30",49,98.7,86.3]
["N31",54,93.9,87.4]
["A1",62,97.4,91.1]
["A2",56,93.2,89.4]
["A3",52,92.8,88.6]
["A4",68,95,90.3]
["A5",75,88.8,89.3]
["A6",60,98.4,89.7]
["A7",61,92.1,92.4]
["A8",60,95.7,91.4]
["A9",75,95.8,90.1]
["A10",57,98.6,91.5]
["A11",48,97.2,91]
["A12",63,94,89.3]
["A13",61,94.4,91.8]
["A14",66,96.1,92.1]
["A15",56,91.6,91.9]
["A16",65,91.2,90.9]
["A17",64,95.5,87.9]
["A18",51,93.2,88.2]
["A19",68,91.6,90]
["A20",66,96.9,91.4]
["A21",65,102.6,91.5]
["A22",65,96.9,89.8]
["A23",70,93.7,91.2]
["A24",68,90.9,88.4]
["A25",68,99.1,91.4]
["A26",58,95.9,89.8]
["A27",63,94.4,90.4]
["A28",70,91.4,93.6]
["A29",56,93.4,91.6]