{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["on_time_arrivals","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":"on_time_arrivals","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Airline","March_1999","June_1999","August_1999"]
["TWA",84.4,69.400000000000006,85]
["Southwest",80.3,77,80.400000000000006]
["Northwest",80.8,75.099999999999994,81]
["American",72.7,65.099999999999994,78.3]
["Delta",78.7,72.2,77.7]
["Continental",79.3,68.400000000000006,75.099999999999994]
["United",78.599999999999994,69.2,71.599999999999994]
["US Airways",73.599999999999994,68.900000000000006,70.099999999999994]
["Alaska",71.900000000000006,75.400000000000006,64.400000000000006]
["American West",76.5,70.3,62.5]

{"sheet":"text","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["The department of transportation recorded data that contains the percentage of airlines planes that arrived on time in 29 airports. Suppose you to examine the differences between March and June"]
[]
[]
[]
[]
[]
[]
["."]

{"sheet":"solution","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Airline","March_1999","June_1999","August_1999"]
["TWA",84.4,69.400000000000006,85]
["Southwest",80.3,77,80.400000000000006]
["Northwest",80.8,75.099999999999994,81]
["American",72.7,65.099999999999994,78.3]
["Delta",78.7,72.2,77.7]
["Continental",79.3,68.400000000000006,75.099999999999994]
["United",78.599999999999994,69.2,71.599999999999994]
["US Airways",73.599999999999994,68.900000000000006,70.099999999999994]
["Alaska",71.900000000000006,75.400000000000006,64.400000000000006]
["American West",76.5,70.3,62.5]
[]
[]
[null,null,null,null,null,null,null,null,"t-Test: Paired Two Sample for Means",null,null,"t-Test: Paired Two Sample for Means"]
[]
[null,null,null,null,null,null,null,null,null,"Variable 1","Variable 2"]
[null,null,null,null,null,null,null,null,"Mean",77.679999999999993,71.099999999999994,"Mean"]
[null,null,null,null,null,null,null,null,"Variance",15.835111111111107,13.975555555555555,"Variance"]
[null,null,null,null,null,null,null,null,"Observations",10,10,"Observations"]
[null,null,null,null,null,null,null,null,"Pearson Correlation",0.19762970956419285,null,"Pearson Correlation"]
[null,null,null,null,null,null,null,null,"Hypothesized Mean Difference",0,null,"Hypothesized Mean Difference"]
[null,null,null,null,null,null,null,null,"df",9,null,"df"]
[null,null,null,null,null,null,null,null,"t Stat",4.2535201536313307,null,"t Stat"]
[null,null,null,null,null,null,null,null,"P(T<=t) one-tail",1.0656944895141389E-3,null,"P(T<=t) one-tail"]
[null,null,null,null,null,null,null,null,"t Critical one-tail",1.8331129326562374,null,"t Critical one-tail"]
[null,null,null,null,null,null,null,null,"P(T<=t) two-tail",2.1313889790282778E-3,null,"P(T<=t) two-tail"]
[null,null,null,null,null,null,null,null,"t Critical two-tail",2.2621571627982053,null,"t Critical two-tail"]