{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["partA","partB","partC","partCplus"],"not_rendered":{"charts":6,"images":0,"macros":0,"external_links":1,"defined_names":71,"comments":8,"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":"partA","index":0,"n_rows":59,"n_cols":47,"rows_kept":59,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["THE LINEAR MODEL",{"$nulls":9},"THE MEAN MODEL",{"$nulls":6},"STATISTICS"]
[]
["Minimization",{"$nulls":9},"Minimization"]
["SSE",1132.7889,{"$nulls":8},"SST",13856.319999999998,{"$nulls":5},"Number of observations"]
[{"$nulls":17},"n"]
[]
[null,null,null,"The linear model",{"$nulls":9},"The mean model",null,null,null,"ANOVA"]
["Parameters","Value",null,"i","Observed total length","Observed carapace length","Predicted","(obs-pre)","(obs-pre)2",null,"Parameters","Value",null,"Predicted","(obs-pre)","(obs-pre)2",null,"Source of variation","Acronym","Degrees of freedom (df)","Sums of squares (SS)","Mean sums of square (MS)","F","Significance F"]
["a (intercept)",3,null,1,148,62,60.72,1.2800000000000011,1.638400000000003,null,"mean",62.559999796875005,null,62.559999796875005,-0.5599997968750046,0.3135997725000464,null,"Explained (Regression)","SSR",1,12723.531099999998,12723.531099999998,539.1379565954433,9.48055260099534e-28,null,"SSE",1132.7889,1.5000000000000009,1.6500000000000008,1.8000000000000007,1.9500000000000006,2.1000000000000005,2.2500000000000004,2.4000000000000004,2.5500000000000003,2.7,2.85,3,3.15,3.3,3.4499999999999997,3.5999999999999996,3.7499999999999996,3.8999999999999995,4.05,4.2,4.3500000000000005]
["b (slope)",0.39,null,2,79,37,33.81,3.1899999999999977,10.176099999999986,{"$nulls":4},62.559999796875005,-25.559999796875005,653.3135896162503,null,"Unexplained (Residuals)","SSE",48,1132.7889,23.59976875,{"$nulls":4},0.19499999999999984]
[null,null,null,3,160,63,65.4,-2.4000000000000057,5.760000000000027,{"$nulls":4},62.559999796875005,0.44000020312499544,0.19360017875003724,null,"Total","SST",49,13856.319999999998,{"$nulls":5},0.21449999999999986]
[null,null,null,4,165,78,67.35000000000001,10.649999999999991,113.42249999999981,{"$nulls":4},62.559999796875005,15.440000203124995,238.3936062724999,{"$nulls":10},0.23399999999999987]
[null,null,null,5,186,74,75.54,-1.5400000000000063,2.3716000000000195,{"$nulls":4},62.559999796875005,11.440000203124995,130.87360464749995,null,"Regression statistics",{"$nulls":8},0.2534999999999999]
[null,null,null,6,182,68,73.98,-5.980000000000004,35.76040000000005,{"$nulls":4},62.559999796875005,5.440000203124995,29.593602209999993,null,"n",50,{"$nulls":7},0.2729999999999999]
[null,null,null,7,155,65,63.45,1.5499999999999972,2.402499999999991,{"$nulls":4},62.559999796875005,2.4400002031249954,5.953600991250019,null,"R2",0.918247492840812,{"$nulls":7},0.2924999999999999]
[null,null,null,8,243,94,97.77000000000001,-3.7700000000000102,14.212900000000078,{"$nulls":4},62.559999796875005,31.440000203124995,988.4736127724998,null,"adjusted R2",{"$nulls":8},0.31199999999999994]
[null,null,null,9,173,69,70.47,-1.4699999999999989,2.1608999999999967,{"$nulls":4},62.559999796875005,6.440000203124995,41.473602616249984,null,"Standard Error",4.857959319508552,{"$nulls":7},0.33149999999999996]
[null,null,null,10,132,62,54.480000000000004,7.519999999999996,56.55039999999994,{"$nulls":4},62.559999796875005,-0.5599997968750046,0.3135997725000464,{"$nulls":10},0.351]
[null,null,null,11,117,48,48.63,-0.6300000000000026,0.39690000000000325,{"$nulls":4},62.559999796875005,-14.559999796875005,211.99359408500018,null,"Parameter estimates","coefficient","stderr","t-stat","p-value","lower 95","upper 95",null,null,0.3705]
[null,null,null,12,185,67,75.15,-8.150000000000006,66.4225000000001,{"$nulls":4},62.559999796875005,4.440000203124995,19.713601803750002,null,"Intercept",3,{"$nulls":7},0.39]
[null,null,null,13,158,66,64.62,1.3799999999999955,1.9043999999999874,{"$nulls":4},62.559999796875005,3.4400002031249954,11.83360139750001,null,"Slope",0.39,{"$nulls":7},0.40950000000000003]
[null,null,null,14,144,55,59.160000000000004,-4.160000000000004,17.30560000000003,{"$nulls":4},62.559999796875005,-7.559999796875005,57.15359692875011,{"$nulls":10},0.42900000000000005]
[null,null,null,15,184,72,74.76,-2.760000000000005,7.617600000000028,{"$nulls":4},62.559999796875005,9.440000203124995,89.11360383499995,{"$nulls":10},0.44850000000000007]
[null,null,null,16,230,80,92.7,-12.700000000000003,161.29000000000008,{"$nulls":4},62.559999796875005,17.440000203124995,304.15360708499986,{"$nulls":10},0.4680000000000001]
[null,null,null,17,138,50,56.82,-6.82,46.51240000000001,{"$nulls":4},62.559999796875005,-12.559999796875005,157.75359489750016,{"$nulls":10},0.4875000000000001]
[null,null,null,18,210,86,84.9,1.0999999999999943,1.2099999999999875,{"$nulls":4},62.559999796875005,23.440000203124995,549.4336095224999,{"$nulls":10},0.5070000000000001]
[null,null,null,19,138,53,56.82,-3.8200000000000003,14.592400000000001,{"$nulls":4},62.559999796875005,-9.559999796875005,91.39359611625012,{"$nulls":10},0.5265000000000001]
[null,null,null,20,148,64,60.72,3.280000000000001,10.758400000000007,{"$nulls":4},62.559999796875005,1.4400002031249954,2.0736005850000283,{"$nulls":10},0.546]
[null,null,null,21,184,81,74.76,6.239999999999995,38.93759999999994,{"$nulls":4},62.559999796875005,18.440000203124995,340.0336074912499,null,"EXCEL REGRESSION ANALYSIS output",{"$nulls":8},0.5655]
[null,null,null,22,62,22,27.18,-5.18,26.832399999999996,{"$nulls":4},62.559999796875005,-40.559999796875005,1645.1135835225004,null,"SUMMARY OUTPUT",{"$nulls":8},0.585]
[null,null,null,23,133,54,54.870000000000005,-0.8700000000000045,0.7569000000000079,{"$nulls":4},62.559999796875005,-8.559999796875005,73.27359652250011]
[null,null,null,24,150,53,61.5,-8.5,72.25,{"$nulls":4},62.559999796875005,-9.559999796875005,91.39359611625012,null,"Regression Statistics"]
[null,null,null,25,95,35,40.050000000000004,-5.050000000000004,25.502500000000044,{"$nulls":4},62.559999796875005,-27.559999796875005,759.5535888037502,null,"Multiple R",0.9593567462570523]
[null,null,null,26,79,30,33.81,-3.8100000000000023,14.516100000000018,{"$nulls":4},62.559999796875005,-32.559999796875005,1060.1535867725004,null,"R Square",0.9203653665889182]
[null,null,null,27,174,69,70.86,-1.8599999999999994,3.459599999999998,{"$nulls":4},62.559999796875005,6.440000203124995,41.473602616249984,null,"Adjusted R Square",0.9187063117261873]
[null,null,null,28,188,79,76.32000000000001,2.6799999999999926,7.18239999999996,{"$nulls":4},62.559999796875005,16.440000203124995,270.2736066787499,null,"Standard Error",4.794621473646801]
[null,null,null,29,102,36,42.78,-6.780000000000001,45.96840000000002,{"$nulls":4},62.559999796875005,-26.559999796875005,705.4335892100003,null,"Observations",50]
[null,null,null,30,121,58,50.190000000000005,7.809999999999995,60.99609999999993,{"$nulls":4},62.559999796875005,-4.559999796875005,20.793598147500084]
[null,null,null,31,177,75,72.03,2.969999999999999,8.820899999999993,{"$nulls":4},62.559999796875005,12.440000203124995,154.75360505374994,null,"ANOVA"]
[null,null,null,32,154,63,63.06,-0.060000000000002274,0.0036000000000002727,{"$nulls":4},62.559999796875005,0.44000020312499544,0.19360017875003724,null,null,"df","SS","MS","F","Significance F"]
[null,null,null,33,205,79,82.95,-3.950000000000003,15.602500000000022,{"$nulls":4},62.559999796875005,16.440000203124995,270.2736066787499,null,"Regression",1,12752.877036373362,12752.877036373362,554.7528217806855,5.044018801240903e-28]
[null,null,null,34,104,43,43.56,-0.5600000000000023,0.31360000000000254,{"$nulls":4},62.559999796875005,-19.559999796875005,382.5935920537502,null,"Residual",48,1103.442963626641,22.98839507555502]
[null,null,null,35,126,56,52.14,3.8599999999999994,14.899599999999996,{"$nulls":4},62.559999796875005,-6.559999796875005,43.0335973350001,null,"Total",49,13856.32]
[null,null,null,36,167,68,68.13,-0.12999999999999545,0.01689999999999882,{"$nulls":4},62.559999796875005,5.440000203124995,29.593602209999993]
[null,null,null,37,176,76,71.64,4.359999999999999,19.009599999999995,{"$nulls":4},62.559999796875005,13.440000203124995,180.63360545999993,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%"]
[null,null,null,38,264,107,105.96000000000001,1.039999999999992,1.0815999999999835,{"$nulls":4},62.559999796875005,44.440000203124995,1974.9136180537496,null,"Intercept",3.3508212971644866,2.603691092990134,1.2869504013689783,0.20428340605324957,-1.8842504195716545,8.585893013900627]
[null,null,null,39,220,86,88.8,-2.799999999999997,7.839999999999984,{"$nulls":4},62.559999796875005,23.440000203124995,549.4336095224999,null,"X Variable 1",0.3831317374326098,0.01626665924293691,23.553191329004335,5.044018801241036e-28,0.35042542754901784,0.4158380473162018]
[null,null,null,40,138,59,56.82,2.1799999999999997,4.752399999999999,{"$nulls":4},62.559999796875005,-3.5599997968750046,12.673598553750073]
[null,null,null,41,137,56,56.43,-0.4299999999999997,0.18489999999999976,{"$nulls":4},62.559999796875005,-6.559999796875005,43.0335973350001]
[null,null,null,42,131,47,54.09,-7.090000000000003,50.26810000000005,{"$nulls":4},62.559999796875005,-15.559999796875005,242.1135936787502]
[null,null,null,43,128,57,52.92,4.079999999999998,16.646399999999986,{"$nulls":4},62.559999796875005,-5.559999796875005,30.913597741250094]
[null,null,null,44,141,56,57.99,-1.990000000000002,3.9601000000000077,{"$nulls":4},62.559999796875005,-6.559999796875005,43.0335973350001]
[null,null,null,45,103,46,43.17,2.8299999999999983,8.00889999999999,{"$nulls":4},62.559999796875005,-16.559999796875005,274.2335932725002]
[null,null,null,46,203,87,82.17,4.829999999999998,23.328899999999983,{"$nulls":4},62.559999796875005,24.440000203124995,597.3136099287498]
[null,null,null,47,127,59,52.53,6.469999999999999,41.86089999999999,{"$nulls":4},62.559999796875005,-3.5599997968750046,12.673598553750073]
[null,null,null,48,154,60,63.06,-3.0600000000000023,9.363600000000014,{"$nulls":4},62.559999796875005,-2.5599997968750046,6.553598960000064]
[null,null,null,49,188,73,76.32000000000001,-3.3200000000000074,11.022400000000049,{"$nulls":4},62.559999796875005,10.440000203124995,108.99360424124994]
[null,null,null,50,121,45,50.190000000000005,-5.190000000000005,26.93610000000005,{"$nulls":4},62.559999796875005,-17.559999796875005,308.3535928662502]

{"sheet":"partB","index":1,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,null,"n",50,{"$nulls":18},"mean",60]
[{"$nulls":23},"stdev",30]
[{"$nulls":24},"alpha",1e-05]
["SSE",4.321971021771931,null,"Average",57.94,3.3026650123322643,{"$nulls":18},"beta",3]
[{"$nulls":4},27.699856332052097,{"$nulls":19},"mean",0]
[{"$nulls":24},"stdve",0.3]
[null,null,null,"The linear model",{"$nulls":6},"The mean model"]
[null,null,null,"i","Observed length","Observed weight","Predicted","(obs-pre)","(obs-pre)^2",null,"Predicted","(obs-pre)","(obs-pre)^2",null,null,"Source of variation","Acronym","Degrees of freedom (df)","Sums of squares (SS)","Mean sums of square (MS)","F","Significance F",null,null,"Observed length (simulated)","Obsverved weight (simulated)",null,"Observed length (simulated)","Obsverved weight (simulated)"]
[null,null,null,1,95,8.825208106437044,8.685626977810681,0.01594259603778525,0.000254166368424006,null,3.3026650123322643,5.52254309410478,30.498482226244395,null,null,"Explained (Regression)","SSR",1,509.76566013350504,509.76566013350504,5661.479811675482,1.7876810238807097e-51,null,null,95,11.120263761309758,null,75,4.168340617696414]
["TSS",514.087631155277,null,2,67,2.3450969482312716,3.0711441788270846,-0.26972344527830316,0.07275073693279781,null,3.3026650123322643,-0.9575680641009927,0.9169365973861229,null,null,"Unexplained (Residuals)","SSE",48,4.321971021771931,0.0900410629535819,{"$nulls":4},67,1.9955269234322612,null,113,18.27323862494155]
["R2",0.9915929293765356,null,3,39,0.6402279348693617,0.6132097012626676,0.04311729359347993,0.0018591010068263456,null,3.3026650123322643,-2.6624370774629025,7.088571191449201,null,null,"Total","SST",49,514.087631155277,{"$nulls":5},39,0.40544011446697437,null,29,0.2463084678317312]
[null,null,null,4,25,0.1819273520764243,0.16316348980384024,0.10885473990927697,0.011849354400716335,null,3.3026650123322643,-3.12073766025584,9.739003544139093,{"$nulls":4},"R2",0.9915929293765356,{"$nulls":5},25,0.1541141735234891,null,41,0.6734936632381769]
["Parameters","Value",null,5,9,0.008837997798876947,0.007791323423963286,0.12604962465952152,0.015888507876806256,null,3.3026650123322643,-3.293827014533387,10.849296401669926,{"$nulls":4},"Standard error",null,0.30006843045142534,{"$nulls":4},9,0.005474725016546544,null,85,5.2701408412903135]
["a",1.1234764150957691e-05,null,6,73,3.2623571020779125,3.96458841043068,-0.19495207244630874,0.03800631055111081,null,3.3026650123322643,-0.040307910254351764,0.0016247276290728761,null,null,"SUMMARY OUTPUT",{"$nulls":8},73,4.4144930808006215,null,5,0.0008578517099079813]
["b",2.977280140768292,null,7,45,1.1784367473730033,0.9389462797299493,0.22718578130084094,0.05161337922527353,null,3.3026650123322643,-2.124228264959261,4.512345721651833,{"$nulls":11},45,0.7589857168175927,null,73,3.6694629966762773]
[null,null,null,8,5,0.0009823068547554089,0.0013539214622692612,-0.32085670863018034,0.10294902747299245,null,3.3026650123322643,-3.301682705477509,10.901108687649282,null,null,"Regression Statistics",{"$nulls":8},5,0.001697098393708022,null,55,1.3674694143758162]
[null,null,null,9,39,0.6338934818547033,0.6132097012626676,0.03317396304123216,0.001100511823861037,null,3.3026650123322643,-2.668771530477561,7.122341481887544,null,null,"Multiple R",0.9593567462570523,{"$nulls":7},39,0.8687371890263001,null,74,5.6668883584157586]
[null,null,null,10,100,7.576788225522657,10.118688845093924,-0.2892947017927585,0.08369142448536107,null,3.3026650123322643,4.274123213190393,18.268129241532968,null,null,"R Square",0.9203653665889182,{"$nulls":7},100,14.534152257292035,null,75,3.19186319899435]
[null,null,null,11,57,0.9711988671423984,1.8979960194193035,-0.6700226280644188,0.4489303221183505,null,3.3026650123322643,-2.3314661451898657,5.435734386166492,null,null,"Adjusted R Square",0.9187063117261873,{"$nulls":7},57,2.8171142641295823,null,76,5.532203190255581]
[null,null,null,12,6,0.00159838937414854,0.002329905057403557,-0.37683103776683424,0.14200163102442925,null,3.3026650123322643,-3.301066622958116,10.8970408492081,null,null,"Standard Error",4.794621473646801,{"$nulls":7},6,0.0020449951382444957,null,106,9.977536212494481]
[null,null,null,13,50,1.6069011417825196,1.2849126757117453,0.22361680822167712,0.05000447691925033,null,3.3026650123322643,-1.6957638705497446,2.875615104661851,null,null,"Observations",50,{"$nulls":7},50,2.133021307757851,null,102,12.84910863291663]
[null,null,null,14,59,1.6851407997949932,2.1032286366292547,-0.22162448906064625,0.04911741415139251,null,3.3026650123322643,-1.617524212537271,2.6163845781443187,{"$nulls":11},59,1.816129327634617,null,31,0.27792785029015943]
[null,null,null,15,69,3.5650742959468555,3.3522225215893653,0.061561328888068534,0.0037897972144649416,null,3.3026650123322643,0.26240928361459126,0.068858632127123,null,null,"ANOVA",{"$nulls":8},69,4.480367985389481,null,22,0.07166806883351466]
[null,null,null,16,84,6.649936746844351,6.0211918272988205,0.09932212518750183,0.009864884551761786,null,3.3026650123322643,3.347271734512087,11.204228064663555,null,null,null,"df","SS","MS","F","Significance F",null,null,null,84,7.4227145175887355,null,69,2.580233632859831]
[null,null,null,17,66,2.2584043485941314,2.9366756644349454,-0.2626196917393555,0.06896910248927411,null,3.3026650123322643,-1.0442606637381329,1.0904803338308058,null,null,"Regression",1,12752.877036373362,12752.877036373362,554.7528217806855,5.044018801240903e-28,null,null,null,66,2.0428623360993234,null,41,0.719134646522198]
[null,null,null,18,52,2.2047229268008404,1.4440646483175728,0.4231400344521679,0.17904748875618184,null,3.3026650123322643,-1.097942085531424,1.2054768231810926,null,null,"Residual",48,1103.442963626641,22.98839507555502,{"$nulls":5},52,1.219510979868562,null,47,1.2358946355636504]
[null,null,null,19,39,0.5638232433428277,0.6132097012626676,-0.08396616353766706,0.007050316619234249,null,3.3026650123322643,-2.7388417689894364,7.501254235561185,null,null,"Total",49,13856.32,{"$nulls":6},39,0.673790058900322,null,93,7.647767726015989]
[null,null,null,20,58,1.9442127078543587,1.9988633482465041,-0.02772157545170051,0.0007684857455243243,null,3.3026650123322643,-1.3584523044779055,1.8453926635413322,{"$nulls":11},58,2.060688073023108,null,28,0.194695079043628]
[null,null,null,21,40,0.9763247415484122,0.6612190484945346,0.38971008356076603,0.15187394922893924,null,3.3026650123322643,-2.3263402707838523,5.411859055470687,null,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%",null,null,40,0.8685293963704753,null,25,0.12572465644355563]
[null,null,null,22,79,6.396282938328711,5.0156983922011324,0.24314435837884307,0.05911917901145928,null,3.3026650123322643,3.0936179259964467,9.570471872046557,null,null,"Intercept",3.3508212971644866,2.603691092990134,1.2869504013689783,0.20428340605324957,-1.8842504195716545,8.585893013900627,null,null,79,5.777922564363948,null,75,6.387473131390313]
[null,null,null,23,111,8.371048898144066,13.805859394033439,-0.5003139027841352,0.25031400131909315,null,3.3026650123322643,5.0683838858118015,25.688515213956737,null,null,"X Variable 1",0.3831317374326098,0.01626665924293691,23.553191329004335,5.044018801241036e-28,0.35042542754901784,0.4158380473162018,null,null,111,10.838298694584841,null,84,4.508245050860634]
[null,null,null,24,78,5.305560236134351,4.829027124689923,0.0941103478770553,0.008856757577540368,null,3.3026650123322643,2.0028952238020867,4.011589277529211,{"$nulls":11},78,3.887526648323241,null,66,3.4475345525741115]
[null,null,null,25,91,11.588609114262413,7.64150659206723,0.41642786110061314,0.17341216350083155,null,3.3026650123322643,8.285944101930149,68.65686966031102,{"$nulls":11},91,3.934772348925319,null,31,0.18846983569545017]
[null,null,null,26,102,8.263331703612119,10.733203458701597,-0.26151420353232746,0.06838967864914759,null,3.3026650123322643,4.9606666912798545,24.60821402197342,{"$nulls":11},102,10.938521064589526,null,114,11.214849580306057]
[null,null,null,27,64,2.335636847895898,2.67958616610642,-0.1373777730351995,0.018872652524110783,null,3.3026650123322643,-0.9670281644363663,0.935143470813168,{"$nulls":11},64,3.5025539978455127,null,38,0.4679866163532717]
[null,null,null,28,71,3.9664348491992363,3.6498807632982957,0.08317316889197146,0.006917776023532409,null,3.3026650123322643,0.663769836866972,0.4405903963344066,{"$nulls":11},71,5.866208914388499,null,19,0.04681349790417845]
[null,null,null,29,80,5.830990633197421,5.207100791078361,0.11316367502277402,0.01280601734466001,null,3.3026650123322643,2.5283256208651563,6.392430445123178,{"$nulls":11},80,5.863394584368217,null,108,11.312023336380397]
[null,null,null,30,5,0.0020687591454022496,0.0013539214622692612,0.42394381229639055,0.17972835598439724,null,3.3026650123322643,-3.3005962531868622,10.893935626551153,{"$nulls":11},5,0.0005984879828770386,null,99,14.180526563789028]
[null,null,null,31,53,1.869117264847459,1.5283269225003107,0.20129264615645437,0.04051872939666754,null,3.3026650123322643,-1.4335477474848053,2.055059144318759,{"$nulls":11},53,1.327638724817756,null,63,3.042324039671723]
[null,null,null,32,51,1.5536802288743872,1.3629462656879316,0.13097772946877595,0.01715516561679586,null,3.3026650123322643,-1.7489847834578771,3.058947772767197,{"$nulls":11},51,1.8082849980865168,null,48,1.2759615139168579]
[null,null,null,33,64,2.338689537744233,2.67958616610642,-0.1360716210764007,0.018515486062359574,null,3.3026650123322643,-0.9639754745880311,0.9292487156072199,{"$nulls":11},64,4.3280322128109106,null,51,0.93758090952354]
[null,null,null,34,52,2.4025676912818943,1.4440646483175728,0.509076227045355,0.2591586049427339,null,3.3026650123322643,-0.90009732105037,0.8101751873620529,{"$nulls":11},52,1.2242403961321808,null,54,1.5507830564589673]
[null,null,null,35,62,2.67753560087732,2.4379014261466954,0.0937592215838271,0.00879079163200519,null,3.3026650123322643,-0.6251294114549442,0.3907867810660049,{"$nulls":11},62,1.2061172685081412,null,79,5.2178341009198]
[null,null,null,36,73,2.9160050512898255,3.96458841043068,-0.3071874975948361,0.09436415867857743,null,3.3026650123322643,-0.3866599610424388,0.14950592547334032,{"$nulls":11},73,2.1571740147388248,null,60,3.213798393261678]
[null,null,null,37,38,0.542640568245229,0.5675737334912728,-0.0449235039489857,0.0020181212070545336,null,3.3026650123322643,-2.760024444087035,7.617734931957948,{"$nulls":11},38,0.46503841170183186,null,74,5.600059164586609]
[null,null,null,38,88,6.9760893114486295,6.9156595237369025,0.008700152817687323,7.569265905111267e-05,null,3.3026650123322643,3.6734242991163653,13.49404608133856,{"$nulls":11},88,4.739363510557993,null,122,10.987052359664759]
[null,null,null,39,82,7.061533624105752,5.604333041325935,0.23112219920036248,0.05341747096321203,null,3.3026650123322643,3.7588686117734875,14.129093240575946,{"$nulls":11},82,6.071117347650466,null,5,0.0012747233110948725]
[null,null,null,40,30,0.17621473989292452,0.28078101328005817,-0.4658716890084176,0.21703643061955574,null,3.3026650123322643,-3.1264502724393397,9.774691306036022,{"$nulls":11},30,0.2507944778078067,null,52,1.5212750001795066]
[null,null,null,41,55,2.4297331128303337,1.7065194125262764,0.3533255562717752,0.12483894871475938,null,3.3026650123322643,-0.8729318995019306,0.7620101011680487,{"$nulls":11},55,1.9761042916093936,null,75,3.5655991581027324]
[null,null,null,42,38,0.4582271086173739,0.5675737334912728,-0.21400573621793817,0.04579845513418173,null,3.3026650123322643,-2.8444379037148906,8.090826988089962,{"$nulls":11},38,0.6587730512665374,null,88,4.79957304706199]
[null,null,null,43,89,5.000185655622952,7.152273497466976,-0.35795523496799264,0.12813195024099083,null,3.3026650123322643,1.6975206432906873,2.8815763343980287,{"$nulls":11},89,9.226067592966869,null,74,2.7760211205401664]
[null,null,null,44,18,0.04658959331022604,0.061356681203962656,-0.2753268716384505,0.07580488624621579,null,3.3026650123322643,-3.2560754190220385,10.602027134359544,{"$nulls":11},18,0.05441006255513729,null,107,7.912194035974566]
[null,null,null,45,90,7.151964684827584,7.394203066432562,-0.03330922375969991,0.0011095043874737572,null,3.3026650123322643,3.84929967249532,14.817107968672579,{"$nulls":11},90,10.38663154043662,null,19,0.08274018105504255]
[null,null,null,46,84,7.1987499546869405,6.0211918272988205,0.1786221758618769,0.031905881709631274,null,3.3026650123322643,3.896084942354676,15.17947787804284,{"$nulls":11},84,4.041902883374144,null,88,5.693007943926035]
[null,null,null,47,5,0.0016550773374164073,0.0013539214622692612,0.20084256871865414,0.04033773740950731,null,3.3026650123322643,-3.301009934994848,10.89666659093469,{"$nulls":11},5,0.0014105970896999631,null,95,5.034702513309824]
[null,null,null,48,21,0.1291621026000669,0.09709149933953934,0.2854143987487321,0.08146137901310024,null,3.3026650123322643,-3.173502909732197,10.071120718078722,{"$nulls":11},21,0.0765990432450233,null,55,2.176950738474717]
[null,null,null,49,66,2.4627293494130265,2.9366756644349454,-0.17600798866992406,0.030978812075632117,null,3.3026650123322643,-0.8399356629192378,0.7054919178435795,{"$nulls":11},66,1.5868755443623974,null,38,0.3204853649776083]
[null,null,null,50,80,12.599121966718217,5.207100791078361,0.8836038955123957,0.7807558441646807,null,3.3026650123322643,9.296456954385953,86.42411190475094,{"$nulls":11},80,7.104216030573469,null,68,3.9673228113679704]

{"sheet":"partC","index":2,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Parameters"]
["Mean",17.280845320282705,null,null,"Sums of squares",null,null,null,"Maximum likelihood"]
["stdev",3.0771909405642983,null,null,"SS",47.19417561092844,null,null,"ML",769.4999776731822]
["CV",0.17919074431528764,null,null,"penalty",0.0007023358955389198,null,null,"penalty",0.0007023358955389198]
["Numbers",303.60431754798674,null,null,"Sum",47.19487794682398,null,null,"Sum",769.5006800090778]
[]
[null,"Cohort1",null,"Expected","Observed"]
["Sum",302.973498379379,null,302.973498379379,303]
[]
["Length","Cohort1",null,"Expected","Observed","obs-pre","(obs-pre)2",null,"PL","LL"]
[9,1.0532916965864425,null,1.0532916965864425,1,-0.053291696586442505,0.0028400049250614477,null,0.0034765142899314777,-5.661725127997442]
[10,2.3955885013501197,null,2.3955885013501197,1,-1.3955885013501197,1.947667265100673,null,0.00790692424969262,-4.840016416096994]
[11,4.902430102696117,null,4.902430102696117,7,2.0975698973038828,4.399799474075421,null,0.016181052563737326,-28.867400212592532]
[12,9.027057983435228,null,9.027057983435228,9,-0.027057983435227584,0.0007321344675810503,null,0.02979487655429082,-31.620769451643625]
[13,14.95604230685346,null,14.95604230685346,18,3.04395769314654,9.265678437666006,null,0.04936419319463289,-54.15353913103667]
[14,22.295785068350416,null,22.295785068350416,22,-0.2957850683504155,0.08748880665905998,null,0.07358988554316377,-57.403449122276804]
[15,29.90642387604697,null,29.90642387604697,26,-3.9064238760469685,15.260147499349822,null,0.09870970245258409,-60.204872907823244]
[16,36.094566561358555,null,36.094566561358555,35,-1.0945665613585547,1.1980759572442907,null,0.11913440203328102,-74.46260480205544]
[17,39.19717868673023,null,39.19717868673023,42,2.8028213132697672,7.855807314119263,null,0.1293749416909333,-85.89170375774961]
[18,38.30040952639607,null,38.30040952639607,39,0.6995904736039265,0.4894268307573661,null,0.12641504861404365,-80.65920520573776]
[19,33.673453387748154,null,33.673453387748154,33,-0.6734533877481539,0.45353946546946533,null,0.1111432305725392,-72.49887295059875]
[20,26.638362782002844,null,26.638362782002844,26,-0.6383627820028437,0.40750704144641015,null,0.0879230788319534,-63.21361672439079]
[21,18.9610783039885,null,18.9610783039885,20,1.0389216960114993,1.0793582904434103,null,0.06258328997556649,-55.42513939613556]
[22,12.143787680688304,null,12.143787680688304,12,-0.1437876806883036,0.02067489711772156,null,0.040082012933956454,-38.6019312067626]
[23,6.998112671756633,null,6.998112671756633,6,-0.9981126717566333,0.9962289055211648,null,0.023098101679486494,-22.60802905925055]
[24,3.628635345981488,null,3.628635345981488,2,-1.628635345981488,2.652453090180241,null,0.01197674174603141,-8.8495773954828]
[25,1.6929391720704245,null,1.6929391720704245,2,0.30706082792957545,0.09428635204879635,null,0.005587746720838767,-10.374358328324956]
[26,0.7106815037524845,null,0.7106815037524845,1,0.2893184962475155,0.08370519227092363,null,0.0023456886742700494,-6.055176242471657]
[27,0.26843819034813715,null,0.26843819034813715,0,-0.26843819034813715,0.07205906203738272,null,0.0008860121158584067,0]
[28,0.09123242597116321,null,0.09123242597116321,1,0.9087675740288368,0.8258585036062573,null,0.000301123452906509,-8.10799023475432,null,null,null,17.29982148752653,32.53412833821366]
[29,0.027899073149961894,null,0.027899073149961894,0,-0.027899073149961894,0.0007783582826269246,null,9.20842030712108e-05,0,null,null,null,3.097204809134774,5.842716635549211]
[30,0.007676547808359385,null,0.007676547808359385,0,-0.007676547808359385,5.892938625402728e-05,null,2.53373573907343e-05,0]
[31,0.0019005433219837803,null,0.0019005433219837803,0,-0.0019005433219837803,3.6120649187371432e-06,null,6.272968864108199e-06,0,null,null,null,306.20473827151585,216.1331564144887]
[32,0.0004233750095001845,null,0.0004233750095001845,0,-0.0004233750095001845,1.7924639866928134e-07,null,1.3973994813567505e-06,0]
[33,8.486102955127501e-05,null,8.486102955127501e-05,0,-8.486102955127501e-05,7.201394336502371e-09,null,2.800939026192095e-07,0]
[34,1.530477695022622e-05,null,1.530477695022622e-05,0,-1.530477695022622e-05,2.3423619749617577e-10,null,5.0515233286384014e-08,0]
[35,2.483598243664593e-06,null,2.483598243664593e-06,0,-2.483598243664593e-06,6.1682602359338506e-12,null,8.197410852597633e-09,0,null,null,null,10,5,0.5]
[36,3.626363331821747e-07,null,3.626363331821747e-07,0,-3.626363331821747e-07,1.3150511014381323e-13,null,1.1969242693566775e-09,0,null,null,null,20,10,0.5]
[37,4.764276041596889e-08,null,4.764276041596889e-08,0,-4.764276041596889e-08,2.269832620053412e-15,null,1.5725058683618366e-10,0]
[38,5.631941687850268e-09,null,5.631941687850268e-09,0,-5.631941687850268e-09,3.1718767175345725e-17,null,1.8588892157155053e-11,0]
[39,5.990388842056767e-10,null,5.990388842056767e-10,0,-5.990388842056767e-10,3.588475847903821e-19,null,1.977198954396892e-12,0]
[40,5.733073494934685e-11,null,5.733073494934685e-11,0,-5.733073494934685e-11,3.28681316983226e-21,null,1.8922689692666826e-13,0]
[41,4.936914840249097e-12,null,4.936914840249097e-12,0,-4.936914840249097e-12,2.4373128139871767e-23,null,1.6294873534011756e-14,0]
[42,3.8252462118268185e-13,null,3.8252462118268185e-13,0,-3.8252462118268185e-13,1.4632508581095424e-25,null,1.2625679250126692e-15,0]
[43,2.666851190083476e-14,null,2.666851190083476e-14,0,-2.666851190083476e-14,7.112095270049653e-28,null,8.802258957792024e-17,0]
[44,1.672914721991322e-15,null,1.672914721991322e-15,0,-1.672914721991322e-15,2.7986436670553017e-30,null,5.521653646077395e-18,0]
[45,9.442444797404741e-17,null,9.442444797404741e-17,0,-9.442444797404741e-17,8.915976375203586e-33,null,3.1165910047950957e-19,0]
[46,4.795465127922464e-18,null,4.795465127922464e-18,0,-4.795465127922464e-18,2.299648579312041e-35,null,1.5828001965761546e-20,0]
[47,2.1913545560321106e-19,null,2.1913545560321106e-19,0,-2.1913545560321106e-19,4.802034790242688e-38,null,7.232825866796205e-22,0]
[48,9.01011213808639e-21,null,9.01011213808639e-21,0,-9.01011213808639e-21,8.118212074089171e-41,null,2.973894477992943e-23,0]

{"sheet":"partCplus","index":3,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Parameters"]
["Mean",17.301941105354146,32.544279004214246,null,"Sums of squares",null,null,null,"Maximum likelihood"]
["stdev",3.10034770476768,5.831633577969539,null,"SS",111.23245808817744,null,null,"ML",1755.1331874158552]
["CV",0.17919074431528764,null,null,"penalty",1.608294561195216e-08,null,null,"penalty",1.608294561195216e-08]
["Numbers",306.40297576427645,215.93230674549855,null,"Sum",111.23245810426039,null,null,"Sum",1755.1331874319383]
[]
[null,"Cohort1","Cohort2","Expected","Observed"]
["Sum",305.7360251794915,215.26384800195467,520.9998731814461,521]
[]
["Length","Cohort1","Cohort2","Expected","Observed","obs-pre","(obs-pre)2",null,"PL","LL"]
[9,1.0933963170657102,0.004264962110825813,1.0976612791765359,1,-0.09766127917653589,0.009537725450397282,null,0.002106835981501782,-6.162567991755018]
[10,2.4619732538985284,0.008398455023008781,2.470371708921537,1,-1.4703717089215371,2.1619929623968415,null,0.004741597524460803,-5.351381169580202]
[11,4.995825459043359,0.01605880568686373,5.011884264730223,7,1.9881157352697771,3.9526041768272866,null,0.009619741813228347,-32.50756497244504]
[12,9.135858944505392,0.02981650287616443,9.165675447381556,9,-0.16567544738155604,0.027448353865078743,null,0.017592471551695504,-36.36255799075417]
[13,15.056003832735485,0.05375635147450558,15.109760184209991,18,2.890239815790009,8.353486192777865,null,0.029001466146130497,-63.72736008318886]
[14,22.36084700480488,0.09410928722398128,22.454956292028864,22,-0.45495629202886434,0.20698522765665328,null,0.043099734660028574,-69.17324564196713]
[15,29.928502428947464,0.1599796721308335,30.0884821010783,26,-4.088482101078299,16.71568589083762,null,0.057751419241899755,-74.14179121088735]
[16,36.099395069054225,0.264074666283595,36.36346973533782,35,-1.363469735337823,1.8590497191821929,null,0.06979554431229908,-93.17647872115461]
[17,39.24036740871574,0.42327078716373434,39.66363819587948,42,2.3363618041205214,5.458586479753298,null,0.07612984232352397,-108.16322768218303]
[18,38.44009109180674,0.6587785819306543,39.0988696737374,39,-0.09886967373739708,0.009775212384939346,null,0.07504583337992603,-100.99659337428236]
[19,33.93547665711839,0.995612327192391,34.93108898431078,33,-1.931088984310783,3.7291046653264517,null,0.06704625237431776,-89.17829460596109]
[20,26.998628408850653,1.461068838672431,28.459697247523085,30,1.540302752476915,2.372532569287961,null,0.0546251519673817,-87.21782530676064]
[21,19.35742796988301,2.0819999292871434,21.439427899170152,25,3.560572100829848,12.677673685207878,null,0.04115054341232737,-79.76295365750966]
[22,12.507537240057983,2.8808481125118948,15.388385352569879,13,-2.3883853525698786,5.704384592370343,null,0.029536255467015517,-45.78777802762021]
[23,7.283064560481077,3.870701061186382,11.153765621667459,12,0.8462343783325412,0.7161126230718625,null,0.02140838452331636,-46.127671602396]
[24,3.821859499180925,5.049966772173032,8.871826271353957,7,-1.8718262713539566,3.503733590130856,null,0.01702846147961385,-28.51008391112792]
[25,1.8073966676879538,6.397599197579755,8.204995865267708,8,-0.2049958652677084,0.04202330477685646,null,0.01574855635792102,-33.208052621808406]
[26,0.7702832241985115,7.870007667782787,8.640290891981298,8,-0.640290891981298,0.40997242635420617,null,0.016584055652873807,-32.79450838429606]
[27,0.2958459336289025,9.400758616187698,9.6966045498166,11,1.3033954501834,1.6988396995587878,null,0.018611529577934487,-43.82371422573622]
[28,0.10239976771298476,10.90385998941352,11.006259757126506,10,-1.0062597571265055,1.0125586988122939,null,0.021125263793093877,-38.57285618569817,null,null,null,17.29982148752653,32.53412833821366]
[29,0.03194114946530223,12.280816726423911,12.312757875889213,13,0.6872421241107869,0.4723017371523062,null,0.023632938335862337,-48.6864800217389,null,null,null,3.097204809134774,5.842716635549211]
[30,0.008978841661070757,13.4308609551669,13.43983979682797,15,1.56016020317203,2.43409985956179,null,0.025796243893033238,-54.86289574791775]
[31,0.002274617035108841,14.262973484858897,14.265248101894006,17,2.734751898105994,7.478867944194338,null,0.02738052125576222,-61.16469816505627,null,null,null,306.20473827151585,216.1331564144887]
[32,0.0005192953863124124,14.70773904234354,14.708258337729852,12,-2.708258337729852,7.33466322388326,null,0.028230829017126226,-42.80808804742179]
[33,0.00010684122117641151,14.726901273105101,14.727008114326278,14,-0.7270081143262779,0.5285407982962503,null,0.028266817080773787,-49.924933850578604]
[34,1.9809860846309505e-05,14.318794429926161,14.318814239787008,16,1.6811857602129923,2.8263855603429366,null,0.02748333536503619,-57.506807115515755]
[35,3.31010834270362e-06,13.5185823772068,13.518585687315142,12,-1.5185856873151415,2.306102489718401,null,0.02594738767356108,-43.82021210547694,null,null,null,10,5,0.5]
[36,4.984495350464995e-07,12.393257362095431,12.393257860544967,11,-1.393257860544967,1.9411674659703388,null,0.02378744890064268,-41.12456913974455,null,null,null,20,10,0.5]
[37,6.764230276992532e-08,11.032384872991825,11.032384940634127,13,1.9676150593658726,3.8715090218433663,null,0.021175408111456358,-50.11389194969873]
[38,8.272442843822576e-09,9.536367055182708,9.53636706345515,9,-0.5363670634551507,0.28768962675950166,null,0.01830397194767448,-36.005734767284075]
[39,9.117323586717274e-10,8.004351140440512,8.004351141352245,9,0.9956488586477548,0.9913166497265767,null,0.015363441630943754,-37.581880606620736]
[40,9.055640326407293e-11,6.5237742598265,6.523774259917056,4,-2.5237742599170563,6.369436515019885,null,0.012521642702291126,-17.52118686265475]
[41,8.105674564066532e-12,5.1629906243050625,5.162990624313168,5,-0.16299062431316802,0.02656594361399628,null,0.009909773284177132,-23.071169041907687]
[42,6.538488496683816e-13,3.967650112582936,3.96765011258359,5,1.03234988741641,1.0657462900486745,null,0.007615453125459391,-24.387878950385527]
[43,4.753174595016495e-14,2.9607041767086733,2.9607041767087208,2,-0.9607041767087208,0.922952515145581,null,0.005682734927802201,-10.340645321520078]
[44,3.1139266105232174e-15,2.145291365544899,2.145291365544902,3,0.8547086344550978,0.730526849812098,null,0.004117642778768532,-16.477423261294387]
[45,1.838447281963853e-16,1.5094098237799545,1.5094098237799547,2,0.4905901762200453,0.2406787210036151,null,0.00289714048213267,-11.68806213818299]
[46,9.78165162462927e-18,1.0312350809447661,1.0312350809447661,1,-0.031235080944766125,0.0009756302816260919,null,0.0019793384490625833,-6.224992606740151]
[47,4.690200451075427e-19,0.6841286905087427,0.6841286905087427,0,-0.6841286905087427,0.4680320651772071,null,0.0013131072111998087,0]
[48,2.0266969752899333e-20,0.4407045641201704,0.4407045641201704,1,0.5592954358798297,0.31281138459600866,null,0.0008458822867442203,-7.075130349003332]