Multiple Linear Regression - Estimated Regression Equation
S&P500[t] = + 966.129982902622 + 0.43035784722686Gold[t] + 79.2882926988925M1[t] + 60.6832961939366M2[t] + 44.0736579306548M3[t] + 45.6598105362746M4[t] + 63.6943256675065M5[t] + 78.8140598459922M6[t] + 48.70465990289M7[t] + 40.1346426021993M8[t] + 56.910689036992M9[t] + 40.5558293597744M10[t] + 19.6090020272143M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)966.12998290262287.79290611.004600
Gold0.430357847226860.1005994.2789.2e-054.6e-05
M179.288292698892585.729470.92490.359760.17988
M260.683296193936685.6080120.70890.4819190.240959
M344.073657930654885.5393910.51520.6087980.304399
M445.659810536274685.585750.53350.5962030.298102
M563.694325667506585.5705080.74430.4603710.230185
M678.814059845992285.5817230.92090.3617940.180897
M748.7046599028985.5469440.56930.5718420.285921
M840.134642602199385.5492420.46910.6411380.320569
M956.91068903699285.6079170.66480.5094380.254719
M1040.555829359774485.5197990.47420.6375340.318767
M1119.609002027214385.5594410.22920.8197190.409859


Multiple Linear Regression - Regression Statistics
Multiple R0.539236875404102
R-squared0.290776407795579
Adjusted R-squared0.109698043828493
F-TEST (value)1.60580425747845
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0.122579274521098
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation135.206812857309
Sum Squared Residuals859201.465422471


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11111.921224.55472950969-112.634729509693
21131.131198.24632753938-67.1163275393772
31144.941182.34677972402-37.4067797240199
41113.891195.66018366657-81.7701836665715
51107.31198.20181629764-90.9018162976366
61120.681215.88217966712-95.2021796671222
71140.841184.73992089068-43.8999208906755
81101.721174.74972269414-73.0297226941361
91104.241198.47604836164-94.2360483616427
101114.581186.61842818795-72.0384281879458
111130.21170.40553717488-40.2055371748809
121173.781161.0175340193012.7624659806953
131211.921229.50384475280-17.5838447528029
141181.271207.95089699434-26.6808969943431
151203.61196.742249713766.85775028624147
161180.591195.61714788185-15.027147881849
171156.851213.9744313985-57.1244313985011
181191.51223.69317459429-32.1931745942897
191191.331201.00744751585-9.67744751585082
201234.181192.0285902602942.1514097397056
211220.331212.225981580548.1040184194591
221228.811207.2756048548321.5343951451650
231207.011183.4884157305823.5215842694224
241249.481181.2013170542468.2786829457556
251248.291273.50793463175-25.2179346317495
261280.081271.364125783228.715874216779
271280.661253.0330561310327.6269438689684
281302.881264.4098497610638.4701502389376
291310.611314.29084558708-3.68084558708223
301270.051313.9176972654-43.8676972654009
311270.061282.92606373548-12.8660637354836
321278.531280.51016365014-1.98016365013698
331303.81290.3144129598513.4855870401454
341335.831265.1587353068570.6712646931523
351377.761250.02173891185127.73826108815
361400.631245.32463629105155.305363708954
371418.031320.7397083649097.2902916351026
381437.91310.93552983573126.964470164269
391406.81298.71554161416108.084458385837
401420.831295.07284637598125.757153624024
411482.371319.71335446214162.656645537859
421530.631331.77754792532198.852452074685
431504.661296.61144327730208.048556722702
441455.181292.77536229610162.404637703898
451473.961312.24114527606161.718854723937
461527.291326.22651382834201.063486171661
471545.791325.82927370086219.960726299138
481479.631303.63812459029175.991875409714
491467.971409.8237827408658.1462172591427
501378.61420.48311984733-41.8831198473281
511330.451435.61237281703-105.162372817027
521326.411393.83997231454-67.4299723145406
531385.971396.91955225464-10.9495522546392
541399.621427.20940054787-27.5894005478719
551276.691418.29512458069-141.605124580692
561269.421398.96616109933-129.54616109933
571287.831376.9024118219-89.0724118218989
581164.171385.40071782203-221.230717822032
59968.671299.68503448183-331.01503448183
60888.611300.94838804512-412.338388045118


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.02614773221822450.0522954644364490.973852267781776
170.006945027326203660.01389005465240730.993054972673796
180.001897434617282830.003794869234565660.998102565382717
190.0004510338356140180.0009020676712280360.999548966164386
200.0001499008953805810.0002998017907611630.99985009910462
214.44691646432391e-058.89383292864782e-050.999955530835357
228.66445843210221e-061.73289168642044e-050.999991335541568
231.57261827453181e-063.14523654906362e-060.999998427381726
243.68782019236857e-077.37564038473714e-070.99999963121798
252.70900057744506e-065.41800115489012e-060.999997290999423
262.20614485988824e-064.41228971977648e-060.99999779385514
278.47269116020372e-071.69453823204074e-060.999999152730884
282.01188439286955e-074.0237687857391e-070.99999979881156
298.94396251969942e-081.78879250393988e-070.999999910560375
308.03497798793192e-081.60699559758638e-070.99999991965022
314.45784081335017e-088.91568162670033e-080.999999955421592
321.9931616406731e-083.9863232813462e-080.999999980068384
335.21678241684605e-091.04335648336921e-080.999999994783218
342.10739001335331e-094.21478002670661e-090.99999999789261
351.55453700447082e-093.10907400894164e-090.999999998445463
367.45988643266476e-101.49197728653295e-090.999999999254011
376.6279610160492e-101.32559220320984e-090.999999999337204
383.61574508232931e-107.23149016465861e-100.999999999638425
398.63274522516247e-111.72654904503249e-100.999999999913673
403.29534367840143e-116.59068735680287e-110.999999999967047
416.50325314630043e-111.30065062926009e-100.999999999934967
422.23947639891672e-104.47895279783344e-100.999999999776052
432.05135208348553e-104.10270416697106e-100.999999999794865
444.29151088698244e-118.58302177396488e-110.999999999957085


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level270.93103448275862NOK
5% type I error level280.96551724137931NOK
10% type I error level291NOK