{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["partA","PartBi","PartBii","partC","partCplus"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":88,"comments":4,"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",{"$nulls":9},"SST",{"$nulls":6},"Number of observations"]
[{"$nulls":17},"n"]
[{"$nulls":26},"=TABLE(B10;B11)"]
[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)",4,null,1,148,62,{"$nulls":4},"mean",{"$nulls":6},"Explained (Regression)","SSR",{"$nulls":6},"SSE",0,1.5,1.65,1.8,1.95,2.1,2.25,2.4,2.55,2.7,2.85,3,3.15,3.3,3.45,3.6,3.75,3.9,4.05,4.2,4.35]
["b (slope)",0.6,null,2,79,37,{"$nulls":11},"Unexplained (Residuals)","SSE",{"$nulls":7},0.195]
[null,null,null,3,160,63,{"$nulls":11},"Total","SST",{"$nulls":7},0.21449999999999986]
[null,null,null,4,165,78,{"$nulls":20},0.23399999999999987]
[null,null,null,5,186,74,{"$nulls":11},"Regression statistics",{"$nulls":8},0.2534999999999999]
[null,null,null,6,182,68,{"$nulls":11},"n",{"$nulls":8},0.2729999999999999]
[null,null,null,7,155,65,{"$nulls":11},"R2",{"$nulls":8},0.2925]
[null,null,null,8,243,94,{"$nulls":11},"adjusted R2",{"$nulls":8},0.31199999999999994]
[null,null,null,9,173,69,{"$nulls":11},"Standard Error",{"$nulls":8},0.33149999999999996]
[null,null,null,10,132,62,{"$nulls":20},0.351]
[null,null,null,11,117,48,{"$nulls":11},"Parameter estimates","coefficient","stderr","t-stat","p-value","lower 95","upper 95",null,null,0.3705]
[null,null,null,12,185,67,{"$nulls":11},"Intercept",{"$nulls":8},0.39]
[null,null,null,13,158,66,{"$nulls":11},"Slope",{"$nulls":8},0.40950000000000003]
[null,null,null,14,144,55,{"$nulls":20},0.42900000000000005]
[null,null,null,15,184,72,{"$nulls":20},0.44850000000000007]
[null,null,null,16,230,80,{"$nulls":20},0.4680000000000001]
[null,null,null,17,138,50,{"$nulls":20},0.4875]
[null,null,null,18,210,86,{"$nulls":20},0.5070000000000001]
[null,null,null,19,138,53,{"$nulls":20},0.5265000000000001]
[null,null,null,20,148,64,{"$nulls":20},0.546]
[null,null,null,21,184,81,{"$nulls":11},"EXCEL REGRESSION ANALYSIS output",{"$nulls":8},0.5655]
[null,null,null,22,62,22,{"$nulls":11},"SUMMARY OUTPUT",{"$nulls":8},0.585]
[null,null,null,23,133,54]
[null,null,null,24,150,53,{"$nulls":11},"Regression Statistics"]
[null,null,null,25,95,35,{"$nulls":11},"Multiple R",0.9593567462570523]
[null,null,null,26,79,30,{"$nulls":11},"R Square",0.9203653665889182]
[null,null,null,27,174,69,{"$nulls":11},"Adjusted R Square",0.9187063117261873]
[null,null,null,28,188,79,{"$nulls":11},"Standard Error",4.794621473646801]
[null,null,null,29,102,36,{"$nulls":11},"Observations",50]
[null,null,null,30,121,58]
[null,null,null,31,177,75,{"$nulls":11},"ANOVA"]
[null,null,null,32,154,63,{"$nulls":12},"df","SS","MS","F","Significance F"]
[null,null,null,33,205,79,{"$nulls":11},"Regression",1,12752.877036373362,12752.877036373362,554.7528217806855,5.044018801240903e-28]
[null,null,null,34,104,43,{"$nulls":11},"Residual",48,1103.442963626641,22.98839507555502]
[null,null,null,35,126,56,{"$nulls":11},"Total",49,13856.32]
[null,null,null,36,167,68]
[null,null,null,37,176,76,{"$nulls":12},"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%"]
[null,null,null,38,264,107,{"$nulls":11},"Intercept",3.3508212971644866,2.603691092990134,1.2869504013689783,0.20428340605324957,-1.8842504195716545,8.585893013900627]
[null,null,null,39,220,86,{"$nulls":11},"X Variable 1",0.3831317374326098,0.01626665924293691,23.553191329004335,5.044018801241036e-28,0.35042542754901784,0.4158380473162018]
[null,null,null,40,138,59]
[null,null,null,41,137,56]
[null,null,null,42,131,47]
[null,null,null,43,128,57]
[null,null,null,44,141,56]
[null,null,null,45,103,46]
[null,null,null,46,203,87]
[null,null,null,47,127,59]
[null,null,null,48,154,60]
[null,null,null,49,188,73]
[null,null,null,50,121,45]

{"sheet":"PartBi","index":1,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["THE LINEAR MODEL"]
[]
["Minimization"]
["SSE"]
[]
[]
[null,null,null,"The linear model"]
["Parameters","Value",null,"i","Observed length","Observed weight","Predicted","(obs-pre)","(obs-pre)2"]
["a (intercept)",0.001,null,1,95,8.825208106437044]
["b (slope)",3,null,2,67,2.3450969482312716]
[null,null,null,3,39,0.6402279348693617]
[null,null,null,4,25,0.1819273520764243]
[null,null,null,5,9,0.008837997798876947]
[null,null,null,6,73,3.2623571020779125]
[null,null,null,7,45,1.1784367473730033]
[null,null,null,8,5,0.0009823068547554089]
[null,null,null,9,39,0.6338934818547033]
[null,null,null,10,100,7.576788225522657]
[null,null,null,11,57,0.9711988671423984]
[null,null,null,12,6,0.00159838937414854]
[null,null,null,13,50,1.6069011417825196]
[null,null,null,14,59,1.6851407997949932]
[null,null,null,15,69,3.5650742959468555]
[null,null,null,16,84,6.649936746844351]
[null,null,null,17,66,2.2584043485941314]
[null,null,null,18,52,2.2047229268008404]
[null,null,null,19,39,0.5638232433428277]
[null,null,null,20,58,1.9442127078543587]
[null,null,null,21,40,0.9763247415484122]
[null,null,null,22,79,6.396282938328711]
[null,null,null,23,111,8.371048898144066]
[null,null,null,24,78,5.305560236134351]
[null,null,null,25,91,11.588609114262413]
[null,null,null,26,102,8.263331703612119]
[null,null,null,27,64,2.335636847895898]
[null,null,null,28,71,3.9664348491992363]
[null,null,null,29,80,5.830990633197421]
[null,null,null,30,5,0.0020687591454022496]
[null,null,null,31,53,1.869117264847459]
[null,null,null,32,51,1.5536802288743872]
[null,null,null,33,64,2.338689537744233]
[null,null,null,34,52,2.4025676912818943]
[null,null,null,35,62,2.67753560087732]
[null,null,null,36,73,2.9160050512898255]
[null,null,null,37,38,0.542640568245229]
[null,null,null,38,88,6.9760893114486295]
[null,null,null,39,82,7.061533624105752]
[null,null,null,40,30,0.17621473989292452]
[null,null,null,41,55,2.4297331128303337]
[null,null,null,42,38,0.4582271086173739]
[null,null,null,43,89,5.000185655622952]
[null,null,null,44,18,0.04658959331022604]
[null,null,null,45,90,7.151964684827584]
[null,null,null,46,84,7.1987499546869405]
[null,null,null,47,5,0.0016550773374164073]
[null,null,null,48,21,0.1291621026000669]
[null,null,null,49,66,2.4627293494130265]
[null,null,null,50,80,12.599121966718217]

{"sheet":"PartBii","index":2,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["THE LINEAR MODEL"]
[]
["Minimization"]
["SSE"]
[]
[]
[null,null,null,"The linear model"]
["Parameters","Value",null,"i","Observed total length","Observed carapace length","Predicted","(obs-pre)","(obs-pre)2"]
["a (intercept)",-12,null,1,4.553876891600541,2.177612184007276]
["b (slope)",3,null,2,4.204692619390966,0.8523267435729908]
[null,null,null,3,3.6635616461296463,-0.4459310178007698]
[null,null,null,4,3.2188758248682006,-1.7041478360079143]
[null,null,null,5,2.1972245773362196,-4.728694921325787]
[null,null,null,6,4.290459441148391,1.1824499715601826]
[null,null,null,7,3.8066624897703196,0.1641887698051564]
[null,null,null,8,1.6094379124341003,-6.925606819036996]
[null,null,null,9,3.6635616461296463,-0.4558743483530176]
[null,null,null,10,4.605170185988092,2.0250893929113705]
[null,null,null,11,4.04305126783455,-0.02922402512898547]
[null,null,null,12,1.791759469228055,-6.438758797897049]
[null,null,null,13,3.912023005428146,0.47430756761514664]
[null,null,null,14,4.07753744390572,0.5218491210225182]
[null,null,null,15,4.23410650459726,1.2711848940269013]
[null,null,null,16,4.430816798843313,1.8946073428697967]
[null,null,null,17,4.189654742026425,0.814658523475184]
[null,null,null,18,3.9512437185814275,0.7906018442236705]
[null,null,null,19,3.6635616461296463,-0.5730144749319168]
[null,null,null,20,4.060443010546419,0.664857117673131]
[null,null,null,21,3.6888794541139363,-0.023960020914072264]
[null,null,null,22,4.3694478524670215,1.8557170307551283]
[null,null,null,23,4.709530201312334,2.1247791930351347]
[null,null,null,24,4.356708826689592,1.668755371793464]
[null,null,null,25,4.51085950651685,2.450022642752648]
[null,null,null,26,4.624972813284271,2.111827860155749]
[null,null,null,27,4.1588830833596715,0.8482845939323119]
[null,null,null,28,4.2626798770413155,1.3778676683632662]
[null,null,null,29,4.382026634673881,1.7631869058585916]
[null,null,null,30,1.6094379124341003,-6.180806298110425]
[null,null,null,31,3.970291913552122,0.62546626853169]
[null,null,null,32,3.9318256327243257,0.4406264578461978]
[null,null,null,33,4.1588830833596715,0.8495907458911107]
[null,null,null,34,3.9512437185814275,0.8765380368168576]
[null,null,null,35,4.127134385045092,0.9848968195640962]
[null,null,null,36,4.290459441148391,1.0702145464116553]
[null,null,null,37,3.6375861597263857,-0.6113081151584596]
[null,null,null,38,4.477336814478207,1.9424884891979803]
[null,null,null,39,4.406719247264253,1.9546622551251829]
[null,null,null,40,3.4011973816621555,-1.736051914649008]
[null,null,null,41,4.007333185232471,0.887781421209715]
[null,null,null,42,3.6375861597263857,-0.7803903474274121]
[null,null,null,43,4.48863636973214,1.6094750428693476]
[null,null,null,44,2.8903717578961645,-3.066378082313101]
[null,null,null,45,4.499809670330265,1.9673871000552727]
[null,null,null,46,4.430816798843313,1.9739073935441718]
[null,null,null,47,1.6094379124341003,-6.403907541688161]
[null,null,null,48,3.044522437723423,-2.04668705419029]
[null,null,null,49,4.189654742026425,0.9012702265446154]
[null,null,null,50,4.382026634673881,2.5336271263482133]

{"sheet":"partC","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Parameters"]
["Mean",18,null,"Sums of squares"]
["stdev",4]
[]
[]
[]
[null,null,"n"]
[null,null,303]
[]
["Length","expected","observed","obs-pre","(obs-pre)2"]
[9,2.404278626551807,1]
[10,4.089815713373995,1]
[11,6.535506901108248,7]
[12,9.810957871691299,9]
[13,13.83566821821841,18]
[14,18.32928238232511,22]
[15,22.811160485726436,26]
[16,26.66894850239569,35]
[17,29.29010984781583,42]
[18,30.219877740408528,39]
[19,29.29010984781583,33]
[20,26.66894850239569,26]
[21,22.811160485726436,20]
[22,18.32928238232511,12]
[23,13.83566821821841,6]
[24,9.810957871691299,2]
[25,6.535506901108248,2]
[26,4.089815713373995,1]
[27,2.404278626551807,1]

{"sheet":"partCplus","index":4,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Parameters",null,null,null,"Sums of squares",null,null,null,"Maximum likelihood"]
["Mean",17.37261702956416,32.55155646858107,null,"SS",108.29364199912455,null,null,"ML",1755.3082574711152]
["stdev",3.1567791595341728,5.642396725582891,null,"penalty",0.0019703231950362675,null,null,"penalty",0.0019703231950362675]
["CV",0.17919074431528764,null,null,"Sum",108.29561232231958,null,null,"Sum",1755.3102277943103]
["Numbers",309.83304604097407,212.35687685560947]
[]
[null,"Cohort1","Cohort2","Expected","Observed"]
["Sum",309.0946977470863,211.86091393018074,520.9556116772671,521]
[]
["Length","Cohort1","Cohort2","Expected","Observed","obs-pre","(obs-pre)2",null,"PL","LL"]
[9,1.1621667844532977,0.002473157389369169,1.164639941842667,1,-0.16463994184266695,0.027106310449956754,null,0.0022355838304399787,-6.103252863355677]
[10,2.560731059837367,0.005101594123637146,2.5658326539610044,1,-1.5658326539610044,2.4518319002105624,null,0.004925242374681515,-5.313381792435709]
[11,5.103623260689133,0.010198086958973627,5.1138213476481065,7,1.8861786523518935,3.557669908588005,null,0.009816232387215606,-32.366025282671785]
[12,9.200520041565364,0.01975559784006049,9.220275639405424,9,-0.22027563940542372,0.04852135731546826,null,0.01769877400824967,-36.308339161847364]
[13,15.00255652897498,0.03708688019667798,15.039643409171658,18,2.960356590828342,8.763711144860803,null,0.028869337563617113,-63.8095541591438]
[14,22.1277520621401,0.06746974748125675,22.19522180962136,22,-0.1952218096213585,0.03811155495183794,null,0.04260482335176636,-69.4273317737191]
[15,29.520822258338622,0.1189478309137805,29.6397700892524,26,-3.6397700892524014,13.247926302616435,null,0.05689500108046497,-74.53024270074908]
[16,35.62367597461227,0.20321821280276844,35.826894187415036,35,-0.8268941874150357,0.6837539971807722,null,0.06877149105288811,-93.69380979527949]
[17,38.88375002087552,0.33645531032230624,39.220205331197825,42,2.7797946688021753,7.727258400700995,null,0.07528511921567477,-108.63185691470484]
[18,38.38987354653065,0.5398222804670109,38.929695826997666,39,0.07030417300233438,0.004942676741542163,null,0.07472747188893836,-101.16239217035012]
[19,34.28343658897727,0.8393302634023566,35.12276685237963,33,-2.122766852379627,4.506139109561708,null,0.06741988389240779,-88.99490461393135]
[20,27.693072692096344,1.2646595221873964,28.95773221428374,30,1.042267785716259,1.0863221371418736,null,0.05558579572845278,-86.69482748622309]
[21,20.233782188833366,1.8466007724363296,22.080382961269695,25,2.919617038730305,8.524163652844315,null,0.042384384516330975,-79.02438185721778]
[22,13.372177236904982,2.61294980007406,15.98512703697904,13,-2.9851270369790406,8.910983426903266,null,0.03068424003633126,-45.29207943085312]
[23,7.993671672147303,3.583008002558303,11.576679674705606,12,0.42332032529439445,0.17920009780735194,null,0.02222200781643058,-45.68006565692986]
[24,4.3222473534454835,4.761273715862731,9.083521069308215,7,-2.0835210693082153,4.341060046251249,null,0.017436266863625746,-28.344420575795223]
[25,2.1139370786796405,6.131365111982853,8.245302190662493,8,-0.2453021906624926,0.06017316474381787,null,0.015827264369253923,-33.16816986466808]
[26,0.9351765848509682,7.651557858413899,8.586734443264866,8,-0.5867344432648665,0.3442573069133328,null,0.01648266042402162,-32.84357067226671]
[27,0.3742090796883634,9.25339739122708,9.627606470915444,11,1.3723935290845564,1.883463998673163,null,0.018480665636595082,-43.90133213533108]
[28,0.135442245710191,10.84454210354623,10.979984349256421,10,-0.9799843492564211,0.9603693247875311,null,0.021076621698929966,-38.59590829113712,null,null,null,"Parameters"]
[29,0.044341777637139944,12.316289358640915,12.360631136278055,13,0.6393688637219448,0.4087925438970908,null,0.023726841326234694,-48.634928241588604,null,null,null,"Mean",17.27839220225111,32.57553865683308]
[30,0.013130799867069108,13.555239859925347,13.568370659792416,15,1.431629340207584,2.049562567743202,null,0.026045156930180155,-54.718851636831914,null,null,null,"stdev",3.1210721724258206,5.957753236094]
[31,0.0035171297735628487,14.457499592338227,14.46101672211179,17,2.53898327788821,6.446436085395961,null,0.02775863508899183,-60.931541317877354,null,null,null,"CV",0.17919074431528764]
[32,0.0008521277970744946,14.943001132752572,14.943853260549647,12,-2.9438532605496466,8.666272019648785,null,0.028685463647155005,-42.61637733189627,null,null,null,"Numbers",304.59548737599204,217.95276071472082]
[33,0.00018674122383841477,14.967219532932704,14.967406274156543,14,-0.9674062741565432,0.9358748992774449,null,0.028730674818853618,-49.697058851537605]
[34,3.701645266753484e-05,14.527908198060294,14.527945214512961,16,1.472054785487039,2.166945291475292,null,0.027887107632335185,-57.27345262373181]
[35,6.636949647071735e-06,13.665442645083962,13.66544928203361,12,-1.6654492820336095,2.7737213110262653,null,0.026231504135326173,-43.68952971196026]
[36,1.0763694841404167e-06,12.456699255850422,12.456700332219906,11,-1.4567003322199064,2.1219758578895855,null,0.023911250887795124,-41.06746800605514]
[37,1.5789681116992884e-07,11.00375503706547,11.003755194962281,13,1.996244805037719,3.984993321640081,null,0.021122251010090135,-50.14656717078292]
[38,2.095098617937618e-08,9.419709439376817,9.419709460327804,9,-0.41970946032780354,0.1761560310886561,null,0.01808159706735884,-36.11574535092887]
[39,2.5145177757146467e-09,7.814348190603104,7.814348193117621,9,1.1856518068823787,1.4057702071634495,null,0.01500002690816319,-37.797329556035905]
[40,2.7297575662531595e-10,6.282126381124637,6.282126381397612,4,-2.282126381397612,5.208100820670959,null,0.012058851542402426,-17.6718252834966]
[41,2.680480025967509e-11,4.894172116392137,4.894172116418942,5,0.10582788358105777,0.011199540943245916,null,0.009394604850616122,-23.338098532709147]
[42,2.3807851275089313e-12,3.694966169446337,3.6949661694487177,5,1.3050338305512823,1.703113298883353,null,0.007092669867884551,-24.74346720607121]
[43,1.9127004278520183e-13,2.703338024777892,2.7033380247780836,2,-0.7033380247780836,0.49468437709873614,null,0.005189190718330924,-10.522355049840536]
[44,1.389929708710208e-14,1.9166768556990812,1.9166768556990952,3,1.0833231443009048,1.173589034977999,null,0.003679155791273978,-16.81521587299098]
[45,9.136036985621028e-16,1.3169100224750625,1.3169100224750634,2,0.6830899775249366,0.4666119173950184,null,0.0025278737630546754,-11.960753478889737]
[46,5.431777715265676e-17,0.8768432556556732,0.8768432556556732,1,0.12315674434432677,0.015167583677493865,null,0.0016831438917273417,-6.387091870263946]
[47,2.9210921492936403e-18,0.5657785621317604,0.5657785621317604,0,-0.5657785621317604,0.32010538136788225,null,0.0010860398649132148,0]
[48,1.42091354635358e-19,0.35377705966125417,0.35377705966125417,1,0.6462229403387458,0.41760408862005427,null,0.000679092520996625,-7.294753179015724]