Multiple Linear Regression - Estimated Regression Equation
Y_t[t] = + 27.6311102673683 + 0.414284391942137X_1t[t] -0.46721105468132X_2t[t] -0.0906080774295398X_3t[t] -0.847575818888379X_4t[t] + 0.0492227659404471X_5t[t] -0.880855887263957M1[t] -0.909163478628467M2[t] + 0.29762990266939M3[t] + 3.20092531029737M4[t] + 0.0785997411513749M5[t] -0.232671950536061M6[t] -1.29989292249193M7[t] -0.662633856942808M8[t] -1.7174892402748M9[t] + 0.173268888997232M10[t] + 0.898960134925918M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)27.63111026736834.8737335.669400
X_1t0.4142843919421370.0643796.435100
X_2t-0.467211054681320.06901-6.770200
X_3t-0.09060807742953980.066685-1.35880.1789210.08946
X_4t-0.8475758188883790.224397-3.77710.0003460.000173
X_5t0.04922276594044710.088560.55580.5802490.290124
M1-0.8808558872639572.355055-0.3740.7096010.3548
M2-0.9091634786284672.370966-0.38350.7026320.351316
M30.297629902669392.3498930.12670.8996030.449802
M43.200925310297372.3820211.34380.183690.091845
M50.07859974115137492.3521260.03340.9734450.486722
M6-0.2326719505360612.382495-0.09770.9225040.461252
M7-1.299892922491932.373917-0.54760.5858610.29293
M8-0.6626338569428082.367914-0.27980.780490.390245
M9-1.71748924027482.384242-0.72040.4738920.236946
M100.1732688889972322.3553020.07360.9415820.470791
M110.8989601349259182.424710.37070.712030.356015


