{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["trt","n","y-mean","sd","sum(y^2)","x-mean","adj-ybar","b1","b0","SD(ybar')","V(ybar)","SSTRT","SSE(unad)","SSTRT(ua)",null,"x-mean","sd(x)","sum(x^2)",null,null,"SSE1(Adj)","SSE2(Adj)","SSE3(Adj)"]
[1,46,7.5,5.53,3963.6405000000004,12.43,8.11,0.7243355195029334,-1.4871865503709145,6.53,0.6648021739130435,183.07047922525732,1376.1405000000002,312.14321643455963,null,12.43,6.03,8743.4659,null,null,1376.1405000000002,1636.2405,100.91272157247167]
[2,43,8.79,5.19,4453.6725,13.09,8.92,0.7136929460580961,-0.674382296408309,6.74,0.6264209302325582,60.37575014534902,1131.3162000000002,74.35010014534913,null,13.09,5.9,8829.988299999999,null,null,1131.3162000000002,1462.02,10.299282122093036]
[3,41,10.98,5.51,6157.3804,13.56,10.77,0.7295495859422348,1.1757964905044567,6.9,0.740490243902439,18.134395487425518,1214.404,31.394796650216243,null,13.56,6.36,9156.8016,null,null,1214.404,1617.9840000000002,10.327263186181733]
[4,42,13.45,6.47,9314.201899999998,14.1,12.85,0.7247699978931101,3.255363607382952,6.83,0.9966880952380951,316.48445595592165,1716.2968999999998,469.95538618847957,null,14.1,6.92,10313.3624,null,null,1716.2968999999998,1963.3424,116.30650463088146]
["overall",172,10.104941860465118,null,23888.895299999996,13.272151162790697,10.104011627906976,0.7230238576324147,null,null,null,578.0650808139535,5438.1576000000005,887.8434994186046,null,13.272151162790697,null,37043.6182,null,null,5438.1576000000005,6679.5869,237.8457715116279]
[]
["ANOVA",{"$nulls":11},6326.001099418605,null,null,"Sxx",null,"Var(X)",39.4492327723378]
["Source","df","SS","MS","F",{"$nulls":10},6745.818804069764,null,"Var(Y)",36.99415847613213]
["Trt(Adj)",3,578.0650808139535,192.68836027131783,16.84]
["X",1,3837.0716382418095]
["Error",167,1910.8643803628313,11.44230167881935,{"$nulls":11},"b1",null,"Sum(XY)",28185.065407805017]
["Total",171,6326.001099418594,{"$nulls":12},0.7541932096905501]
[{"$nulls":15},"b0",null,"Sxy","b1*","r*","SSR*"]
["r",null,0.7788168198317695,{"$nulls":12},0.09517557550183398,null,5117.403079316642,0.7586036962969275,0.783371304158271,3882.080891410883]
[]
[]
[{"$nulls":15},"SSE(X,Trt)","SSR(X,TRT)",null,"check"]
[{"$nulls":15},1878.82296387952,4447.178135539074,null,4415.136719055763]
[]
[]
[]
[]
[]
[null,null,null,0.014815058192609865]
[null,null,null,0.08889034915565919]

{"sheet":"Sheet2","index":1,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["trt","n","mean(y)","sd(y)","sum(y^2)","x-mean","sd(x)","sum(x^2)","SSTrt1(U)","adj-ybar","b1","b0","SSR(TX)1","SSR(TX)4","SSR(TX)5"]
[1,46,7.5,5.53,3963.6405000000004,12.43,6.03,8743.4659,2587.5,8.11,0.7243355195029334,-1.4871865503709145,101.73929643779047,-1229.637312631512,1382.5698936990668]
[2,43,8.79,5.19,4453.6725,13.09,5.9,8829.988299999999,3322.3562999999995,8.92,0.7136929460580961,-0.674382296408309,19.55603371348461,-548.9046205738663,586.0550751362308]
[3,41,10.98,5.51,6157.3804,13.56,6.36,9156.8016,4942.9764000000005,10.77,0.7295495859422348,1.1757964905044567,56.68239287038647,945.2753424498197,-974.2711244554898]
[4,42,13.45,6.47,9314.201899999998,14.1,6.92,10313.3624,7597.904999999999,12.85,0.7247699978931101,3.255363607382952,445.09047308348056,2787.7288574542977,-2763.201838931413]
["overall",172,10.104941860465118,null,23888.895299999996,13.272151162790697,null,37043.6182,18450.737699999998,10.104011627906976,0.7230238576324147,null,623.0681961051421,1954.4622666987389,-1768.847994551605]
[]
[]
[]
["SSTrt(U)",887.8434994185955]
["SSR(T,X)",4379.687717171088]
["TSS",6326.001099418594]
["SSE(T,X)",1946.3133822475065]
["F(T|X)",16.84]
["SSR(T|X)",588.7889345577486]
["SSR(X)",3790.898782613339]
[]
[]
[]
[]
[]
[{"$nulls":9},"Parameter","Estimate"]
["trt","n","mean(y)","sd(y)","mean(x)","sd(x)",null,null,null,"b0",3.255363607382952]
[1,46,7.5,5.53,12.43,6.03,null,null,null,"b1",0.7230238576324147]
[2,43,8.79,5.19,13.09,5.9,null,null,null,"g1",-4.7425501577538665]
[3,41,10.98,5.51,13.56,6.36,null,null,null,"g2",-3.929745903791261]
[4,42,13.45,6.47,14.1,6.92,null,null,null,"g3",-2.0795671168784953]
[]
[]
[]
[]
["ANOVA"]
["Source","df","SS"]
["X",1,3790.898782613339]
["Trt|X",3,588.7889345577486]
["Error",167,1946.3133822475065]
["Total",171,6326.001099418594]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}