{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":35,"comments":1,"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":"Sheet1","index":0,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[35,1,35,5],[3,6,3,8],[3,10,3,14],[9,4,9,6],[9,7,9,9],[9,10,9,14],[14,1,14,5],[15,10,15,12],[19,1,19,8],[19,10,19,12],[20,3,20,5],[20,7,20,8]]}
["Linear regression algebra",null,null,null,null,"model:"]
["Hit [F9] to generate new data set for analysis.",null,null,null,null,"my = a1 + a2 x + a3 x2"]
[]
[null,"x","y","sy","yfit = [Jya] a","y - yfit","[Jya]ij = dyifit/daj",null,null,null,"[s2y]"]
[null,1,{"$f":"MMULT(G5:I9,B11:B13)+NORMINV(RAND(),0,D5)","v":1.8407111542912016},0.2,{"$f":"MMULT(G5:I9,C11:C13)","v":1.8396993643523922},{"$f":"C5-E5","v":1.0117899388093488E-3},1,{"$f":"B5","v":1},{"$f":"B5^2","v":1},null,{"$f":"_xlfn.MUNIT(5)*D5:D9^2","v":4.0000000000000008E-2},0,0,0,0]
[null,2,2.1493515096929983,0.2,2.1514720449081026,{"$f":"C6-E6","v":-2.1205352151043577E-3},1,{"$f":"B6","v":2},{"$f":"B6^2","v":4},null,0,4.0000000000000008E-2,0,0,0]
[null,3,2.1541293551791352,0.2,2.1538384891662639,{"$f":"C7-E7","v":2.9086601287131586E-4},1,{"$f":"B7","v":3},{"$f":"B7^2","v":9},null,0,0,4.0000000000000008E-2,0,0]
[null,4,1.8485314109916173,0.2,1.8467986971268764,{"$f":"C8-E8","v":1.7327138647409424E-3},1,{"$f":"B8","v":4},{"$f":"B8^2","v":16},null,0,0,0,4.0000000000000008E-2,0]
[null,5,1.2294378341888379,0.2,1.2303526687899384,{"$f":"C9-E9","v":-9.1483460110053372E-4},1,{"$f":"B9","v":5},{"$f":"B9^2","v":25},null,0,0,0,0,4.0000000000000008E-2]
[null,"a","a = [Jay] †y","sa","[s2a] = [X]-1",null,null,"Correlation matrix",null,null,"[s2y]-1"]
[null,1,{"$f":"MMULT(B16:F18,C5:C9)","v":1.2185204474991331},{"$f":"SQRT(MMULT(_xlfn.MUNIT(ROWS(E11:G13))*E11:G13,ROW(E11:G13)^0))","v":0.42895221179054699},{"$f":"MINVERSE(K17:M19)","v":0.1840000000000023},-0.13200000000000214,2.0000000000000365E-2,{"$f":"E11:G13/TRANSPOSE(D11:D13)/D11:D13","v":1.0000000000000002},-0.94137625756762311,0.87227837598864999,{"$f":"_xlfn.MUNIT(5)*1/D5:D9^2","v":24.999999999999996},0,0,0,0]
[null,1,0.77588203500203368,0.32689010822774156,-0.13200000000000195,0.10685714285714459,-1.7142857142857439E-2,-0.94137625756762178,1,-0.98110491025159352,0,24.999999999999996,0,0,0]
[null,-0.2,-0.15470311814877449,5.3452248382485329E-2,2.000000000000032E-2,-1.7142857142857425E-2,2.8571428571429053E-3,0.87227837598864799,-0.98110491025159274,0.99999999999999989,0,0,24.999999999999996,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,24.999999999999996,0]
[null,"[Jay] †= [X] -1[Jya]T [s2y]-1",null,null,null,null,null,"c2","c2n",null,0,0,0,0,24.999999999999996]
[null,{"$f":"MMULT(E11:G13,MMULT(TRANSPOSE(G5:I9),K11:O15))","v":1.8000000000000123},-1.3766765505351941E-14,-0.80000000000002025,-0.60000000000001208,0.60000000000001563,null,{"$f":"MMULT(TRANSPOSE(F5:F9),MMULT(K11:O15,F5:F9))","v":2.3610528001633577E-4},{"$f":"H16/2","v":1.1805264000816788E-4},null,"[X] = [Jya] T[s2y]-1 [Jya]"]
[null,-1.0571428571428698,0.32857142857143673,0.85714285714287008,0.5285714285714338,-0.65714285714287257,null,null,null,null,{"$f":"MMULT(TRANSPOSE(G5:I9),MMULT(K11:O15,G5:I9))","v":124.99999999999999},374.99999999999994,1374.9999999999998]
[null,0.14285714285714496,-7.1428571428572729E-2,-0.14285714285714524,-7.1428571428572507E-2,0.14285714285714568,null,null,null,null,374.99999999999994,1374.9999999999998,5624.9999999999991]
[null,null,null,null,null,null,null,null,null,null,1374.9999999999998,5624.9999999999991,24474.999999999993]
[null,"Calculation of yfit and its uncertainty from x = 0 to 6 in steps of 0.5"]
[null,"x","yfit","[Jya]",null,null,"syfit","yfit ± syfit",null,null,"Excel's regr. results"]
[null,0,{"$f":"MMULT(D22:F34,C11:C13)","v":1.2185204474991331},1,{"$f":"B22","v":0},{"$f":"B22^2","v":0},{"$f":"SQRT(MMULT(_xlfn.MUNIT(13)*B37:N49,ROW(1:13)^0))","v":0.42895221179054699},{"$f":"C22-G22","v":0.78956823570858614},{"$f":"C22+G22","v":1.6474726592896802},"a",{"$f":"LINEST(C5:C9,G5:I9,FALSE,TRUE)","v":-0.15470311814877186},0.77588203500202002,1.2185204474991886]
[null,0.5,1.5677856854629562,1,0.5,0.25,0.2908730700101741,1.2769126154527821,1.8586587554731302,"sa",5.807695387727318E-4,3.5517274414035918E-3,4.6606529329600577E-3]
[null,1,1.8396993643523922,1,1,1,0.18822478962286432,1.6514745747295279,2.0279241539752566,"sa/cn",{"$f":"K23/SQRT($I$16)","v":5.3452248382492615E-2},{"$f":"L23/SQRT($I$16)","v":0.32689010822778625},{"$f":"M23/SQRT($I$16)","v":0.4289522117906065}]
[null,1.5,2.0342614841674411,1,1.5,2.25,0.13106704936242106,1.90319443480502,2.1653285335298622]
[null,2,2.1514720449081026,1,2,4,0.12188988004400859,2.0295821648640939,2.2733619249521113]
[null,2.5,2.1913310465743767,1,2.5,6.25,0.13322912594474215,2.0581019206296345,2.324560172519119]
[null,3,2.1538384891662639,1,3,9,0.13938641048743414,2.0144520786788296,2.2932248996536981]
[null,3.5,2.0389943726837636,1,3.5,12.25,0.1332291259447429,1.9057652467390207,2.1722234986285063]
[null,4,1.8467986971268764,1,4,16,0.121889880044009,1.7249088170828675,1.9686885771708853]
[null,4.5,1.5772514624956009,1,4.5,20.25,0.13106704936242072,1.4461844131331802,1.7083185118580215]
[null,5,1.2303526687899384,1,5,25,0.18822478962286343,1.0421278791670749,1.4185774584128019]
[null,5.5,0.80610231600988946,1,5.5,30.25,0.29087307001017459,0.51522924599971487,1.0969753860200639]
[null,6,0.3045004041554531,1,6,36,0.42895221179054699,-0.12445180763509389,0.73345261594600009]
[]
[null,"[s2y] = [Jya]T [s2a][Jya]"]
[null,{"$f":"MMULT(D22:F34,MMULT($E$11:$G$13,TRANSPOSE(D22:F34)))","v":0.1840000000000023},0.12300000000000132,7.2000000000000522E-2,3.0999999999999889E-2,-5.2735593669694936E-16,-2.1000000000000768E-2,-3.2000000000000889E-2,-3.3000000000000779E-2,-2.4000000000000465E-2,-4.9999999999999489E-3,2.4000000000000687E-2,6.300000000000161E-2,0.11200000000000243]
[null,0.1230000000000014,8.4607142857143644E-2,5.2285714285714581E-2,2.6035714285714173E-2,5.8571428571424873E-3,-8.2500000000005347E-3,-1.6285714285714896E-2,-1.8250000000000533E-2,-1.4142857142857485E-2,-3.9642857142857361E-3,1.2285714285714632E-2,3.4607142857143842E-2,6.3000000000001416E-2]
[null,7.2000000000000675E-2,5.228571428571463E-2,3.5428571428571531E-2,2.1428571428571314E-2,1.0285714285714048E-2,1.9999999999996548E-3,-3.4285714285718083E-3,-6.0000000000003245E-3,-5.7142857142859493E-3,-2.571428571428655E-3,3.4285714285714891E-3,1.2285714285714761E-2,2.400000000000059E-2]
[null,3.1000000000000097E-2,2.6035714285714291E-2,2.1428571428571377E-2,1.7178571428571317E-2,1.3285714285714154E-2,9.7499999999998005E-3,6.5714285714283741E-3,3.7499999999998472E-3,1.2857142857141401E-3,-8.2142857142870548E-4,-2.5714285714287417E-3,-3.9642857142856355E-3,-5.00000000000006E-3]
[null,-3.1918911957973251E-16,5.8571428571426165E-3,1.0285714285714134E-2,1.3285714285714179E-2,1.4857142857142805E-2,1.4999999999999902E-2,1.3714285714285651E-2,1.0999999999999982E-2,6.8571428571427839E-3,1.2857142857141124E-3,-5.7142857142860604E-3,-1.4142857142857346E-2,-2.4000000000000521E-2]
[null,-2.1000000000000546E-2,-8.2500000000003959E-3,1.9999999999997936E-3,9.7499999999999011E-3,1.5000000000000003E-2,1.7749999999999967E-2,1.8000000000000023E-2,1.5750000000000083E-2,1.0999999999999982E-2,3.7499999999997986E-3,-6.0000000000004633E-3,-1.8250000000000377E-2,-3.3000000000000806E-2]
[null,-3.2000000000000667E-2,-1.6285714285714722E-2,-3.4285714285716695E-3,6.5714285714284816E-3,1.3714285714285745E-2,1.7999999999999974E-2,1.9428571428571489E-2,1.8000000000000141E-2,1.3714285714285734E-2,6.5714285714283532E-3,-3.428571428571961E-3,-1.6285714285714709E-2,-3.2000000000000917E-2]
[null,-3.3000000000000668E-2,-1.8250000000000377E-2,-6.0000000000001996E-3,3.7499999999999201E-3,1.1000000000000031E-2,1.5749999999999938E-2,1.8000000000000058E-2,1.7750000000000168E-2,1.5000000000000041E-2,9.7499999999997762E-3,1.9999999999994605E-3,-8.2500000000003681E-3,-2.1000000000000824E-2]
[null,-2.400000000000041E-2,-1.4142857142857401E-2,-5.7142857142858522E-3,1.2857142857142234E-3,6.8571428571428672E-3,1.0999999999999871E-2,1.3714285714285707E-2,1.5000000000000152E-2,1.4857142857142902E-2,1.3285714285714068E-2,1.0285714285713787E-2,5.857142857142672E-3,-5.5511151231257827E-16]
[null,-5.0000000000000044E-3,-3.9642857142857812E-3,-2.5714285714286134E-3,-8.2142857142861181E-4,1.2857142857142442E-3,3.7499999999997535E-3,6.5714285714284781E-3,9.7500000000001058E-3,1.3285714285714317E-2,1.7178571428571227E-2,2.1428571428571033E-2,2.6035714285714356E-2,3.0999999999999917E-2]
[null,2.4000000000000576E-2,1.2285714285714566E-2,3.4285714285715585E-3,-2.571428571428596E-3,-5.7142857142858244E-3,-6.0000000000003939E-3,-3.4285714285716973E-3,2.0000000000000295E-3,1.0285714285714287E-2,2.1428571428571255E-2,3.5428571428571198E-2,5.2285714285714768E-2,7.2000000000000508E-2]
[null,6.3000000000001166E-2,3.4607142857143613E-2,1.2285714285714594E-2,-3.9642857142857188E-3,-1.414285714285736E-2,-1.8250000000000627E-2,-1.6285714285714764E-2,-8.2500000000001183E-3,5.8571428571428108E-3,2.6035714285714152E-2,5.2285714285714241E-2,8.4607142857143935E-2,0.12300000000000144]
[null,0.1120000000000021,6.3000000000001222E-2,2.4000000000000521E-2,-4.9999999999999767E-3,-2.4000000000000341E-2,-3.3000000000000862E-2,-3.2000000000000722E-2,-2.1000000000000268E-2,-1.1102230246251565E-16,3.0999999999999917E-2,7.200000000000023E-2,0.12300000000000166,0.18400000000000227]