{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["CellReferencing","Vlookup","RandomNumbersI","RandomNumbersII","FrequencyDistributions"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":2,"defined_names":3,"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":"CellReferencing","index":0,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,"a (intercept)",3]
[null,"b (slope)",5]
[]
[]
["i","x","y","y","y"]
[1,2,13,13,13]
[2,4,23,23,23]
[3,6,33,33,33]
[4,8,43,43,43]
[5,10,53,53,53]
[6,12,63,63,63]
[7,14,73,73,73]
[8,16,83,83,83]
[9,18,93,93,93]
[10,20,103,103,103]

{"sheet":"Vlookup","index":1,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":8}
["Station location",{"$nulls":4},"Fish measurements"]
["station #","date","lat","lon",null,"station #","species","length","weight",null,"date","lat","lon"]
[1,"2010-01-01",6459,-2200,null,1,2,95,8.825208106437044,null,"2010-01-01",6459,-2200]
[2,"2010-02-01",6522,-2230,null,1,2,67,2.3450969482312716,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,2,39,0.6402279348693617,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,2,25,0.1819273520764243,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,2,9,0.008837997798876947,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,2,73,3.2623571020779125,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,3,45,1.1784367473730033,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,3,5,0.0009823068547554089,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,3,39,0.6338934818547033,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,3,100,7.576788225522657,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,3,57,0.9711988671423984,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,3,6,0.00159838937414854,null,"2010-01-01",6459,-2200]
[{"$nulls":5},1,3,50,1.6069011417825196,null,"2010-01-01",6459,-2200]
[{"$nulls":5},2,1,59,1.6851407997949932,null,"2010-02-01",6522,-2230]
[{"$nulls":5},2,1,69,3.5650742959468555,null,"2010-02-01",6522,-2230]
[{"$nulls":5},2,1,84,6.649936746844351,null,"2010-02-01",6522,-2230]
[{"$nulls":5},2,1,66,2.2584043485941314,null,"2010-02-01",6522,-2230]
[{"$nulls":5},2,1,52,2.2047229268008404,null,"2010-02-01",6522,-2230]
[{"$nulls":5},2,2,39,0.5638232433428277,null,"2010-02-01",6522,-2230]
[{"$nulls":5},2,2,58,1.9442127078543587,null,"2010-02-01",6522,-2230]
[{"$nulls":5},2,2,40,0.9763247415484122,null,"2010-02-01",6522,-2230]

{"sheet":"RandomNumbersI","index":2,"n_rows":110,"n_cols":20,"rows_kept":110,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[{"$nulls":15},"Population statistics",null,null,"Sample statistics"]
[{"$nulls":15},"average",47.71,null,"average",45.25]
[{"$nulls":15},"standard def",9.268492298909756,null,"standard def",9.072079782439491]
[]
[]
["i","rand()","randbetwee()",{"$nulls":12},"i","Length",null,"Subsample","Length"]
[1,0.19767862525804958,36,{"$nulls":12},1,52,null,66,41]
[2,0.47543162422789464,5,{"$nulls":12},2,77,null,58,51]
[3,0.5524793943059194,21,{"$nulls":12},3,43,null,84,52]
[4,0.16388685808942682,34,{"$nulls":12},4,55,null,47,52]
[5,0.05035640472124214,19,{"$nulls":12},5,43,null,78,37]
[6,0.02702408935783751,8,{"$nulls":12},6,44,null,39,34]
[7,0.07600701586306968,38,{"$nulls":12},7,58,null,85,48]
[8,0.1421969099483249,43,{"$nulls":12},8,53,null,83,56]
[9,0.6083089867734088,47,{"$nulls":12},9,51,null,40,59]
[10,0.025693677796880365,4,{"$nulls":12},10,45,null,95,33]
[11,0.3847188285917582,5,{"$nulls":12},11,45,null,89,36]
[12,0.9448999552441819,11,{"$nulls":12},12,40,null,7,58]
[13,0.703345390494178,33,{"$nulls":12},13,30,null,48,52]
[14,0.32879483757824346,46,{"$nulls":12},14,58,null,31,33]
[15,0.8164749046636643,4,{"$nulls":12},15,42,null,98,31]
[16,0.9271670064263162,5,{"$nulls":12},16,69,null,93,51]
[17,0.5477427218966113,35,{"$nulls":12},17,38,null,64,39]
[18,0.6953483029228664,36,{"$nulls":12},18,37,null,85,48]
[19,0.5869373915165852,19,{"$nulls":12},19,43,null,5,43]
[20,0.22755741201035562,14,{"$nulls":12},20,47,null,9,51]
[21,0.4608472228565006,24,{"$nulls":12},21,32]
[22,0.48066890880545543,18,{"$nulls":12},22,49]
[23,0.37019778006742854,10,{"$nulls":12},23,42]
[24,0.858200023372774,47,{"$nulls":12},24,60]
[25,0.8659109646278011,30,{"$nulls":12},25,46]
[26,0.4757472136789147,31,{"$nulls":12},26,28]
[27,0.09403423261119315,33,{"$nulls":12},27,50]
[28,0.9166234723124944,13,{"$nulls":12},28,48]
[29,0.592054999498032,15,{"$nulls":12},29,47]
[30,0.2480118296934961,10,{"$nulls":12},30,47]
[31,0.8829371496913154,7,{"$nulls":12},31,33]
[32,0.4313346441122121,13,{"$nulls":12},32,55]
[33,0.9595454988257188,8,{"$nulls":12},33,43]
[34,0.8733121083223523,18,{"$nulls":12},34,61]
[35,0.7719092481247571,29,{"$nulls":12},35,42]
[36,0.9491539451082645,30,{"$nulls":12},36,47]
[37,0.8122177484756321,17,{"$nulls":12},37,58]
[38,0.669730185667504,27,{"$nulls":12},38,46]
[39,0.4613093995158124,25,{"$nulls":12},39,34]
[40,0.9043095926144815,32,{"$nulls":12},40,59]
[41,0.6544549664067745,45,{"$nulls":12},41,50]
[42,0.7209192686705137,31,{"$nulls":12},42,44]
[43,0.6444197868477204,10,{"$nulls":12},43,42]
[44,0.9946479090822322,45,{"$nulls":12},44,42]
[45,0.7394321482297528,42,{"$nulls":12},45,38]
[46,0.5962890097262061,45,{"$nulls":12},46,37]
[47,0.04964447846217013,42,{"$nulls":12},47,52]
[48,0.2685710269014976,24,{"$nulls":12},48,52]
[49,0.01867877750828484,43,{"$nulls":12},49,53]
[50,0.684940822144199,47,{"$nulls":12},50,79]
[{"$nulls":15},51,49]
[{"$nulls":15},52,49]
[{"$nulls":15},53,45]
[{"$nulls":15},54,46]
[{"$nulls":15},55,48]
[{"$nulls":15},56,43]
[{"$nulls":15},57,39]
[{"$nulls":15},58,51]
[{"$nulls":15},59,51]
[{"$nulls":15},60,40]
[{"$nulls":15},61,53]
[{"$nulls":15},62,46]
[{"$nulls":15},63,49]
[{"$nulls":15},64,39]
[{"$nulls":15},65,40]
[{"$nulls":15},66,41]
[{"$nulls":15},67,58]
[{"$nulls":15},68,43]
[{"$nulls":15},69,48]
[{"$nulls":15},70,55]
[{"$nulls":15},71,63]
[{"$nulls":15},72,53]
[{"$nulls":15},73,69]
[{"$nulls":15},74,54]
[{"$nulls":15},75,39]
[{"$nulls":15},76,45]
[{"$nulls":15},77,33]
[{"$nulls":15},78,37]
[{"$nulls":15},79,64]
[{"$nulls":15},80,49]
[{"$nulls":15},81,44]
[{"$nulls":15},82,52]
[{"$nulls":15},83,56]
[{"$nulls":15},84,52]
[{"$nulls":15},85,48]
[{"$nulls":15},86,56]
[{"$nulls":15},87,52]
[{"$nulls":15},88,55]
[{"$nulls":15},89,36]
[{"$nulls":15},90,46]
[{"$nulls":15},91,40]
[{"$nulls":15},92,51]
[{"$nulls":15},93,51]
[{"$nulls":15},94,43]
[{"$nulls":15},95,33]
[{"$nulls":15},96,53]
[{"$nulls":15},97,50]
[{"$nulls":15},98,31]
[{"$nulls":15},99,51]
[{"$nulls":15},100,46]

{"sheet":"RandomNumbersII","index":3,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,"mean",0,20]
[null,"stdev",1,5]
[]
[]
["i","rand()","normal 1","normal 2","normal 3"]
[1,0.807430146378012,0.8684652145649951,24.342326072824974,24.342326072824974]
[2,0.646156604670705,0.37496460472133464,21.874823023606673,21.874823023606673]
[3,0.3385018123759771,-0.4165554173597781,17.91722291320111,17.91722291320111]
[4,0.9856437837172356,2.18741238906052,30.9370619453026,30.9370619453026]
[5,0.5214271945307924,0.05373586122600886,20.268679306130043,20.268679306130043]
[6,0.24223225132837545,-0.6991400643017323,16.50429967849134,16.50429967849134]
[7,0.9923793117016322,2.4265922102567767,32.132961051283885,32.132961051283885]
[8,0.7745470014309019,0.7539054511407195,23.769527255703597,23.769527255703597]
[9,0.653374405369775,0.39444681084286304,21.972234054214315,21.972234054214315]
[10,0.18233775253831808,-0.9064919853833588,15.467540073083207,15.467540073083207]
[11,0.9919258246273213,2.405545277691915,32.02772638845957,32.02772638845957]
[12,0.8085303347474746,0.872493283822547,24.362466419112735,24.362466419112735]
[13,0.9565268040410961,1.711730246320121,28.558651231600606,28.558651231600606]
[14,0.49623086844746744,-0.009447952278524057,19.95276023860738,19.95276023860738]
[15,0.16664161997842908,-0.9675218174868616,15.16239091256569,15.16239091256569]
[16,0.21529926804043864,-0.7881678428541852,16.059160785729073,16.059160785729073]
[17,0.08070195874011277,-1.400365427199148,12.99817286400426,12.99817286400426]
[18,0.40451819691435986,-0.24166933321490874,18.791653333925456,18.791653333925456]
[19,0.5060025881164689,0.015046824858680842,20.075234124293406,20.075234124293406]
[20,0.8397023799034509,0.9932354214413821,24.96617710720691,24.96617710720691]
[21,0.731307379470117,0.616771820988177,23.083859104940885,23.083859104940885]
[22,0.5729279540202694,0.1838334781040935,20.919167390520467,20.919167390520467]
[23,0.8318109785000525,0.9613463641887725,24.806731820943863,24.806731820943863]
[24,0.11594352164569699,-1.1955120187776145,14.022439906111927,14.022439906111927]
[25,0.4297674641802971,-0.17696621354397885,19.115168932280106,19.115168932280106]
[26,0.9508400448865553,1.653053822139868,28.26526911069934,28.26526911069934]
[27,0.7255656260203054,0.5994561425977294,22.997280712988648,22.997280712988648]
[28,0.5377669520181128,0.09480955664527341,20.474047783226368,20.474047783226368]
[29,0.33368346881636857,-0.42976452932844966,17.851177353357752,17.851177353357752]
[30,0.9973567407920927,2.7890360253069737,33.945180126534865,33.945180126534865]
[31,0.7323590608512205,0.6199634078673497,23.09981703933675,23.09981703933675]
[32,0.5940622180603485,0.2380071303508376,21.190035651754187,21.190035651754187]
[33,0.1736675667995975,-0.939770812053385,15.301145939733075,15.301145939733075]
[34,0.454058629408997,-0.11541365165009182,19.42293174174954,19.42293174174954]
[35,0.37143493786361126,-0.3280552669577277,18.359723665211362,18.359723665211362]
[36,0.08055409221490706,-1.4013541881599307,12.993229059200345,12.993229059200345]
[37,0.2842037382919919,-0.5703984559537527,17.148007720231234,17.148007720231234]
[38,0.865894919238023,1.1071937676830736,25.535968838415368,25.535968838415368]
[39,0.28335685152303136,-0.5728980824075154,17.135509587962424,17.135509587962424]
[40,0.3151621687261059,-0.4812703917574057,17.593648041212973,17.593648041212973]
[41,0.42454663972725126,-0.19027546380502403,19.04862268097488,19.04862268097488]
[42,0.9644773522064609,1.8051878242928003,29.025939121464003,29.025939121464003]
[43,0.5639342262306517,0.16095156646750503,20.804757832337526,20.804757832337526]
[44,0.7804868560361387,0.7738385237211451,23.869192618605727,23.869192618605727]
[45,0.7334116213485551,0.6231639982205812,23.115819991102907,23.115819991102907]
[46,0.09547729931003968,-1.307760373499919,13.461198132500405,13.461198132500405]
[47,0.14142045136128267,-1.0739593462231927,14.630203268884037,14.630203268884037]
[48,0.08494037790537678,-1.3725870635392394,13.137064682303803,13.137064682303803]
[49,0.5932048911444454,0.23579697225707147,21.178984861285358,21.178984861285358]
[50,0.01481648131996427,-2.174962019740353,9.125189901298235,9.125189901298235]

{"sheet":"FrequencyDistributions","index":4,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[null,"n",50]
[]
[null,"Value","Observed","Expected","Expected"]
[null,-3,0,0.0013498980316301035,0.06749490158150517]
[null,-2.6,0,0.004661188023718732,0.16556449960443143]
[null,-2.2,0,0.01390344751349859,0.4621129744889929]
[null,-1.8,1,0.03593031911292588,1.1013435799713645]
[null,-1.4,2,0.08075665923377118,2.241317006042265]
[null,-1,4,0.15865525393145707,3.894929734884295]
[null,-0.6,5,0.27425311775007366,5.77989319093083]
[null,-0.2,7,0.420740290560897,7.324358640541168]
[null,0.2,9,0.579259709439103,7.925970943910299]
[null,0.6,5,0.7257468822499263,7.324358640541168]
[null,1,9,0.8413447460685429,5.77989319093083]
[null,1.4,1,0.9192433407662288,3.894929734884295]
[null,1.8,2,0.9640696808870741,2.241317006042265]
[null,2.2,2,0.9860965524865014,1.1013435799713645]
[null,2.6,2,0.9953388119762813,0.4621129744889929]
[null,3,1,0.9986501019683699,0.16556449960443143]