{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["tree","solution","text"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"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":"tree","index":0,"n_rows":105,"n_cols":3,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["RootStock","TrunkGirth","Weight"]
["I",358,760]
["I",375,821]
["I",393,928]
["I",394,1009]
["I",360,766]
["I",351,726]
["I",398,1209]
["I",362,750]
["II",409,1036]
["II",406,1094]
["II",487,1635]
["II",498,1517]
["II",438,1197]
["II",465,1244]
["II",469,1495]
["II",440,1026]
["III",376,912]
["III",444,1398]
["III",438,1197]
["III",467,1613]
["III",448,1475]
["III",478,1571]
["III",457,1506]
["III",456,1458]
["IV",389,944]
["IV",405,1241]
["IV",405,1023]
["IV",392,1067]
["IV",327,693]
["IV",395,1085]
["IV",427,1242]
["IV",385,1017]
["V",404,1084]
["V",416,1151]
["V",479,1381]
["V",442,1242]
["V",347,673]
["V",441,1137]
["V",464,1455]
["V",457,1325]
["VI",376,800]
["VI",314,606]
["VI",375,790]
["VI",399,853]
["VI",334,610]
["VI",321,562]
["VI",363,707]
["VI",395,952]
["VII",266,414]
["VII",241,335]
["VII",380,885]
["VII",401,1012]
["VII",296,489]
["VII",315,616]
["VII",358,788]
["VII",343,733]
["IX",231,375]
["IX",250,410]
["IX",219,335]
["IX",275,560]
["IX",205,251]
["IX",213,272]
["IX",266,478]
["IX",226,278]
["X",299,506]
["X",381,882]
["X",362,737]
["X",372,772]
["X",369,827]
["X",368,821]
["X",408,1149]
["X",410,1035]
["XII",431,1609]
["XII",465,1658]
["XII",484,1789]
["XII",527,2375]
["XII",463,1556]
["XII",412,1418]
["XII",514,2266]
["XII",522,2508]
["XIII",387,1052]
["XIII",414,1167]
["XIII",387,981]
["XIII",390,944]
["XIII",327,737]
["XIII",424,1392]
["XIII",421,1326]
["XIII",382,1052]
["XV",448,1258]
["XV",435,1304]
["XV",451,1290]
["XV",450,1288]
["XV",428,1176]
["XV",424,1177]
["XV",482,1331]
["XV",469,1490]
["XVI",452,1499]
["XVI",412,1412]
["XVI",425,1488]
["XVI",460,1751]
["XVI",464,1937]
["XVI",457,1823]
["XVI",463,1838]
["XVI",473,1817]

{"sheet":"solution","index":1,"n_rows":105,"n_cols":19,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["RootStock","TrunkGirth","Weight"]
["I",358,760]
["I",375,821]
["I",393,928]
["I",394,1009]
["I",360,766]
["I",351,726,null,null,"Weight"]
["I",398,1209]
["I",362,750,null,null,"Mean",1102.4230769230769]
["II",409,1036,null,null,"Standard Error",44.727019692494139]
["II",406,1094,null,null,"Median",1075.5]
["II",487,1635,null,null,"Mode",821]
["II",498,1517,null,null,"Standard Deviation",456.12789239375275]
["II",438,1197,null,null,"Sample Variance",208052.6542195669]
["II",465,1244,null,null,"Kurtosis",0.39428582842569115]
["II",469,1495,null,null,"Skewness",0.45742431014899099]
["II",440,1026,null,null,"Range",2257]
["III",376,912,null,null,"Minimum",251]
["III",444,1398,null,null,"Maximum",2508]
["III",438,1197,null,null,"Sum",114652]
["III",467,1613,null,null,"Count",104]
["III",448,1475]
["III",478,1571]
["III",457,1506,null,null,"Bin","Frequency"]
["III",456,1458,null,null,251,1]
["IV",389,944,null,null,476.7,7]
["IV",405,1241,null,null,702.4,10]
["IV",405,1023,null,null,928.09999999999991,20,null,null,null,null,null,null,null,null,null,null,"Shapiro-Wilk Test"]
["IV",392,1067,null,null,1153.8,20]
["IV",327,693,null,null,1379.5,17,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C2","v":760}]
["IV",395,1085,null,null,1605.1999999999998,16,null,null,null,null,null,null,null,null,null,null,"W",{"$f":"[1]!SHAPIRO(C3:C105)","v":0.98083018205697514}]
["IV",427,1242,null,null,1830.8999999999999,8,null,null,null,null,null,null,null,null,null,null,"p-value",{"$f":"[1]!SWTEST(C3:C105)","v":0.14116482395011387}]
["IV",385,1017,null,null,2056.6,2,null,null,null,null,null,null,null,null,null,null,"alpha",0.05]
["V",404,1084,null,null,2282.3000000000002,1,null,null,null,null,null,null,null,null,null,null,"normal",{"$f":"IF(S32<S33,\"no\",\"yes\")","v":"yes"}]
["V",416,1151,null,null,"More",2]
["V",479,1381]
["V",442,1242]
["V",347,673]
["V",441,1137]
["V",464,1455]
["V",457,1325]
["VI",376,800]
["VI",314,606]
["VI",375,790]
["VI",399,853]
["VI",334,610]
["VI",321,562]
["VI",363,707]
["VI",395,952]
["VII",266,414]
["VII",241,335]
["VII",380,885]
["VII",401,1012]
["VII",296,489]
["VII",315,616]
["VII",358,788]
["VII",343,733]
["IX",231,375]
["IX",250,410]
["IX",219,335]
["IX",275,560]
["IX",205,251]
["IX",213,272]
["IX",266,478]
["IX",226,278]
["X",299,506]
["X",381,882]
["X",362,737]
["X",372,772]
["X",369,827]
["X",368,821]
["X",408,1149]
["X",410,1035]
["XII",431,1609]
["XII",465,1658]
["XII",484,1789]
["XII",527,2375]
["XII",463,1556]
["XII",412,1418]
["XII",514,2266]
["XII",522,2508]
["XIII",387,1052]
["XIII",414,1167]
["XIII",387,981]
["XIII",390,944]
["XIII",327,737]
["XIII",424,1392]
["XIII",421,1326]
["XIII",382,1052]
["XV",448,1258]
["XV",435,1304]
["XV",451,1290]
["XV",450,1288]
["XV",428,1176]
["XV",424,1177]
["XV",482,1331]
["XV",469,1490]
["XVI",452,1499]
["XVI",412,1412]
["XVI",425,1488]
["XVI",460,1751]
["XVI",464,1937]
["XVI",457,1823]
["XVI",463,1838]
["XVI",473,1817]

{"sheet":"text","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["A forestry commision once sought a way to accurately estimate the weights of trees without having to go through the damaging process of cutting the trees down to weight them. The weights and trunk girths of 104 tree specimens were measured in hopes that girth would be useful in predicting weight. Begin checking the conditions for the simple linear regression analysis by performing a test for normality for the response, tree weight."]