{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Set 1 annotated","Set10","matrix formulas","Linear","Nonlinear"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":0,"defined_names":34,"comments":4,"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":"Set 1 annotated","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["SUMMARY OUTPUT"]
[]
["Regression Statistics"]
["Multiple R",0.98673698398677934]
["R Square",0.97364987556732563]
["Adjusted R Square",0.96612126858656155]
["Standard Error",0.14396518911112152]
["Observations",10]
[]
["ANOVA"]
[null,"df","SS","MS","F","Significance F"]
["Regression",2,5.3608439620544308,2.6804219810272154,129.32669723031637,2.9698830413494815E-6]
["Residual",7,0.14508182973060688,2.0725975675800982E-2]
["Total",9,5.5059257917850379]
[]
[null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["Intercept",1.0240315936631919,0.16932493324431386,6.0477306799563149,5.1712217682997738E-4,0.6236417502233127,1.424421437103071,0.6236417502233127,1.424421437103071]
["X Variable 1",0.96023350101467875,7.0717230620430754E-2,13.578494132054711,2.7634232784387004E-6,0.79301382252963237,1.1274531794997251,0.79301382252963237,1.1274531794997251]
["X Variable 2",-9.5011214857434162E-2,6.2652806649206938E-3,-15.164718061140015,1.3043940878381537E-6,-0.1098262494567095,-8.019618025815882E-2,-0.1098262494567095,-8.019618025815882E-2]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1E+50^0","v":1}]

{"sheet":"Set10","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["SUMMARY OUTPUT"]
[]
["Regression Statistics"]
["Multiple R",0.99669600676986225]
["R Square",0.99340292991098922]
["Adjusted R Square",0.99151805274270033]
["Standard Error",7.6132315456159144E-2]
["Observations",10]
[]
["ANOVA"]
[null,"df","SS","MS","F","Significance F"]
["Regression",2,6.1095673302388187,3.0547836651194094,527.03855011032408,2.3320015974399827E-8]
["Residual",7,4.0572906197012905E-2,5.796129456716129E-3]
["Total",9,6.1501402364358313]
[]
[null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["Intercept",0.88001439608827647,8.9543168817004942E-2,9.8278228000476453,2.3986662880821699E-5,0.66827844759673771,1.0917503445798151,0.66827844759673771,1.0917503445798151]
["X Variable 1",1.030982575040208,3.7397002310225004E-2,27.568588692958393,2.1207282434515444E-8,0.94255271646464223,1.1194124336157738,0.94255271646464223,1.1194124336157738]
["X Variable 2",-0.1017514249713823,3.3132337542719809E-3,-30.710608582985479,1.0017615799810907E-8,-0.10958597785579768,-9.3916872086966918E-2,-0.10958597785579768,-9.3916872086966918E-2]

{"sheet":"matrix formulas","index":2,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Matrix formulation"]
[]
["Simulating data according to Y = a1 + a2x + a3x2"]
[]
[]
["xi","yi","yifit","yi-yifit","[Jya]","=dyfit/da",null,null,"[Xu]-1 = [s2a]/s2y",null,null,null,"[Jya]†[Jya]"]
[1,1.8699767840866115,{"$f":"MMULT(E7:G16,I17:I19)","v":1.8892538798204763},{"$f":"B7-C7","v":-1.9277095733864824E-2},1,1,{"$f":"F7^2","v":1},null,{"$f":"MINVERSE(MMULT(TRANSPOSE(E7:G16),E7:G16))","v":1.3833333333333167},-0.52499999999999236,4.1666666666666033E-2,null,{"$f":"MMULT(I12:R14,E7:G16)","v":1.0000000000000093},1.0746958878371515E-13,6.3948846218409017E-13]
[2,2.5309795839508298,2.5644537362628421,{"$f":"B8-C8","v":-3.347415231201234E-2},1,2,{"$f":"F8^2","v":4},null,-0.52499999999999292,0.24128787878787553,-2.0833333333333051E-2,null,0,0.99999999999998668,7.1054273576010019E-15]
[3,3.067300936987158,3.0496311629903419,1.7669773996816129E-2,1,3,9,null,4.1666666666666075E-2,-2.0833333333333062E-2,1.8939393939393704E-3,null,-5.5511151231257827E-17,6.6613381477509392E-16,0.99999999999999578]
[4,3.5661455826251767,3.3447861600029754,0.22135942262220132,1,4,16]
[5,3.3555813363054767,3.4499187273007426,-9.4337390995265835E-2,1,5,25,null,"[Jya]†"]
[6,3.1422419255599379,3.3650288648836426,-0.22278693932370475,1,6,36,null,{"$f":"MMULT(I7:K9,TRANSPOSE(E7:G16))","v":0.89999999999999036},0.49999999999999606,0.18333333333333385,-4.999999999999627E-2,-0.1999999999999944,-0.26666666666666039,-0.24999999999999423,-0.14999999999999591,3.3333333333334103E-2,0.29999999999999627]
[7,3.1693994479661338,3.0901165727516764,7.9282875214457427E-2,1,7,49,null,-0.30454545454545046,-0.12575757575757407,1.1363636363636243E-2,0.10681818181818037,0.16060606060605842,0.17272727272727051,0.14318181818181608,7.1969696969695907E-2,-4.090909090909034E-2,-0.19545454545454266]
[8,2.6072238890425066,2.6251818509048448,-1.7957961862338223E-2,1,8,64,null,2.2727272727272384E-2,7.5757575757574329E-3,-3.7878787878787741E-3,-1.1363636363636246E-2,-1.5151515151514978E-2,-1.5151515151514958E-2,-1.1363636363636201E-2,-3.7878787878787151E-3,7.5757575757575135E-3,2.2727272727272485E-2]
[9,2.1205688360845674,1.9702246993431451,0.15034413674142222,1,9,81]
[10,1.0444224497186951,1.1252451180665819,-8.0822668347886761E-2,1,10,100,null,"a","sa",null,null,"sy","sy"]
[null,null,null,null,null,null,null,null,{"$f":"MMULT(I12:R14,B7:B16)","v":1.0240315936632438},{"$f":"SQRT(MMULT(_xlfn.MUNIT(3)*I7:K9,ROW(1:3)^0))*M17","v":0.11761519176251496},"            input->",null,0.1,{"$f":"SQRT(SUMPRODUCT(D7:D16,D7:D16)/7)","v":0.1439651891111218}]
[null,null,null,null,null,null,null,null,0.96023350101466565,4.9121062568706263E-2]
[null,null,null,null,null,null,null,null,-9.5011214857433191E-2,4.3519413988924189E-3,null,null,"c2n",{"$f":"N17^2/M17^2","v":2.0725975675801056}]

{"sheet":"Linear","index":3,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,13,2,14]]}
[]
[null,"Simulating data according to y = A + Bx + Cx2",null,null,null,null,null,null,null,null,null,null,null,"Fitting data according to y = A + Bx + Cx2"]
[null,"True values",null,null,null,null,null,null,null,null,null,null,null,"Fit values",null,"Samp sd","True sd"]
[null,"A",1,null,null,null,null,null,null,null,null,null,null,"A",1.0240315936631919,0.16932493324431386,{"$f":"P4*(0.1/$P$9)","v":0.11761519176251573}]
[null,"B",1,null,null,null,null,null,null,null,null,null,null,"B",0.96023350101467875,7.0717230620430754E-2,{"$f":"P5*(0.1/$P$9)","v":4.9121062568706617E-2}]
[null,"C",-0.1,null,null,null,null,null,null,null,null,null,null,"C",-9.5011214857434162E-2,6.2652806649206938E-3,{"$f":"P6*(0.1/$P$9)","v":4.3519413988924466E-3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"S (DY)2","dof","sy","c2n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(R12:R21,R12:R21)","v":0.14508182973060663},7,{"$f":"SQRT(N9/O9)","v":0.14396518911112141},{"$f":"(P9/0.1)^2","v":2.0725975675800945}]
[]
[null,"x","ytrue","yerr","ymeas",null,null,null,null,null,null,null,null,"x","x2","ymeas","yfit","Dy"]
[null,1,{"$f":"$C$4+$C$5*B12+$C$6*B12^2","v":1.9},-3.0023215913388399E-2,{"$f":"C12+D12","v":1.8699767840866115},null,null,null,null,null,null,null,null,{"$f":"B12","v":1},{"$f":"B12^2","v":1},{"$f":"E12","v":1.8699767840866115},{"$f":"$O$4+$O$5*N12+$O$6*O12","v":1.8892538798204364},{"$f":"P12-Q12","v":-1.9277095733824856E-2}]
[null,2,{"$f":"$C$4+$C$5*B13+$C$6*B13^2","v":2.6},-6.9020416049170308E-2,{"$f":"C13+D13","v":2.5309795839508298},null,null,null,null,null,null,null,null,{"$f":"B13","v":2},{"$f":"B13^2","v":4},{"$f":"E13","v":2.5309795839508298},{"$f":"$O$4+$O$5*N13+$O$6*O13","v":2.5644537362628128},{"$f":"P13-Q13","v":-3.347415231198303E-2}]
[null,3,3.1,-3.2699063012842089E-2,3.067300936987158,null,null,null,null,null,null,null,null,3,9,3.067300936987158,3.0496311629903206,1.7669773996837446E-2]
[null,4,3.4,0.16614558262517676,3.5661455826251767,null,null,null,null,null,null,null,null,4,16,3.5661455826251767,3.3447861600029607,0.22135942262221597]
[null,5,3.5,-0.14441866369452327,3.3555813363054767,null,null,null,null,null,null,null,null,5,25,3.3555813363054767,3.4499187273007323,-9.4337390995255621E-2]
[null,6,3.4,-0.25775807444006205,3.1422419255599379,null,null,null,null,null,null,null,null,6,36,3.1422419255599379,3.3650288648836342,-0.22278693932369631]
[null,7,3.0999999999999996,6.9399447966134176E-2,3.1693994479661338,null,null,null,null,null,null,null,null,7,49,3.1693994479661338,3.0901165727516693,7.9282875214464532E-2]
[null,8,2.5999999999999996,7.2238890425069258E-3,2.6072238890425066,null,null,null,null,null,null,null,null,8,64,2.6072238890425066,2.6251818509048359,-1.7957961862329341E-2]
[null,9,1.9000000000000004,0.22056883608456701,2.1205688360845674,null,null,null,null,null,null,null,null,9,81,2.1205688360845674,1.9702246993431345,0.15034413674143288]
[null,10,1,4.4422449718695134E-2,1.0444224497186951,null,null,null,null,null,null,null,null,10,{"$f":"B21^2","v":100},1.0444224497186951,1.1252451180665641,-8.0822668347868998E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Set 1","Set 2","Set 3","Set 4","Set 5","Set 6","Set 7","Set 8","Set 9","Set 10","mean","std dev"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Afit",1.0240315936631919,0.78293753315483583,1.0374327858783867,1.0697532527738081,1.084324426552485,0.98965438408049522,0.78625558772667725,0.92944779402629818,1.145610465551727,0.88001439608827647,{"$f":"AVERAGE(O24:X24)","v":0.97294622194961811},{"$f":"STDEV(O24:X24)","v":0.12477632152611148}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bfit",0.96023350101467875,1.046532104757909,0.95976836854341896,0.97742169601665241,0.9771144373563867,1.0010903756281713,1.0900745156038527,1.0620449181055982,0.95965354311479234,1.030982575040208,{"$f":"AVERAGE(O25:X25)","v":1.0064916035181668},{"$f":"STDEV(O25:X25)","v":4.7760107356847992E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dfit",-9.5011214857434162E-2,-0.10130456981244632,-9.5506164285677972E-2,-9.9025821793883056E-2,-9.8055599372960489E-2,-9.9543211453618038E-2,-0.1080118559598111,-0.10720060132731635,-9.7887857027694009E-2,-0.1017514249713823,{"$f":"AVERAGE(O26:X26)","v":-0.10032983208622237},{"$f":"STDEV(O26:X26)","v":4.3995208386052196E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"c2n",2.0725975675800945,0.64803310320302743,1.5724371700045614,0.57120584426054455,1.0573232618014941,1.3331914345378433,1.164812733013513,0.91865409919714824,2.3772039067769555,0.57961294567161015,{"$f":"AVERAGE(O27:X27)","v":1.2295072066046793},{"$f":"STDEV(O27:X27)","v":0.62188406908239624}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"set",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"mean",{"$f":"AVERAGE(O32:O41)","v":-2.6159227672906127E-3},-1.136182845584699E-2,-1.0828512131411117E-2,-1.6921558199101128E-2,3.331325615363312E-2,1.3237809071142692E-2,-2.6791030904860236E-2,-6.5283074945909902E-3,5.022457116865553E-3,-1.7011302588798571E-2,{"$f":"AVERAGE(O30:X30)","v":-4.0484940200258279E-3},{"$f":"STDEV(O30:X30)","v":1.7434407926911175E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"s2",{"$f":"VAR(O32:O41)","v":1.9673196995321007E-2},1.4633749770652123E-2,1.4190775723400365E-2,5.7882774674412737E-3,8.4659729295847481E-3,1.0724284646001473E-2,1.2860103943185158E-2,1.2886677204402678E-2,2.1435550113460392E-2,5.9465128128224527E-3,{"$f":"AVERAGE(O31:X31)","v":1.2660510160627168E-2},{"$f":"STDEV(O31:X31)","v":5.229764533449378E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N(0,0.1)",-3.0023215913388399E-2,-0.12776831681549083,2.4425730771326926E-2,0.12764735402015503,0.11983502190560102,0.17331331036984921,-0.21835876395925879,-2.3418124328600243E-2,0.10950225259875879,-0.10867006494663656]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,-6.9020416049170308E-2,-0.16904323274502531,-0.18469108908902854,-9.7762949735624716E-2,-7.7350705396384001E-2,-0.21179312170716003,-5.6792487157508731E-2,-4.0404756873613223E-2,1.348530531686265E-2,-3.6549295145960059E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.2699063012842089E-2,-3.7024051380285528E-2,0.13426415534922853,-8.5284455053624697E-3,-1.8615764929563738E-2,-5.1320739657967351E-2,0.19722119759535417,8.6567297330475412E-2,0.23756547307129949,-6.5490667111589573E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.16614558262517676,-0.16123976820381358,5.3894837037660182E-2,9.0219145931769162E-2,0.19189155864296481,-8.4517068899003789E-3,-5.2379505177668761E-2,6.7513838075683452E-2,-3.8132384361233562E-2,7.5761136031360365E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.14441866369452327,-8.4723751569981687E-2,-0.15215709936455823,-3.6287701732362621E-2,-3.2479192668688484E-3,2.8117028705310076E-3,-3.2271600503008813E-2,0.21945015760138631,-0.17424827092327178,-7.3647697718115523E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.25775807444006205,0.14476700016530231,-0.12797636372852139,-6.5357994571968447E-2,7.5771367846755311E-2,4.6671175368828699E-2,8.7460875874967314E-2,5.9574176702881232E-2,-0.13718499758397229,-0.11157385415572207]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.9399447966134176E-2,3.22636424243683E-2,-9.3983771876082756E-2,-2.4094788386719301E-2,1.3153567124390975E-2,5.5779764807084575E-2,1.387149950460298E-2,-9.1096126197953708E-2,0.18848459149012342,4.871981218457222E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2238890425069258E-3,8.2984115579165518E-2,8.6200770965660922E-2,-6.3653146753495093E-2,-9.2319169198162854E-2,0.11111887943116017,-0.12011787475785241,-0.15588921087328345,7.113249012036249E-2,6.3840616348898038E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22056883608456701,0.14437546269618906,0.13039039004070219,1.129603788285749E-2,1.9508661353029311E-4,4.5370143197942525E-2,-2.5514736989862286E-3,-0.10546750672801863,-0.17748061509337276,8.2833139458671212E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4422449718695134E-2,6.1790615291101858E-2,2.1347318579501007E-2,-0.10269309314026032,0.12381951819406822,-3.1121317078941502E-2,-8.3992176769243088E-2,-8.2112819654867053E-2,-4.2899273466900922E-2,-4.5336150833463762E-2]
[]
[]
[""]

{"sheet":"Nonlinear","index":4,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,13,2,14]]}
[]
[null,"Simulating data according to y = A + Bx + Cx2",null,null,null,null,null,null,null,null,null,null,null,"Fitting data according to y = A + Bx + Cx2"]
[null,"True values",null,null,null,null,null,null,null,null,null,null,null,"Fit values",null,null,null,"True sd"]
[null,"A",1,null,null,null,null,null,null,null,null,null,null,"A",1.0240315936631919,null,null,0.11761519176251595]
[null,"B",1,null,null,null,null,null,null,null,null,null,null,"B",0.96023350101467875,null,null,4.9121062568706693E-2]
[null,"C",-0.1,null,null,null,null,null,null,null,null,null,null,"C",-9.5011214857434162E-2,null,null,4.3519413988924545E-3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"c2","dof",null,"c2n","s"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(R12:R21,R12:R21)","v":14.508182973060663},7,null,{"$f":"N9/O$9:O$65536","v":2.0725975675800945},{"$f":"0.1*SQRT(Q9)","v":0.14396518911112141}]
[]
[null,"x","ytrue","yerr","ymeas",null,null,null,null,null,null,null,null,"x","ymeas","sy","yfit","Dy/sy"]
[null,1,{"$f":"$C$4+$C$5*B12+$C$6*B12^2","v":1.9},-3.0023215913388399E-2,{"$f":"C12+D12","v":1.8699767840866115},null,null,null,null,null,null,null,null,1,{"$f":"E12","v":1.8699767840866115},0.1,{"$f":"$O$4+$O$5*N12+$O$6*N12^2","v":1.8892538798204364},{"$f":"(O$12:O$65536-Q$12:Q$65536)/P12","v":-0.19277095733824856}]
[null,2,{"$f":"$C$4+$C$5*B13+$C$6*B13^2","v":2.6},-6.9020416049170308E-2,{"$f":"C13+D13","v":2.5309795839508298},null,null,null,null,null,null,null,null,2,{"$f":"E13","v":2.5309795839508298},0.1,{"$f":"$O$4+$O$5*N13+$O$6*N13^2","v":2.5644537362628128},-0.3347415231198303]
[null,3,3.1,-3.2699063012842089E-2,3.067300936987158,null,null,null,null,null,null,null,null,3,3.067300936987158,0.1,3.0496311629903206,0.17669773996837446]
[null,4,3.4,0.16614558262517676,3.5661455826251767,null,null,null,null,null,null,null,null,4,3.5661455826251767,0.1,3.3447861600029607,2.2135942262221597]
[null,5,3.5,-0.14441866369452327,3.3555813363054767,null,null,null,null,null,null,null,null,5,3.3555813363054767,0.1,3.4499187273007323,-0.94337390995255621]
[null,6,3.4,-0.25775807444006205,3.1422419255599379,null,null,null,null,null,null,null,null,6,3.1422419255599379,0.1,3.3650288648836342,-2.2278693932369631]
[null,7,3.0999999999999996,6.9399447966134176E-2,3.1693994479661338,null,null,null,null,null,null,null,null,7,3.1693994479661338,0.1,3.0901165727516693,0.79282875214464532]
[null,8,2.5999999999999996,7.2238890425069258E-3,2.6072238890425066,null,null,null,null,null,null,null,null,8,2.6072238890425066,0.1,2.6251818509048359,-0.17957961862329341]
[null,9,1.9000000000000004,0.22056883608456701,2.1205688360845674,null,null,null,null,null,null,null,null,9,2.1205688360845674,0.1,1.9702246993431345,1.5034413674143288]
[null,10,1,4.4422449718695134E-2,1.0444224497186951,null,null,null,null,null,null,null,null,10,1.0444224497186951,0.1,1.1252451180665641,-0.80822668347868998]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[""]