Multiple Linear Regression - Regression Statistics
Multiple R0.922061804389825
R-squared0.850197971114621
Adjusted R-squared0.813323625542835
F-TEST (value)23.0566253564957
F-TEST (DF numerator)16
F-TEST (DF denominator)65
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.19270177080869
Sum Squared Residuals1142.61862903125


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1-3-7.790237397711414.79023739771141
2-4-5.136044579197321.13604457919732
3-7-4.0317707810791-2.9682292189209
4-7-2.86464216821697-4.13535783178303
5-7-4.42337982765096-2.57662017234904
6-3-2.33520442865505-0.66479557134495
70-2.102024453382272.10202445338227
8-5-2.79225780294688-2.20774219705312
9-3-3.909714200156340.909714200156343
1031.479818467411351.52018153258865
112-1.182478126470743.18247812647074
12-7-7.201227851901490.201227851901495
13-1-1.296300819884730.296300819884727
140-2.114811745402342.11481174540234
15-30.694707074332846-3.69470707433285
1646.371578129305-2.371578129305
1721.737155590125580.262844409874415
1831.942317719059921.05768228094008
190-2.722056420961332.72205642096133
20-10-3.11282862918526-6.88717137081474
21-10-7.37455270300499-2.62544729699501
22-9-3.96165148186391-5.03834851813609
23-22-12.2791351927626-9.72086480723738
24-16-14.2930307820924-1.7069692179076
25-18-17.789700635039-0.210299364961043
26-14-16.25266170113542.25266170113545
27-12-17.01352984114115.0135298411411
28-17-19.19754496793542.19754496793544
29-23-20.6575623303272-2.34243766967277
30-28-22.4034280135916-5.59657198640841
31-31-27.1309192057283-3.86908079427173
32-21-25.71168480595184.71168480595179
33-19-24.15824979751175.15824979751174
34-22-24.9064332313622.90643323136196
35-22-22.84991582802080.849915828020826
36-25-25.31351806219960.313518062199576
37-16-20.12031635806564.12031635806558
38-22-20.5529291216478-1.44707087835223
39-21-14.3204470286286-6.67955297137143
40-10-11.53460418788561.53460418788559
41-7-10.4477809269343.447780926934
42-5-10.19610201327645.19610201327636
43-4-4.21359818305370.213598183053699
447-1.292685456644588.29268545664458
4561.637756656590684.36224334340932
4636.10145797346419-3.10145797346419
47106.622575596872323.37742440312768
4807.36529661201433-7.36529661201433
49-21.82525999024326-3.82525999024326
50-12.29261895274308-3.29261895274308
512-0.5302324456167882.53023244561679
5286.944035065150451.05596493484955
53-6-1.82238470539301-4.17761529460699
54-40.0461977099928985-4.0461977099929
5541.684380474593192.31561952540681
5676.002538433206730.997461566793265
5730.8153434003704142.18465659962959
583-2.074665329402275.07466532940227
5980.9257284270403737.07427157295963
603-0.4539668942418423.45396689424184
61-3-1.80948074516408-1.19051925483592
6240.355257246901883.64474275309812
63-5-5.991357507745110.991357507745113
64-10.871640774176823-1.87164077417682
655-0.4235006528942975.4235006528943
660-1.708163234999051.70816323499905
67-6-4.48427685141141-1.51572314858859
68-13-11.1683890607042-1.83161093929584
69-15-6.75352276947239-8.24647723052761
70-8-9.133801046205591.13380104620559
71-20-15.2367748766585-4.7632251233415
72-10-15.1035530215795.10355302157902
73-22-18.0192240343785-3.98077596562149
74-25-20.5914290522621-4.40857094773793
75-10-14.80736947012224.80736947012218
76-8-11.59046264459433.59046264459428
77-9-8.96254714692609-0.037452853073911
78-5-7.345617738530762.34561773853076
79-7-5.03150536005622-1.96849463994378
80-11-7.92469267777407-3.07530732222593
81-11-9.25706058681563-1.74293941318437
82-16-13.5047253520418-2.49527464795818


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
200.1074406519095770.2148813038191540.892559348090423
210.06891797882444870.1378359576488970.931082021175551
220.03356445550257730.06712891100515470.966435544497423
230.01915236725982440.03830473451964890.980847632740176
240.009934636924397680.01986927384879540.990065363075602
250.1001956720441920.2003913440883850.899804327955808
260.1603799398758520.3207598797517040.839620060124148
270.3546101815846880.7092203631693770.645389818415312
280.368200964201410.7364019284028210.63179903579859
290.2845202479539380.5690404959078760.715479752046062
300.2655609433554250.5311218867108510.734439056644575
310.2319379146319090.4638758292638180.768062085368091
320.5390737796044740.9218524407910530.460926220395526
330.5932253629177090.8135492741645820.406774637082291
340.5268232294316060.9463535411367870.473176770568394
350.4407106263502140.8814212527004280.559289373649786
360.3656762603074370.7313525206148740.634323739692563
370.3965993816292130.7931987632584260.603400618370787
380.3592622590811260.7185245181622510.640737740918874
390.3789106263677610.7578212527355210.621089373632239
400.3746853013994070.7493706027988140.625314698600593
410.4174109035413240.8348218070826480.582589096458676
420.4591998495786260.9183996991572510.540800150421374
430.3882017115551070.7764034231102150.611798288444892
440.6401670539246150.719665892150770.359832946075385
450.7495581037731630.5008837924536730.250441896226837
460.7053438005549270.5893123988901450.294656199445073
470.728803583492480.542392833015040.27119641650752
480.8533560414865860.2932879170268280.146643958513414
490.8241697066717190.3516605866565630.175830293328281
500.77889965330490.4422006933901990.2211003466951
510.7281284356654690.5437431286690610.271871564334531
520.6508865756206970.6982268487586050.349113424379303
530.6685124232074350.6629751535851310.331487576792565
540.7133702865743420.5732594268513150.286629713425658
550.6307274325624860.7385451348750290.369272567437514
560.5361139479058970.9277721041882060.463886052094103
570.529916951477290.940166097045420.47008304852271
580.4913759724442170.9827519448884340.508624027555783
590.5998990430032370.8002019139935270.400100956996763
600.634171117465570.7316577650688590.36582888253443
610.5302176851007620.9395646297984770.469782314899238
620.5052422414210080.9895155171579840.494757758578992


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level20.0465116279069767OK
10% type I error level30.0697674418604651OK