Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 52.256193984698 -4.11718487866997X[t] + 0.220811068130770Y1[t] + 0.336607809560939Y2[t] -16.6367537407777M1[t] -24.0326149655328M2[t] + 7.5024817685998M3[t] -3.88948328986188M4[t] -9.8984806608981M5[t] -0.800380067444774M6[t] -10.3918250786584M7[t] -11.9106931547395M8[t] -8.9388430332159M9[t] -0.887711502151985M10[t] + 3.94199266424966M11[t] + 0.0617692125452959t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)52.25619398469813.7573493.79840.0004430.000222
X-4.117184878669972.827576-1.45610.1524690.076234
Y10.2208110681307700.1301521.69660.0968450.048423
Y20.3366078095609390.1297912.59350.0128540.006427
M1-16.63675374077773.207553-5.18675e-063e-06
M2-24.03261496553283.799676-6.324900
M37.50248176859984.2931431.74750.0875180.043759
M4-3.889483289861883.952901-0.9840.3305170.165258
M5-9.89848066089813.556994-2.78280.007910.003955
M6-0.8003800674447743.275642-0.24430.8081010.404051
M7-10.39182507865843.064577-3.39090.0014810.00074
M8-11.91069315473953.550716-3.35440.0016450.000823
M9-8.93884303321593.383603-2.64180.0113750.005688
M10-0.8877115021519853.400153-0.26110.7952490.397625
M113.941992664249663.1635331.24610.2193320.109666
t0.06176921254529590.0744540.82960.4112260.205613


Multiple Linear Regression - Regression Statistics
Multiple R0.902332302776116
R-squared0.814203584633248
Adjusted R-squared0.7508638975764
F-TEST (value)12.8545564789813
F-TEST (DF numerator)15
F-TEST (DF denominator)44
p-value1.81019643719083e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.80445749036213
Sum Squared Residuals1015.64371817466


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
189.187.29524378835861.80475621164137
282.678.41706881806014.18293118193987
3102.7108.174733450415-5.47473345041491
491.899.094889311781-7.2948893117809
594.197.5066374828394-3.40663748283945
6103.1103.505347621325-0.405347621324616
793.296.7371693978234-3.53716939782339
89196.1235112458414-5.1235112458414
994.395.3389289153693-1.03892891536929
1099.4103.439969002776-4.03996900277598
11115.7110.5683846007415.13161539925906
12116.8112.0040813883294.79591861167107
1399.8101.158696330884-1.35869633088371
149690.44108475096785.55891524903223
15115.9115.4765358762130.423464123787176
16109.1107.2613706097671.83862939023281
17117.3106.51112259825010.7888774017503
18109.8115.192710057906-5.39271005790625
19112.8106.7671352866576.0328647133431
20110.7103.4479110558067.25208894419367
21100107.027650575483-7.02765057548341
22113.3112.0709964900151.22900350998458
23122.4116.2975535128006.10244648720046
24112.5118.903594648246-6.40359464824567
25104.2103.2057116125230.994288387476765
2692.590.70647042017471.79352957982533
27117.2116.9260020503670.273997949633184
28109.3107.1115282154172.18847178458255
29106.1107.734105514849-1.63410551484863
30118.8113.5281782072975.27182179270263
31105.3105.725657983295-0.425657983294858
32106105.5625288814180.437471118582446
33102104.206510534105-2.20651053410530
34112.9111.6717924718841.22820752811592
35116.5117.623675255213-1.12367525521267
36114.8118.207396772993-3.40739677299331
37100.5102.468821543358-1.96882154335802
3885.491.4048979806245-6.00489798062453
39114.6114.854025121806-0.254025121806433
40109.9104.8887345409385.01126545906168
41100.7107.732642401412-7.03264240141219
42115.5113.2789936756712.22100632432867
43100.799.80334495870780.896655041292176
4499100.060037868338-1.06003786833849
45102.397.73648280508324.56351719491683
46108.8106.0058267972702.79417320272967
47105.9113.443377890618-7.54337789061836
48113.2111.1107531034812.08924689651913
4995.795.17152672487640.528473275123591
5080.986.4304780301729-5.5304780301729
51113.9108.8687035011995.03129649880097
5298.199.8434773220961-1.74347732209615
53102.8101.515492002651.28450799734997
54104.7106.394770437800-1.69477043780044
5595.998.866692373517-2.96669237351703
5694.696.1060109485962-1.50601094859622
57101.695.89042716995885.70957283004116
58103.9105.111415238054-1.2114152380542
59110.3112.867008740628-2.56700874062849
60114.1111.1741740869512.92582591304878


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.8690753078917640.2618493842164720.130924692108236
200.8147168262464220.3705663475071560.185283173753578
210.851747983237290.2965040335254210.148252016762710
220.8469894405515560.3060211188968890.153010559448444
230.944248454735940.1115030905281190.0557515452640594
240.9983281372507680.003343725498464900.00167186274923245
250.9972746956824570.00545060863508560.0027253043175428
260.9975286108782770.004942778243446420.00247138912172321
270.99434436963760.01131126072479840.00565563036239919
280.988224985093940.02355002981211930.0117750149060597
290.9845665692458330.03086686150833470.0154334307541674
300.9822115906542330.03557681869153460.0177884093457673
310.9718110791730010.05637784165399750.0281889208269987
320.9654911175407150.06901776491856940.0345088824592847
330.9509690357520810.09806192849583840.0490309642479192
340.9142747405123240.1714505189753520.0857252594876758
350.9163946088130040.1672107823739930.0836053911869964
360.8840278455255730.2319443089488540.115972154474427
370.823419765352240.3531604692955210.176580234647761
380.7709520540528080.4580958918943840.229047945947192
390.7167464085540630.5665071828918740.283253591445937
400.737977551449340.524044897101320.26202244855066
410.7979427715777210.4041144568445570.202057228422279


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level30.130434782608696NOK
5% type I error level70.304347826086957NOK
10% type I error level100.434782608695652NOK