{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Iteration","Hat Matrix"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":31,"comments":0,"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":"Data","index":0,"n_rows":125,"n_cols":35,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Notation & Variables:",null,null,null,null,null,null,"GLM Bootstrap (Framework):",null,null,null,null,null,null,null,"ODP Bootstrap (Simplified GLM):"]
[]
["Cumulative Data",null,null,null,null,null,null,"Cumulative Data",null,null,null,null,null,null,null,"Fitted Cumulative Data"]
[null,1,2,3,null,null,null,null,1,2,3,null,null,null,null,null,1,2,3]
[1,"c(1,1)","c(1,2)","c(1,3)",null,null,null,1,95,150,180,null,null,null,null,1,{"$f":"R5/J8","v":101.61290322580645},{"$f":"S5/K8","v":150},{"$f":"K5","v":180}]
[2,"c(2,1)","c(2,2)",null,null,null,null,2,115,160,null,null,null,null,null,2,{"$f":"R6/J8","v":108.38709677419354},{"$f":"J6","v":160}]
[3,"c(3,1)",null,null,null,null,null,3,105,null,null,null,null,null,null,3,{"$f":"I7","v":105}]
[null,null,null,null,null,null,null,null,"Factors:",{"$f":"SUM(J5:J6)/SUM(I5:I6)","v":1.4761904761904763},{"$f":"K5/J5","v":1.2}]
["Incremental Data",null,null,null,null,null,null,"Incremental Data",null,null,null,null,null,null,null,"Fitted Incremental Data"]
[null,1,2,3,null,null,null,null,1,2,3,null,null,null,null,null,1,2,3]
[1,"q(1,1)","q(1,2)","q(1,3)",null,null,null,1,{"$f":"I5","v":95},{"$f":"J5-I5","v":55},{"$f":"K5-J5","v":30},null,null,null,null,1,{"$f":"Q5","v":101.61290322580645},{"$f":"R5-Q5","v":48.387096774193552},{"$f":"S5-R5","v":30}]
[2,"q(2,1)","q(2,2)",null,null,null,null,2,{"$f":"I6","v":115},{"$f":"J6-I6","v":45},null,null,null,null,null,2,{"$f":"Q6","v":108.38709677419354},{"$f":"R6-Q6","v":51.612903225806463}]
[3,"q(3,1)",null,null,null,null,null,3,{"$f":"I7","v":105},null,null,null,null,null,null,3,{"$f":"Q7","v":105}]
[]
["Log-Link of Incremental Data",null,null,null,null,null,null,"Log-Link of Incremental Data"]
[null,1,2,3,null,null,null,null,1,2,3]
[1,"ln[q(1,1)]","ln[q(1,2)]","ln[q(1,3)]",null,null,null,1,{"$f":"LN(I11)","v":4.5538768916005408},{"$f":"LN(J11)","v":4.0073331852324712},{"$f":"LN(K11)","v":3.4011973816621555}]
[2,"ln[q(2,1)]","ln[q(2,2)]",null,null,null,null,2,{"$f":"LN(I12)","v":4.7449321283632502},{"$f":"LN(J12)","v":3.8066624897703196}]
[3,"ln[q(3,1)]",null,null,null,null,null,3,{"$f":"LN(I13)","v":4.6539603501575231}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model Parameters from Maximum Likelihood"]
["Design Matrix",null,null,null,null,null,null,null,"α1","α2","α3","β2","β3",null,"X x A",null,null,"Actual",null,"Estimate","Loglikelihood",null,null,"Maximum Likelihood Steps:"]
["X",1,0,0,0,0,null,"A",4.6211657378411939,4.6857046370531856,4.6539571758107972,-0.741933017125322,-0.4780353464875674,null,{"$f":"SUMPRODUCT(B23:F23,$I$23:$M$23)","v":4.6211657378411939},null,"q(1,1)",{"$f":"I11","v":95},"m1,1",{"$f":"EXP(O23)","v":101.6124165526488},{"$f":"IF($F$32=0,-(((R23-T23)^2)/2)-0.5*LN(2*PI()),IF($F$32=1,-T23+LN(T23)*R23-GAMMALN(R23+1),IF($F$32=2,-LN(T23)-R23/T23,-0.5*(LN(2*PI())+3*LN(R23))-(R23-T23)^2/(2*T23^2*R23))))","v":-3.4167303285343564},null,"1)","Enter Starting Values for vector A (Row 23)"]
[null,0,1,0,0,0,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(B24:F24,$I$23:$M$23)","v":4.6857046370531856},null,"q(2,1)",{"$f":"I12","v":115},"m2,1",108.38661863435901,{"$f":"IF($F$32=0,-(((R24-T24)^2)/2)-0.5*LN(2*PI()),IF($F$32=1,-T24+LN(T24)*R24-GAMMALN(R24+1),IF($F$32=2,-LN(T24)-R24/T24,-0.5*(LN(2*PI())+3*LN(R24))-(R24-T24)^2/(2*T24^2*R24))))","v":-3.4899093682574858},null,"2)","Use Solver to Maximize Total Loglikelihood"]
[null,0,0,1,0,0,null,null,null,null,null,null,null,null,4.6539571758107972,null,"q(3,1)",{"$f":"I13","v":105},"m3,1",104.99966669412277,-3.2467123572065475]
[null,1,0,0,1,0,null,null,null,null,null,null,null,null,3.8792327207158719,null,"q(1,2)",{"$f":"J11","v":55},"m1,2",48.387074424717262,-3.3567202337719948]
[null,0,1,0,1,0,null,null,null,null,null,null,null,null,3.9437716199278636,null,"q(2,2)",{"$f":"J12","v":45},"m2,2",51.612898899878232,-3.2671096422516115]
[null,1,0,0,1,1,null,null,null,null,null,null,null,null,3.4011973742283046,null,"q(1,3)",{"$f":"K11","v":30},"m1,3",29.999999776984478,-2.6223148989654987]
[]
["Model Parameters from Iteratively Weighted Least Squares",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(R23:R28,\"<>0\")","v":6},null,"Total",{"$f":"SUM(U23:U28)","v":-19.399496828987495}]
[null,"Value","t-Stat","p-Value",null,"Error Distribution"]
["α1",{"$f":"Iteration!AL49","v":4.6211705273345318},{"$f":"B32/SQRT($O$73*Iteration!W49)","v":31.736017056520673},{"$f":"_xlfn.T.DIST.2T(ABS(C32),$O$72)","v":2.0053215933180442E-2},"z = ",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Normal"]
["α2",{"$f":"Iteration!AL50","v":4.685709048472102},{"$f":"(B33-B32)/SQRT($O$73*Iteration!X50)","v":0.45492481624751452},{"$f":"_xlfn.T.DIST.2T(ABS(C33),$O$72)","v":0.72820037619437616},null,{"$f":"VLOOKUP(F32,ErrorTable,2)","v":"Poisson"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Poisson"]
["α3",{"$f":"Iteration!AL51","v":4.6539603501575231},{"$f":"(B34-B32)/SQRT($O$73*Iteration!Y51)","v":0.20898459783524892},0.86884392452905479,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Gamma"]
["β2",{"$f":"Iteration!AL52","v":-0.74193734472937711},{"$f":"B35/SQRT($O$73*Iteration!Z52)","v":-3.7981891790017799},0.1638920616400866,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Inverse Gaussian"]
["β3",{"$f":"Iteration!AL53","v":-0.47803580094300058},{"$f":"B36/SQRT($O$73*Iteration!AA53)","v":-1.3747946358893852},0.40034938171825457]
[]
[]
[]
[]
["Log-Link of Fitted Values",null,null,null,null,null,null,"Log-Link of Fitted Values"]
[null,1,2,3,null,null,null,null,1,2,3]
[1,"ln[m1,1]","ln[m1,2]","ln[m1,3]",null,null,null,1,{"$f":"B32","v":4.6211705273345318},{"$f":"B32+B35","v":3.8792331826051547},{"$f":"B32+B35+B36","v":3.4011973816621541}]
[2,"ln[m2,1]","ln[m2,2]",null,null,null,null,2,{"$f":"B33","v":4.685709048472102},{"$f":"B33+B35","v":3.9437717037427249}]
[3,"ln[m3,1]",null,null,null,null,null,3,{"$f":"B34","v":4.6539603501575231}]
[]
["Fitted Incremental Values",null,null,null,null,null,null,"Fitted Incremental Values"]
[null,1,2,3,null,null,null,null,1,2,3]
[1,"m1,1","m1,2","m1,3",null,null,null,1,{"$f":"EXP(I43)","v":101.61290322580638},{"$f":"EXP(J43)","v":48.387096774193523},{"$f":"EXP(K43)","v":29.999999999999961}]
[2,"m2,1","m2,2",null,null,null,null,2,{"$f":"EXP(I44)","v":108.38709677419337},{"$f":"EXP(J44)","v":51.612903225806377}]
[3,"m3,1",null,null,null,null,null,3,{"$f":"EXP(I45)","v":104.99999999999997}]
[]
["Unscaled Pearson Residuals",null,null,null,null,null,null,"Unscaled Pearson Residuals",null,null,null,null,null,null,null,"Unscaled Pearson Residuals"]
[null,1,2,3,null,null,null,null,1,2,3,null,null,null,null,null,1,2,3]
[1,"r1,1","r1,2","r1,3",null,null,null,1,{"$f":"(I11-I49)/SQRT(I49^$F$32)","v":-0.65602099300766259},{"$f":"(J11-J49)/SQRT(J49^$F$32)","v":0.9506647363083488},{"$f":"(K11-K49)/SQRT(K49^$F$32)","v":7.1349718815327296E-15},null,null,null,null,1,{"$f":"(I11-Q11)/SQRT(Q11)","v":-0.65602099300766947},{"$f":"(J11-R11)/SQRT(R11)","v":0.95066473630834447},{"$f":"(K11-S11)/SQRT(S11)","v":0}]
[2,"r2,1","r2,2",null,null,null,null,2,{"$f":"(I12-I50)/SQRT(I50^$F$32)","v":0.63518959517030726},{"$f":"(J12-J50)/SQRT(J50^$F$32)","v":-0.92047717288721165},null,null,null,null,null,2,{"$f":"(I12-Q12)/SQRT(Q12)","v":0.63518959517029039},{"$f":"(J12-R12)/SQRT(R12)","v":-0.92047717288722286}]
[3,"r3,1",null,null,null,null,null,3,{"$f":"(I13-I51)/SQRT(I51^$F$32)","v":2.7736748306453291E-15},null,null,null,null,null,null,3,{"$f":"(I13-Q13)/SQRT(Q13)","v":0}]
[]
[null,null,null,null,null,null,null,"Hat Matrix Factors"]
[null,null,null,null,null,null,null,null,1,2,3]
[null,null,null,null,null,null,null,1,{"$f":"'Hat Matrix'!A20","v":2.4507651866304934},{"$f":"'Hat Matrix'!D23","v":1.6911886493289414},{"$f":"'Hat Matrix'!F25","v":0}]
[null,null,null,null,null,null,null,2,{"$f":"'Hat Matrix'!B21","v":2.5311394008759498},{"$f":"'Hat Matrix'!E24","v":1.7466521264389336}]
[null,null,null,null,null,null,null,3,{"$f":"'Hat Matrix'!C22","v":0}]
[]
[null,null,null,null,null,null,null,"Standardized Pearson residuals"]
[null,null,null,null,null,null,null,null,1,2,3]
[null,null,null,null,null,null,null,1,{"$f":"I55*I61","v":-1.6077534113619458},{"$f":"J55*J61","v":1.6077534113619707},{"$f":"K55*K61","v":0}]
[null,null,null,null,null,null,null,2,{"$f":"I56*I62","v":1.6077534113620087},{"$f":"J56*J62","v":-1.6077534113619463}]
[null,null,null,null,null,null,null,3,{"$f":"I57*I63","v":0}]
[]
[null,null,null,null,null,null,null,"Pearson chi-squared statistic",null,null,null,null,null,null,{"$f":"SUMSQ(I55:K57)","v":2.5848710317460348}]
[null,null,null,null,null,null,null,"Degrees of freedom",null,null,{"$f":"COUNT(I11:K13)","v":6},"-",{"$f":"COUNT(B32:B36)","v":5},"=",{"$f":"K72-M72","v":1}]
[null,null,null,null,null,null,null,"Scale Parameter",null,null,null,null,null,null,{"$f":"O71/O72","v":2.5848710317460348}]
[null,null,null,null,null,null,null,"Degrees of Freedom Adjustment Factor",null,null,null,null,null,null,{"$f":"SQRT(K72/O72)","v":2.4494897427831779}]
[]
[null,null,null,null,null,null,null,"Random selections"]
[null,null,null,null,null,null,null,null,1,2,3,null,null,null,null,"Residual Lookup Table"]
[null,null,null,null,null,null,null,1,{"$f":"RANDBETWEEN(1,4)","v":2},{"$f":"RANDBETWEEN(1,4)","v":3},{"$f":"RANDBETWEEN(1,4)","v":1},null,"Recalc will change all values",null,null,1,{"$f":"I67","v":-1.6077534113619458},{"$f":"Q78","v":-1.6077534113619458}]
[null,null,null,null,null,null,null,2,{"$f":"RANDBETWEEN(1,4)","v":2},{"$f":"RANDBETWEEN(1,4)","v":1},null,null,"from this step forward",null,null,2,{"$f":"I68","v":1.6077534113620087},{"$f":"Q79","v":1.6077534113620087}]
[null,null,null,null,null,null,null,3,{"$f":"RANDBETWEEN(1,4)","v":4},null,null,null,null,null,null,3,{"$f":"I69","v":0},{"$f":"Q81","v":1.6077534113619707}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"J67","v":1.6077534113619707},{"$f":"Q82","v":-1.6077534113619463}]
[null,null,null,null,null,null,null,"Random Residuals",null,null,null,null,null,null,null,5,{"$f":"J68","v":-1.6077534113619463}]
[null,null,null,null,null,null,null,null,1,2,3,null,null,null,null,6,{"$f":"K67","v":0}]
[null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(I78,$P$78:$R$81,3)","v":1.6077534113620087},{"$f":"VLOOKUP(J78,$P$78:$R$81,3)","v":1.6077534113619707},{"$f":"VLOOKUP(K78,$P$78:$R$81,3)","v":-1.6077534113619458}]
[null,null,null,null,null,null,null,2,{"$f":"VLOOKUP(I79,$P$78:$R$81,3)","v":1.6077534113620087},{"$f":"VLOOKUP(J79,$P$78:$R$81,3)","v":-1.6077534113619458}]
[null,null,null,null,null,null,null,3,{"$f":"VLOOKUP(I80,$P$78:$R$81,3)","v":-1.6077534113619463}]
[]
["Sample Incremental Triangle",null,null,null,null,null,null,"Sample Incremental Triangle"]
[null,1,2,3,null,null,null,null,1,2,3]
[1,"q'(1,1)","q'(1,2)","q'(1,3)",null,null,null,1,{"$f":"I84*SQRT(I49^$F$32)+I49","v":117.81957623416977},{"$f":"J84*SQRT(J49^$F$32)+J49","v":59.57076364878818},{"$f":"K84*SQRT(K49^$F$32)+K49","v":21.193971896911762}]
[2,"q'(2,1)","q'(2,2)",null,null,null,null,2,{"$f":"I85*SQRT(I50^$F$32)+I50","v":125.12527668321221},{"$f":"J85*SQRT(J50^$F$32)+J50","v":40.062461744516789}]
[3,"q'(3,1)",null,null,null,null,null,3,{"$f":"I86*SQRT(I51^$F$32)+I51","v":88.525429949970516}]
[]
["Sample Cumulative Data",null,null,null,null,null,null,"Sample Cumulative Data"]
[null,1,2,3,null,null,null,null,1,2,3]
[1,"c'(1,1)","c'(1,2)","c'(1,3)",null,null,null,1,{"$f":"I90","v":117.81957623416977},{"$f":"J90+I96","v":177.39033988295796},{"$f":"K90+J96","v":198.58431177986972}]
[2,"c'(2,1)","c'(2,2)",null,null,null,null,2,{"$f":"I91","v":125.12527668321221},{"$f":"J91+I97","v":165.18773842772899}]
[3,"c'(3,1)",null,null,null,null,null,3,{"$f":"I92","v":88.525429949970516}]
[null,null,null,null,null,null,null,null,"Factors:",{"$f":"SUM(J96:J97)/SUM(I96:I97)","v":1.4101063438754438},{"$f":"K96/J96","v":1.1194764715536119}]
[null,null,null,null,null,null,null,null,null,{"$f":"K100*J99","v":1.5785808743570457},{"$f":"K99","v":1.1194764715536119}]
[]
[null,null,null,null,null,null,null,"Projected Cumulative Data"]
[null,null,null,null,null,null,null,null,1,2,3]
[null,null,null,null,null,null,null,1,{"$f":"I96","v":117.81957623416977},{"$f":"J96","v":177.39033988295796},{"$f":"K96","v":198.58431177986972}]
[null,null,null,null,null,null,null,2,{"$f":"I97","v":125.12527668321221},{"$f":"J97","v":165.18773842772899},{"$f":"J105*K99","v":184.92378655899503}]
[null,null,null,null,null,null,null,3,{"$f":"I98","v":88.525429949970516},{"$f":"I106*J99","v":124.83027036675463},{"$f":"J106*K99","v":139.74455061325787}]
[]
[null,null,null,null,null,null,null,"Projected Incremental Data",null,null,null,null,"Point"]
[null,null,null,null,null,null,null,null,1,2,3,null,"Estimate"]
[null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,2,null,null,{"$f":"K105-J105","v":19.736048131266045},null,{"$f":"J97*(K100-1)","v":19.736048131266038}]
[null,null,null,null,null,null,null,3,null,{"$f":"J106-I106","v":36.304840416784117},{"$f":"K106-J106","v":14.914280246503239},null,{"$f":"I98*(J100-1)","v":51.219120663287349}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M111:M112)","v":70.955168794553387}]
[null,null,null,null,null,null,null,"Random Values"]
[null,null,null,null,null,null,null,null,1,2,3]
[null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,2,null,null,{"$f":"RAND()","v":0.42929189504254561}]
[null,null,null,null,null,null,null,3,null,{"$f":"RAND()","v":0.95377390671735574},{"$f":"RAND()","v":0.38745460653366548}]
[]
[null,null,null,null,null,null,null,"Incremental Data w/ Process Variance",null,null,null,null,"Possible"]
[null,null,null,null,null,null,null,null,1,2,3,null,"Outcome"]
[null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,2,null,null,{"$f":"_xlfn.GAMMA.INV(K117,K111/$O$73,$O$73)","v":17.668553555177628},null,{"$f":"K123","v":17.668553555177628}]
[null,null,null,null,null,null,null,3,null,{"$f":"_xlfn.GAMMA.INV(J118,J112/$O$73,$O$73)","v":54.042338520950501},{"$f":"_xlfn.GAMMA.INV(K118,K112/$O$73,$O$73)","v":12.416331031102461},null,{"$f":"SUM(J124:K124)","v":66.458669552052967}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M123:M124)","v":84.127223107230591}]

{"sheet":"Iteration","index":1,"n_rows":54,"n_cols":43,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Iterative Estimation of Sample Data Parameters",null,null,null,null,null,"rho =",{"$f":"Data!F32","v":1},null,"parameters =",{"$f":"2*3-1","v":5}]
["Iteratively Weighted Least Squares -- Iteration 1"]
[null,"y(i)",null,"xb(i)",null,"W(i,i)",null,null,null,null,null,null,"xwx",null,null,null,null,null,"zz(i)",null,"factor",null,"xwx-1",null,null,null,null,null,"aa1(i,j)",null,null,null,null,null,null,"aa2(j)",null,"beta(j)",null,"beta_diff =",{"$f":"SUM(AN5:AN9)","v":2.5485923792545275},"beta_old =",{"$f":"SUM(AL5:AL9)","v":12.742961896272634}]
[null,1,null,1,null,1,2,3,4,5,6,null,1,2,3,4,5,null,1,null,null,null,1,2,3,4,5,null,1,2,3,4,5,6,null,1,null,1,null,1]
[1,{"$f":"Data!I11","v":95},null,{"$f":"IF(B5<0,-LN(-B5),LN(B5))","v":4.5538768916005408},null,{"$f":"IF($A5=F$4,IF($B5<0,-(EXP(-$D5)^(2-$H$1)),IF($B5=0,0,EXP($D5)^(2-$H$1))),0)","v":95},0,0,0,0,0,null,{"$f":"MMULT(TRANSPOSE(DesignMatrix),MMULT(F5:K10,DesignMatrix))","v":180},0,0,85.000000000000014,30.000000000000004,null,{"$f":"IF(B5<0,D5+(B5+EXP(-D5))/-EXP(-D5),IF(B5=0,0,D5+(B5-EXP(D5))/EXP(D5)))","v":4.5538768916005408},null,{"$f":"OFFSET(L4,A5,A5)","v":180},null,{"$f":"MINVERSE(M5:Q9)","v":8.6680105442704311E-3},1.5351217242983415E-3,0,-5.458210575282992E-3,-3.2097999689874382E-3,null,{"$f":"MMULT(W5:AA9,TRANSPOSE(DesignMatrix))","v":8.6680105442704311E-3},1.5351217242983415E-3,0,3.2097999689874391E-3,-3.9230888509846507E-3,8.6736173798840355E-19,null,{"$f":"MMULT(F5:K10,S5:S10)","v":432.61830470205138},null,{"$f":"MMULT(AC5:AH9,AJ5:AJ10)","v":4.6230317952814231},null,{"$f":"AL5/$K$1","v":0.92460635905628463}]
[2,{"$f":"Data!I12","v":115},null,4.7449321283632502,null,0,115.00000000000001,0,0,0,0,null,0,160,0,44.999999999999993,0,null,4.7449321283632502,null,{"$f":"OFFSET(L4,A6,A6)","v":160},null,1.5351217242983415E-3,7.4275081407970235E-3,0,-4.1866956117227478E-3,2.6515738874244065E-3,null,1.5351217242983415E-3,7.4275081407970235E-3,0,-2.6515738874244065E-3,3.2408125290742757E-3,0,null,545.66719476177389,null,4.6878041644529578,null,{"$f":"AL6/$K$1","v":0.93756083289059156}]
[3,{"$f":"Data!I13","v":105},null,4.6539603501575231,null,0,0,104.99999999999997,0,0,0,null,0,0,104.99999999999997,0,0,null,4.6539603501575231,null,{"$f":"OFFSET(L4,A7,A7)","v":104.99999999999997},null,0,0,9.5238095238095264E-3,0,0,null,0,0,9.5238095238095264E-3,0,0,0,null,488.66583676653977,null,4.6539603501575231,null,{"$f":"AL7/$K$1","v":0.93079207003150466}]
[4,{"$f":"Data!J11","v":55},null,4.0073331852324712,null,0,0,0,55.000000000000014,0,0,null,85.000000000000014,44.999999999999993,0,130,30.000000000000004,null,4.0073331852324712,null,{"$f":"OFFSET(L4,A8,A8)","v":130},null,-5.4582105752829929E-3,-4.1866956117227478E-3,0,1.4886028841680884E-2,-9.4278182663978909E-3,null,-5.4582105752829929E-3,-4.1866956117227478E-3,0,9.4278182663978909E-3,1.0699333229958136E-2,0,null,220.40332518778598,null,-0.73514798913411061,null,{"$f":"AL8/$K$1","v":-0.14702959782682212}]
[5,{"$f":"Data!J12","v":45},null,3.8066624897703196,null,0,0,0,0,44.999999999999993,0,null,30.000000000000004,0,0,30.000000000000004,30.000000000000004,null,3.8066624897703196,null,{"$f":"OFFSET(L4,A9,A9)","v":30.000000000000004},null,-3.2097999689874382E-3,2.6515738874244065E-3,0,-9.4278182663978909E-3,4.5970951568718652E-2,null,-3.2097999689874382E-3,2.6515738874244065E-3,0,-1.2637618235385329E-2,-6.7762443789734844E-3,3.3333333333333326E-2,null,171.29981203966435,null,-0.48668642448515653,null,{"$f":"AL9/$K$1","v":-9.7337284897031306E-2}]
[6,{"$f":"Data!K11","v":30},null,3.4011973816621555,null,0,0,0,0,0,30.000000000000004,null,null,null,null,null,null,null,3.4011973816621555,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102.03592144986467]
[]
[]
["Iteratively Weighted Least Squares -- Iteration 2"]
[null,"y(i)",null,"xb(i)",null,"W(i,i)",null,null,null,null,null,null,"xwx",null,null,null,null,null,"zz(i)",null,"factor",null,"xwx-1",null,null,null,null,null,"aa1",null,null,null,null,null,null,"aa2",null,"beta",null,"beta_diff =",{"$f":"SUM(AN16:AN20)","v":-2.0926751631606955E-3},"beta_old =",{"$f":"SUM(AL16:AL20)","v":12.740869221109472}]
[null,1,null,1,null,1,2,3,4,5,6,null,1,2,3,4,5,null,1,null,null,null,1,2,3,4,5,null,1,2,3,4,5,6,null,1,null,1,null,1]
[1,{"$f":"B5","v":95},null,{"$f":"MMULT(DesignMatrix,AL5:AL9)","v":4.6230317952814231},null,{"$f":"IF($A16=F$4,EXP($D16)^(2-$H$1),0)","v":101.80220818454603},0,0,0,0,0,null,{"$f":"MMULT(TRANSPOSE(DesignMatrix),MMULT(F16:K21,DesignMatrix))","v":180.60969923190879},0,0,78.807491047362745,30.000000000000014,null,{"$f":"IF(D16=0,0,D16+(B16-EXP(D16))/EXP(D16))","v":4.556213910818494},null,{"$f":"OFFSET(L15,A16,A16)","v":180.60969923190879},null,{"$f":"MINVERSE(M16:Q20)","v":8.1797948180372115E-3},1.540116197736668E-3,0,-4.7524761536752655E-3,-3.4273186643619447E-3,null,{"$f":"MMULT(W16:AA20,TRANSPOSE(DesignMatrix))","v":8.1797948180372115E-3},1.540116197736668E-3,0,3.427318664361946E-3,-3.2123599559385975E-3,1.3010426069826053E-18,null,{"$f":"MMULT(F16:K21,S16:S21)","v":463.83263708246898},null,{"$f":"MMULT(AC16:AH20,AJ16:AJ21)","v":4.6211719942573444},null,{"$f":"AL16-AQ3/$K$1","v":2.0725796150028177}]
[2,115,null,4.6878041644529578,null,0,108.61441836215687,0,0,0,0,null,0,160.68791800781804,0,52.073499645661165,0,null,4.7465954532535983,null,{"$f":"OFFSET(L15,A17,A17)","v":160.68791800781804},null,1.540116197736668E-3,7.7633594408991462E-3,0,-4.7524761536752672E-3,3.2123599559385997E-3,null,1.540116197736668E-3,7.7633594408991462E-3,0,-3.2123599559385992E-3,3.010883287223879E-3,4.3368086899420177E-19,null,515.54870435559792,null,4.6857114892897949,null,{"$f":"AL17-AQ3/$K$1","v":2.1371191100352682}]
[3,105,null,4.6539603501575231,null,0,0,104.99999999999997,0,0,0,null,0,0,104.99999999999997,0,0,null,4.6539603501575231,null,{"$f":"OFFSET(L15,A18,A18)","v":104.99999999999997},null,0,0,9.5238095238095264E-3,0,0,null,0,0,9.5238095238095264E-3,0,0,0,null,488.66583676653977,null,4.6539603501575231,null,{"$f":"AL18-AQ3/$K$1","v":2.1053679709029964}]
[4,55,null,3.8878838061473124,null,0,0,0,48.807491047362731,0,0,null,78.807491047362745,52.073499645661165,0,130.88099069302393,30.000000000000014,null,4.0147600052665844,null,{"$f":"OFFSET(L15,A19,A19)","v":130.88099069302393},null,-4.7524761536752672E-3,-4.7524761536752672E-3,0,1.4665146450926337E-2,-9.9126702972510711E-3,null,-4.7524761536752672E-3,-4.7524761536752672E-3,0,9.9126702972510694E-3,9.9126702972510694E-3,-1.7347234759768071E-18,null,195.95036301435877,null,-0.74190095168081016,null,{"$f":"AL19-AQ3/$K$1","v":-3.2904933309353366}]
[5,45,null,3.9526561753188472,null,0,0,0,0,52.073499645661165,0,null,30.000000000000014,0,0,30.000000000000014,30.000000000000014,null,3.8168193352025992,null,{"$f":"OFFSET(L15,A20,A20)","v":30.000000000000014},null,-3.4273186643619452E-3,3.2123599559385988E-3,0,-9.9126702972510711E-3,4.6673322294946334E-2,null,-3.4273186643619452E-3,3.2123599559385988E-3,0,-1.3339988961613015E-2,-6.7003103413124723E-3,3.3333333333333319E-2,null,198.75514029922525,null,-0.47807366091437986,null,{"$f":"AL20-AQ3/$K$1","v":-3.0266660401689065}]
[6,30,null,3.4011973816621559,null,0,0,0,0,0,30.000000000000014,null,null,null,null,null,null,null,3.4011973816621555,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102.03592144986472]
[]
[]
["Iteratively Weighted Least Squares -- Iteration 3"]
[null,"y(i)",null,"xb(i)",null,"W(i,i)",null,null,null,null,null,null,"xwx",null,null,null,null,null,"zz(i)",null,"factor",null,"xwx-1",null,null,null,null,null,"aa1",null,null,null,null,null,null,"aa2",null,"beta",null,"beta_diff =",{"$f":"SUM(AN27:AN31)","v":-2.4408091761074502E-6},"beta_old =",{"$f":"SUM(AL27:AL31)","v":12.740866780300294}]
[null,1,null,1,null,1,2,3,4,5,6,null,1,2,3,4,5,null,1,null,null,null,1,2,3,4,5,null,1,2,3,4,5,6,null,1,null,1,null,1]
[1,{"$f":"B16","v":95},null,{"$f":"MMULT(DesignMatrix,AL16:AL20)","v":4.6211719942573444},null,{"$f":"IF($A27=F$4,EXP($D27)^(2-$H$1),0)","v":101.6130522842015},0,0,0,0,0,null,{"$f":"MMULT(TRANSPOSE(DesignMatrix),MMULT(F27:K32,DesignMatrix))","v":180.00198102717295},0,0,78.388928742971444,29.999999999999975,null,{"$f":"IF(D27=0,0,D27+(B27-EXP(D27))/EXP(D27))","v":4.5560912577225787},null,{"$f":"OFFSET(L26,A27,A27)","v":180.00198102717295},null,{"$f":"MINVERSE(M27:Q31)","v":8.2027117771538115E-3},1.536133154976487E-3,0,-4.7618953829694664E-3,-3.4408163941843455E-3,null,{"$f":"MMULT(W27:AA31,TRANSPOSE(DesignMatrix))","v":8.2027117771538115E-3},1.536133154976487E-3,0,3.4408163941843451E-3,-3.2257622279929796E-3,-4.3368086899420177E-19,null,{"$f":"MMULT(F27:K32,S27:S32)","v":462.95833918255778},null,{"$f":"MMULT(AC27:AH31,AJ27:AJ32)","v":4.6211705273297081},null,{"$f":"AL27-AQ14/$K$1","v":2.0729966831078137}]
[2,115,null,4.6857114892897949,null,0,108.38736132765972,0,0,0,0,null,0,160.00226892096566,0,51.614907593305958,0,null,4.7467208043182323,null,{"$f":"OFFSET(L26,A28,A28)","v":160.00226892096566},null,1.5361331549764868E-3,7.7860445265080852E-3,0,-4.7618953829694655E-3,3.2257622279929787E-3,null,1.5361331549764868E-3,7.7860445265080852E-3,0,-3.2257622279929787E-3,3.0241491435386196E-3,0,null,514.48454293915984,null,4.6857090484806161,null,{"$f":"AL28-AQ14/$K$1","v":2.1375352042587217}]
[3,105,null,4.6539603501575231,null,0,0,104.99999999999997,0,0,0,null,0,0,104.99999999999997,0,0,null,4.6539603501575231,null,{"$f":"OFFSET(L26,A29,A29)","v":104.99999999999997},null,0,0,9.5238095238095264E-3,0,0,null,0,0,9.5238095238095264E-3,0,0,0,null,488.66583676653977,null,4.6539603501575231,null,{"$f":"AL29-AQ14/$K$1","v":2.1057865059356287}]
[4,55,null,3.8792710425765344,null,0,0,0,48.388928742971466,0,0,null,78.388928742971444,51.614907593305958,0,130.0038363362774,29.999999999999975,null,4.0158946758903591,null,{"$f":"OFFSET(L26,A30,A30)","v":130.0038363362774},null,-4.7618953829694655E-3,-4.7618953829694664E-3,0,1.4761511764058636E-2,-9.9996163810891683E-3,null,-4.7618953829694655E-3,-4.7618953829694664E-3,0,9.99961638108917E-3,9.99961638108917E-3,1.7347234759768071E-18,null,194.32484131093707,null,-0.74193734399548084,null,{"$f":"AL30-AQ14/$K$1","v":-3.2901111882173755}]
[5,45,null,3.9438105376089849,null,0,0,0,0,51.614907593305958,0,null,29.999999999999975,0,0,29.999999999999975,29.999999999999975,null,3.8156516799892559,null,{"$f":"OFFSET(L26,A31,A31)","v":29.999999999999975},null,-3.4408163941843459E-3,3.2257622279929792E-3,0,-9.9996163810891683E-3,4.6773766108606875E-2,null,-3.4408163941843459E-3,3.2257622279929792E-3,0,-1.3440432775273514E-2,-6.7738541530961895E-3,3.3333333333333361E-2,null,196.94450887088809,null,-0.47803580167207027,null,{"$f":"AL31-AQ14/$K$1","v":-3.0262096458939647}]
[6,30,null,3.4011973816621546,null,0,0,0,0,0,29.999999999999975,null,null,null,null,null,null,null,3.4011973816621555,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102.03592144986457]
[]
[]
["Iteratively Weighted Least Squares -- Iteration 4"]
[null,"y(i)",null,"xb(i)",null,"W(i,i)",null,null,null,null,null,null,"xwx",null,null,null,null,null,"zz(i)",null,"factor",null,"xwx-1",null,null,null,null,null,"aa1",null,null,null,null,null,null,"aa2",null,"beta",null,"beta_diff =",{"$f":"SUM(AN38:AN42)","v":-8.5118578851961502E-12},"beta_old =",{"$f":"SUM(AL38:AL42)","v":12.740866780291784}]
[null,1,null,1,null,1,2,3,4,5,6,null,1,2,3,4,5,null,1,null,null,null,1,2,3,4,5,null,1,2,3,4,5,6,null,1,null,1,null,1]
[1,{"$f":"B27","v":95},null,{"$f":"MMULT(DesignMatrix,AL27:AL31)","v":4.6211705273297081},null,{"$f":"IF($A38=F$4,EXP($D38)^(2-$H$1),0)","v":101.61290322531623},0,0,0,0,0,null,{"$f":"MMULT(TRANSPOSE(DesignMatrix),MMULT(F38:K43,DesignMatrix))","v":180.00000003478749},0,0,78.387096809471259,30.000000000000043,null,{"$f":"IF(D38=0,0,D38+(B38-EXP(D38))/EXP(D38))","v":4.5560911622548534},null,{"$f":"OFFSET(L37,A38,A38)","v":180.00000003478749},null,{"$f":"MINVERSE(M38:Q42)","v":8.202764976172932E-3},1.5360983110523753E-3,0,-4.7619047618949585E-3,-3.4408602142779769E-3,null,{"$f":"MMULT(W38:AA42,TRANSPOSE(DesignMatrix))","v":8.202764976172932E-3},1.5360983110523753E-3,0,3.4408602142779734E-3,-3.2258064508425832E-3,-3.4694469519536142E-18,null,{"$f":"MMULT(F38:K43,S38:S43)","v":462.95765035592098},null,{"$f":"MMULT(AC38:AH42,AJ38:AJ43)","v":4.6211705273345318},null,{"$f":"AL38-AQ25/$K$1","v":2.0729971712744728}]
[2,115,null,4.6857090484806161,null,0,108.38709677511619,0,0,0,0,null,0,160.00000003924052,0,51.61290326412432,0,null,4.7467209532334893,null,{"$f":"OFFSET(L37,A39,A39)","v":160.00000003924052},null,1.5360983110523753E-3,7.7860983095195428E-3,0,-4.7619047618949568E-3,3.2258064508425802E-3,null,1.5360983110523753E-3,7.7860983095195428E-3,0,-3.2258064508425815E-3,3.024193547624586E-3,-1.3010426069826053E-18,null,514.48330332259002,null,4.6857090484721038,null,{"$f":"AL39-AQ25/$K$1","v":2.1375356924120448}]
[3,105,null,4.6539603501575231,null,0,0,104.99999999999997,0,0,0,null,0,0,104.99999999999997,0,0,null,4.6539603501575231,null,{"$f":"OFFSET(L37,A40,A40)","v":104.99999999999997},null,0,0,9.5238095238095264E-3,0,0,null,0,0,9.5238095238095264E-3,0,0,0,null,488.66583676653977,null,4.6539603501575231,null,{"$f":"AL40-AQ25/$K$1","v":2.1057869940974641}]
[4,55,null,3.8792331833342271,null,0,0,0,48.387096809471217,0,0,null,78.387096809471259,51.61290326412432,0,130.00000007359557,30.000000000000043,null,4.0158998491721825,null,{"$f":"OFFSET(L37,A41,A41)","v":130.00000007359557},null,-4.7619047618949568E-3,-4.7619047618949559E-3,0,1.4761904754535406E-2,-9.9999999926404445E-3,null,-4.7619047618949568E-3,-4.7619047618949559E-3,0,9.999999992640448E-3,9.9999999926404497E-3,3.4694469519536142E-18,null,194.31773477903525,null,-0.74193734472937589,null,{"$f":"AL41-AQ25/$K$1","v":-3.2901107007894348}]
[5,45,null,3.943771704485135,null,0,0,0,0,51.61290326412432,0,null,30.000000000000043,0,0,30.000000000000043,30.000000000000043,null,3.8156467038378477,null,{"$f":"OFFSET(L37,A42,A42)","v":30.000000000000043},null,-3.4408602142779765E-3,3.2258064508425802E-3,0,-9.9999999926404445E-3,4.6774193540251703E-2,null,-3.4408602142779765E-3,3.2258064508425802E-3,0,-1.3440860206918421E-2,-6.7741935417978648E-3,3.3333333333333284E-2,null,196.93660421525766,null,-0.47803580094299969,null,{"$f":"AL42-AQ25/$K$1","v":-3.0262091570030587}]
[6,30,null,3.4011973816621568,null,0,0,0,0,0,30.000000000000043,null,null,null,null,null,null,null,3.4011973816621555,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102.03592144986482]
[]
[]
["Iteratively Weighted Least Squares -- Iteration 5"]
[null,"y(i)",null,"xb(i)",null,"W(i,i)",null,null,null,null,null,null,"xwx",null,null,null,null,null,"zz(i)",null,"factor",null,"xwx-1",null,null,null,null,null,"aa1",null,null,null,null,null,null,"aa2",null,"beta",null,"beta_diff =",{"$f":"SUM(AN49:AN53)","v":-5.3290705182007514E-15},"beta_old =",{"$f":"SUM(AL49:AL53)","v":12.740866780291777}]
[null,1,null,1,null,1,2,3,4,5,6,null,1,2,3,4,5,null,1,null,null,null,1,2,3,4,5,null,1,2,3,4,5,6,null,1,null,1,null,1]
[1,{"$f":"B38","v":95},null,{"$f":"MMULT(DesignMatrix,AL38:AL42)","v":4.6211705273345318},null,{"$f":"IF($A49=F$4,EXP($D49)^(2-$H$1),0)","v":101.61290322580638},0,0,0,0,0,null,{"$f":"MMULT(TRANSPOSE(DesignMatrix),MMULT(F49:K54,DesignMatrix))","v":180},0,0,78.387096774193623,30.000000000000028,null,{"$f":"IF(D49=0,0,D49+(B49-EXP(D49))/EXP(D49))","v":4.5560911622551679},null,{"$f":"OFFSET(L48,A49,A49)","v":180},null,{"$f":"MINVERSE(M49:Q53)","v":8.2027649769585275E-3},1.5360983102918613E-3,0,-4.7619047619047649E-3,-3.4408602150537643E-3,null,{"$f":"MMULT(W49:AA53,TRANSPOSE(DesignMatrix))","v":8.2027649769585275E-3},1.5360983102918613E-3,0,3.4408602150537626E-3,-3.2258064516129037E-3,-1.7347234759768071E-18,null,{"$f":"MMULT(F49:K54,S49:S54)","v":462.95765035818607},null,{"$f":"MMULT(AC49:AH53,AJ49:AJ54)","v":4.6211705273345318},null,{"$f":"AL49-AQ36/$K$1","v":2.072997171276175}]
[2,115,null,4.6857090484721038,null,0,108.38709677419357,0,0,0,0,null,0,160.00000000000011,0,51.612903225806534,0,null,4.746720953234008,null,{"$f":"OFFSET(L48,A50,A50)","v":160.00000000000011},null,1.5360983102918611E-3,7.7860983102918556E-3,0,-4.7619047619047641E-3,3.2258064516129028E-3,null,1.5360983102918611E-3,7.7860983102918556E-3,0,-3.2258064516129028E-3,3.0241935483870915E-3,0,null,514.48330331826674,null,4.685709048472102,null,{"$f":"AL50-AQ36/$K$1","v":2.1375356924137452}]
[3,105,null,4.6539603501575231,null,0,0,104.99999999999997,0,0,0,null,0,0,104.99999999999997,0,0,null,4.6539603501575231,null,{"$f":"OFFSET(L48,A51,A51)","v":104.99999999999997},null,0,0,9.5238095238095264E-3,0,0,null,0,0,9.5238095238095264E-3,0,0,0,null,488.66583676653977,null,4.6539603501575231,null,{"$f":"AL51-AQ36/$K$1","v":2.1057869940991663}]
[4,55,null,3.879233182605156,null,0,0,0,48.387096774193587,0,0,null,78.387096774193623,51.612903225806534,0,130.00000000000014,30.000000000000028,null,4.0158998492718219,null,{"$f":"OFFSET(L48,A52,A52)","v":130.00000000000014},null,-4.7619047619047649E-3,-4.7619047619047641E-3,0,1.4761904761904756E-2,-9.9999999999999898E-3,null,-4.7619047619047649E-3,-4.7619047619047641E-3,0,9.9999999999999915E-3,9.9999999999999915E-3,1.7347234759768071E-18,null,194.31773464218509,null,-0.74193734472937711,null,{"$f":"AL52-AQ36/$K$1","v":-3.2901107007877339}]
[5,45,null,3.943771703742728,null,0,0,0,0,51.612903225806534,0,null,30.000000000000028,0,0,30.000000000000028,30.000000000000028,null,3.8156467037427264,null,{"$f":"OFFSET(L48,A53,A53)","v":30.000000000000028},null,-3.4408602150537647E-3,3.2258064516129024E-3,0,-9.9999999999999898E-3,4.6774193548387057E-2,null,-3.4408602150537647E-3,3.2258064516129024E-3,0,-1.3440860215053755E-2,-6.774193548387087E-3,3.3333333333333298E-2,null,196.93660406414102,null,-0.47803580094300058,null,{"$f":"AL53-AQ36/$K$1","v":-3.0262091570013574}]
[6,30,null,3.4011973816621563,null,0,0,0,0,0,30.000000000000028,null,null,null,null,null,null,null,3.4011973816621555,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102.03592144986476]

{"sheet":"Hat Matrix","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Weight Matrix"]
[{"$f":"Data!I49","v":101.61290322580638},0,0,0,0,0]
[0,{"$f":"Data!I50","v":108.38709677419337},0,0,0,0]
[0,0,{"$f":"Data!I51","v":104.99999999999997},0,0,0]
[0,0,0,{"$f":"Data!J49","v":48.387096774193523},0,0]
[0,0,0,0,{"$f":"Data!J50","v":51.612903225806377},0]
[0,0,0,0,0,{"$f":"Data!K49","v":29.999999999999961}]
[]
[]
["Hat Matrix"]
[{"$f":"MMULT(MMULT(MMULT(DesignMatrix,MINVERSE(MMULT(MMULT(TRANSPOSE(DesignMatrix),WeightMatrix),DesignMatrix))),TRANSPOSE(DesignMatrix)),WeightMatrix)","v":0.83350676378772104},0.16649323621227882,0,0.16649323621227879,-0.16649323621227885,-1.3010426069826036E-17]
[0.15608740894901152,0.84391259105098848,0,-0.15608740894901155,0.15608740894901157,-1.3010426069826036E-17]
[0,0,1,0,0,0]
[0.34963579604578549,-0.34963579604578549,0,0.65036420395421457,0.34963579604578549,1.0408340855860829E-16]
[-0.32778355879292409,0.32778355879292426,0,0.32778355879292426,0.6722164412070758,5.2041704279304145E-17]
[4.4067572171991438E-17,-4.7005410316790823E-17,0,2.0984558177138785E-17,-2.238352872228135E-17,0.99999999999999989]
[]
[]
["Hat Matrix Factors"]
[{"$f":"IF(A11=1,0,1/SQRT(1-A11))","v":2.4507651866304934}]
[null,{"$f":"IF(B12=1,0,1/SQRT(1-B12))","v":2.5311394008759498}]
[null,null,{"$f":"IF(C13=1,0,1/SQRT(1-C13))","v":0}]
[null,null,null,{"$f":"IF(D14=1,0,1/SQRT(1-D14))","v":1.6911886493289414}]
[null,null,null,null,{"$f":"IF(E15=1,0,1/SQRT(1-E15))","v":1.7466521264389336}]
[null,null,null,null,null,{"$f":"IF(F16=1,0,1/SQRT(1-F16))","v":0}]