{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["User input","M+ME Correction"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"User input","index":0,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,1,6,4],[12,7,12,14],[6,7,6,11],[1,1,1,15],[2,1,2,15],[4,2,4,15]]}
[]
[null,"Multicollinearity + Measurement Error Correction Application "]
[null,"For correcting VIF, standard deviations, path estimates, and t-values in regression-based statistical analysis."]
[]
[null,null,"(Based on Goodhue, Lewis, and Thompson, \"A Multicollinearity and Measurement Error Statistical Blind Spot: Correcting For Excessive False Positives in Regression and PLS\", MIS Quarterly, September 2017)"]
[]
[null,"User Input",null,null,null,null,null,"Corrected Results"]
[null,"Enter all values to view results.",null,null,null,null,null,"path","estimate","std dev","t-stat","prob"]
[null,null,"r12",0.6,null,null,null,"b1",{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!N16)","v":0.56635569799682584},{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!$R$16)","v":0.24657044017423516},{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!S16)","v":2.2969326639341658},{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!T16)","v":2.3818838648405644E-2},null,"underlying r12",{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!N9)","v":0.70710678118654746}]
[null,null,"b1",0.46200000000000002,null,null,null,"b2",{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!P17)","v":0.20905209076560791},{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!$R$17)","v":0.13501391651467301},{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!S17)","v":1.548374391042042},{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!T17)","v":0.12485720297521286},null,"combined a",{"$f":"IF(OR($D$9=\"\",$D$10=\"\",$D$11=\"\",$D$12=\"\",$D$13=\"\",$D$14=\"\",$D$15=\"\",$D$16=\"\",$D$17=\"\"),\"\",'M+ME Correction'!N10)","v":0.84852813742385713}]
[null,null,"b2",0.24]
[null,null,"t b1",2.89]
[null,null,"t b2",2.9,null,null,null,"Key"]
[null,null,"a X1",0.9,null,null,null,null,"r12 =","overt correlation, independent variables"]
[null,null,"a X2",0.8,null,null,null,null,"b1 , b2 =","standardized path coefficients of the two correlated"]
[null,null,"n",100,null,null,null,null,null,"independent variables"]
[null,null,"k",4,null,null,null,null,"t b1 , t b2 =","t-statistics for the B1 and B2 path coefficients"]
[null,null,null,null,null,null,null,null,"a X1 , a X2 =","reliabilities for the independent variables. The combined"]
[null,null,null,null,null,null,null,null,null," reliability is: (aX1*aX2)1/2"]
[null,null,null,null,null,null,null,null,"n =","sample size"]
[null,null,null,null,null,null,null,null,"k =","# of independent variables in the regression"]

{"sheet":"M+ME Correction","index":1,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,3,12,8],[6,2,6,10],[12,9,12,19]]}
[]
[]
[null,"M+ME Correction"]
[null,null,"This sheet uses data from 'User input' to correct the VIF, standard deviation, path estimates, and t-values for ksi1 and ksi2."]
[]
[]
[null,null,"Data entered by the user from 'User input'"]
[null,null,null,null,null,"tcalc","tcalc","alpha","alpha"]
[null,null,"n","b1^","b2^","b1^","b2^","X1","X2","overt r12","k",null,"underlying r12",{"$f":"J10/N10","v":0.70710678118654746}]
[null,null,{"$f":"'User input'!D16","v":100},{"$f":"'User input'!D10","v":0.46200000000000002},{"$f":"'User input'!D11","v":0.24},{"$f":"'User input'!D12","v":2.89},{"$f":"'User input'!D13","v":2.9},{"$f":"'User input'!D14","v":0.9},{"$f":"'User input'!D15","v":0.8},{"$f":"'User input'!D9","v":0.6},{"$f":"'User input'!D17","v":4},null,"combined alpha",{"$f":"(H10*I10)^0.5","v":0.84852813742385713}]
[]
[]
[null,null,null,"Make VIF Corrections                                                                                         (Determining the StDev of bi^, Using Equations A1-1 and A1-2)",null,null,null,null,null,"Correct the Path Estimates and Determine the  M+ME Corrected Path StDevs                                                                       (Using Equations A1-17, A1-18 and A1-19)"]
[null,null,null,"Overt SD","Overt Var","VIFOvert","VIFCorrect","VIFCorrected Var","VIFCorrected SD","Constant C12",null,null,null,null,null,null,null,"M+ME Corrected  SD","M+ME Corrected t-Stat","M+ME Corrected p-value"]
[null,null,null,null,null,"1/(1-r122)","1/(1- (r122/(a1*a2)) )","VarOvert* VIFcorrect / VIFOvert","(VarCorrect).5"," (1-a)/       (1-r122)","1-2C+C2     -C2r122","(1-C)            /                    (1-2C+C2-C2r122)","(C*r12)            /                    (1-2C+C2-C2r122)","b1= [col L] *b1^-[col M] *b2^","Var(b1) =[col L]2 * V(b1^) + [col M]2 *V(b2^)","b2= [col L] *b2^-[col M] *b1^","Var(b2) =[col L]2 * V(b2^) + [col M]2 *V(b1^)"]
[null,null,"b1",{"$f":"D10/F10","v":0.15986159169550174},{"$f":"D16*D16","v":2.5555728499419311E-2},{"$f":"1/(1-J10^2)","v":1.5625},{"$f":"1/(1-(J10^2)/(H10*I10))","v":2},{"$f":"E16*G16/F16","v":3.271133247925672E-2},{"$f":"H16^0.5","v":0.18086274486266296},null,null,null,null,{"$f":"$L$17*D10-$M$17*E10","v":0.56635569799682584},{"$f":"$L$17^2*H16+$M$17^2*H17","v":6.0796981967716074E-2},null,null,{"$f":"O16^0.5","v":0.24657044017423516},{"$f":"N16/R16","v":2.2969326639341658},{"$f":"TDIST(ABS(S16), (C10-K10-1), 2)","v":2.3818838648405644E-2}]
[null,null,"b2",{"$f":"E10/G10","v":8.2758620689655171E-2},{"$f":"D17*D17","v":6.8489892984542212E-3},{"$f":"1/(1-J10^2)","v":1.5625},{"$f":"1/(1-(J10*J10/(H10*I10)))","v":2},{"$f":"E17*G17/F17","v":8.7667063020214035E-3},{"$f":"H17^0.5","v":9.3630691026080778E-2},{"$f":"(1-POWER(H10*I10,0.5)) / (1-J10^2)","v":0.23667478527522323},{"$f":"1-2*J17+(J17)^2-(J17*J10)^2","v":0.56250000000000033},{"$f":"(1-J17)/K17","v":1.3570226039551578},{"$f":"J17*J10/K17","v":0.25245310429357132},null,null,{"$f":"$L$17*E10-$M$17*D10","v":0.20905209076560791},{"$f":"$L$17^2*H17+$M$17^2*H16","v":1.8228757652631097E-2},{"$f":"Q17^0.5","v":0.13501391651467301},{"$f":"P17/R17","v":1.548374391042042},{"$f":"TDIST(ABS(S17), (C10-K10-1),2)","v":0.12485720297521286}]