Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 7378.28355988144 + 3.95381014494266X[t] + 6461.74593137428M1[t] + 4918.47723861162M2[t] + 3506.72080584833M3[t] + 4679.62057135073M4[t] + 5504.75273192363M5[t] + 6198.70800814803M6[t] + 7252.52025307776M7[t] + 5491.07357394325M8[t] + 4915.84217683649M9[t] + 3132.54862030323M10[t] + 2278.21743653034M11[t] -215.719989563514t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)7378.283559881442945.7522562.50470.0158610.00793
X3.953810144942660.8122624.86771.4e-057e-06
M16461.745931374283219.3062322.00720.0506270.025313
M24918.477238611622925.3442671.68130.0994770.049738
M33506.720805848332629.9657051.33340.1889760.094488
M44679.620571350732527.9997251.85110.0705790.03529
M55504.752731923632368.6590552.3240.0245970.012299
M66198.708008148032210.590782.80410.0073660.003683
M77252.520253077762327.5742033.11590.0031560.001578
M85491.073573943252266.5800542.42260.0194050.009702
M94915.842176836492177.6976952.25740.0287770.014389
M103132.548620303231991.6303361.57290.1226060.061303
M112278.217436530341959.2300551.16280.2509030.125451
t-215.71998956351428.521856-7.563300


Multiple Linear Regression - Regression Statistics
Multiple R0.813060614890317
R-squared0.661067563485821
Adjusted R-squared0.565282309688335
F-TEST (value)6.90155882327656
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value3.96688436321568e-07
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3046.67568215229
Sum Squared Residuals426982704.762034


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11014414067.1362379258-3923.13623792581
21075113067.2791034286-2316.2791034286
31175213377.1696521237-1625.16965212370
41380814757.4071135715-949.407113571461
51620316675.5304425569-472.530442556864
61743217185.3962103773246.603789622711
71801417201.0959555954812.904044404558
81695615670.70983327591285.29016672406
91798216631.29634081531350.70365918475
101943517305.05845269972129.94154730029
111999016017.54772139153972.45227860853
122015416322.90787791703831.09212208298
131032711996.4454921511-1669.44549215111
14980711482.9070054819-1675.90700548187
151086212544.0214817161-1682.02148171608
161374314545.0071359198-802.00713591983
171645817123.4167591107-665.416759110656
181846618178.9083269332287.091673066823
191881018700.6957707040109.304229296019
201736116644.4528991071716.547100892892
211741115481.84335881221929.15664118778
221851716721.00032142351795.99967857652
231852517655.530891573869.469108426989
241785918016.2443901278-157.244390127759
25949910068.0919115944-569.091911594363
26949011064.9089002932-1574.90890029323
27925511473.6447026119-2218.64470261189
281075813870.0113713099-3112.01137130991
291237514677.1140495664-2302.11404956642
301461716594.5362289864-1977.53622898645
311542718761.1086930534-3334.1086930534
321413617436.3206982709-3300.32069827092
331430816574.2007289917-2266.20072899166
341529317991.2791481253-2698.27914812535
351567918218.0777023301-2539.07770233015
361631919365.5994197285-3046.59941972848
37111968131.830710747733064.16928925227
38111698049.257529877253119.74247012275
39121588050.750887266824107.24911273318
40142519332.143095091014918.85690490899
411623711337.25024726514899.74975273485
421970615978.84761655073727.15238344933
431896014733.28192553214226.7180744679
441853714669.75936698633867.24063301367
451910316298.53978902102804.46021097905
461969117166.03859800762524.96140199239
471946417072.57853047202391.42146952795
481726413574.37332756283689.62667243724
4989575859.495647580983097.50435241902
5097037255.647460919052447.35253908095
5191667747.413276281511418.58672371849
5295199574.43128410779-55.4312841077877
531053511994.6885015009-1459.68850150091
541152613809.3116171524-2283.31161715242
55963011444.8176551151-1814.81765511508
5670619629.75720235971-2568.75720235971
5760219839.11978235992-3818.11978235992
5847288480.62347974385-3752.62347974385
5926577351.26515423332-4694.26515423332
6012645580.87498466397-4316.87498466397


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.003568091536812260.007136183073624520.996431908463188
180.000750224310472290.001500448620944580.999249775689528
198.56748506512946e-050.0001713497013025890.999914325149349
209.2675548917958e-061.85351097835916e-050.999990732445108
211.12815764249729e-062.25631528499459e-060.999998871842358
223.74303397903608e-077.48606795807215e-070.999999625696602
232.74098465785763e-065.48196931571526e-060.999997259015342
247.34818240664762e-061.46963648132952e-050.999992651817593
251.48352498926296e-062.96704997852593e-060.99999851647501
263.11337802941747e-076.22675605883494e-070.999999688662197
272.25773476370176e-074.51546952740352e-070.999999774226524
287.62023095888406e-071.52404619177681e-060.999999237976904
292.7765244417018e-065.5530488834036e-060.999997223475558
302.22377507220397e-064.44755014440795e-060.999997776224928
313.16853245085323e-066.33706490170646e-060.99999683146755
324.59469066445211e-069.18938132890421e-060.999995405309336
334.51110223721642e-069.02220447443284e-060.999995488897763
349.63390611245494e-061.92678122249099e-050.999990366093888
353.00676300578268e-056.01352601156536e-050.999969932369942
360.03836778137742910.07673556275485820.96163221862257
370.3351519647863860.6703039295727730.664848035213614
380.8617727857465880.2764544285068250.138227214253412
390.99295691693240.01408616613519980.00704308306759989
400.9915179767822840.01696404643543220.00848202321771608
410.982560334622060.03487933075587880.0174396653779394
420.9717263727608080.0565472544783840.028273627239192
430.9188654412945730.1622691174108540.081134558705427


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level190.703703703703704NOK
5% type I error level220.814814814814815NOK
10% type I error level240.888888888888889NOK