Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 56.6688184694744 -0.414546054148085X[t] + 0.33464476226903Y1[t] + 0.436658336644705Y2[t] + 13.8710231589707M1[t] + 21.8094757766993M2[t] + 13.4085304100481M3[t] + 4.64011859452247M4[t] + 4.34174638169133M5[t] + 4.82811135206612M6[t] + 23.9529557196014M7[t] + 7.17288389240209M8[t] + 11.3657529755177M9[t] + 16.1462848792535M10[t] + 5.96354837739477M11[t] -0.0685256950949151t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)56.668818469474435.4952381.59650.1178710.058935
X-0.4145460541480850.284414-1.45750.1524030.076202
Y10.334644762269030.1414992.3650.0227260.011363
Y20.4366583366447050.1611092.71030.0096920.004846
M113.87102315897077.7877961.78110.0821250.041063
M221.80947577669938.0761362.70050.0099380.004969
M313.40853041004817.8593731.70610.0953830.047692
M44.640118594522477.6538530.60620.5476140.273807
M54.341746381691337.7077790.56330.576230.288115
M64.828111352066127.8727390.61330.5430050.271503
M723.95295571960148.0334312.98170.0047550.002378
M87.172883892402098.3355850.86050.3943920.197196
M911.36575297551777.7797511.46090.1514730.075737
M1016.14628487925358.0218622.01280.0505770.025289
M115.963548377394778.1066280.73560.4660390.23302
t-0.06852569509491510.145264-0.47170.639560.31978


Multiple Linear Regression - Regression Statistics
Multiple R0.783083562088961
R-squared0.613219865213936
Adjusted R-squared0.475084102790342
F-TEST (value)4.43925493626692
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value6.60816942024134e-05
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation11.3831582891788
Sum Squared Residuals5442.20429073303


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
196.3107.362646638182-11.0626466381815
2107.2114.808919914822-7.6089199148215
3114.9109.2016504871765.69834951282385
492.6107.369416672136-14.7694166721359
5115103.44111962816711.5588803718328
6107.1100.871337773636.22866222637008
7117.8126.277472062105-8.47747206210496
8107.4107.860333814589-0.460333814589034
9106.3112.720615217547-6.42061521754726
10114.5113.3938122002981.10618779970174
1198105.281949067397-7.28194906739706
12103.196.47974266965886.6202573303412
13100.3103.954973758173-3.65497375817286
14104.6113.36358049583-8.7635804958301
15111.2105.9809852829475.21901471705336
16105100.6914241804814.30857581951862
17109.9101.4218560062468.47814399375395
18111.5101.6012650377439.89873496225682
19132.5124.9493707905517.55062920944943
20100.3115.453875165804-15.1538751658042
21123.1118.0968460945455.00315390545463
22114.2116.751445891694-2.55144589169392
23104.6113.228927753556-8.62892775355634
24109.199.72491331841289.37508668158718
25107111.670484289006-4.67048428900626
26133.7121.79753025573211.9024697442685
27124.9120.7242727583934.17572724160745
28122.5120.8085119552921.69148804470785
29116.8116.2933285204250.506671479575255
30116114.5433501457051.45664985429479
31129.8130.843000489456-1.04300048945553
32125.2118.0144463846697.18555361533069
33143.8127.41294641483116.3870535851693
34127.9136.091989220621-8.1919892206211
35130.3129.3879032626480.912096737352066
36108.4118.045201175249-9.6452011752493
37129.4126.6862326995802.71376730041953
38143.7131.73069981944111.9693001805589
39131.9137.589565376414-5.68956537641419
40117.6131.130943095868-13.5309430958680
41119122.525695537094-3.52569553709440
42104.8117.623823925095-12.8238239250945
43134.6132.1664171958842.43358280411601
44140.4119.04823060343721.3517693965628
45143.8138.5819327041935.21806729580663
46153.4145.2647106350818.13528936491888
47153.3138.30121991639914.9987800836013
48127.3133.650142836679-6.35014283667909
49153.6136.92566261505916.6743373849411
50136.9144.399269514176-7.49926951417574
51131.8141.203526095070-9.40352609507046
52144.3121.99970409622322.3002959037774
53107.4124.418000308068-17.0180003080676
54113.6118.360223117827-4.76022311782716
55124.2124.663739462005-0.46373946200495
56102.1115.023114031500-12.9231140315002
5796.4116.587659568883-20.1876595688832
58111.7110.1980420523061.50195794769441


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.05172491403799580.1034498280759920.948275085962004
200.02172297419265880.04344594838531760.978277025807341
210.01024765066187710.02049530132375410.989752349338123
220.003194097621501880.006388195243003760.996805902378498
230.001225808358898250.00245161671779650.998774191641102
240.0004083085771414720.0008166171542829440.999591691422859
250.0001539230044177580.0003078460088355150.999846076995582
260.007205532891361220.01441106578272240.992794467108639
270.007329870141905390.01465974028381080.992670129858095
280.004914355817323510.009828711634647020.995085644182677
290.0026725513264060.0053451026528120.997327448673594
300.002623134479208070.005246268958416140.997376865520792
310.001656690497932320.003313380995864640.998343309502068
320.0008018772984579710.001603754596915940.999198122701542
330.002747889832620780.005495779665241560.99725211016738
340.001711605631205880.003423211262411760.998288394368794
350.002298722918491420.004597445836982850.997701277081509
360.003764894214581750.00752978842916350.996235105785418
370.002503083575201160.005006167150402310.997496916424799
380.001438926281937050.002877852563874110.998561073718063
390.002195740193364800.004391480386729610.997804259806635


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level160.761904761904762NOK
5% type I error level200.952380952380952NOK
10% type I error level200.952380952380952NOK