Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 12.9761973202013 -0.0437302424418521X[t] + 0.391874378892299M1[t] + 0.897837711324807M2[t] + 0.660439609582997M3[t] + 0.234421907724963M4[t] + 0.063567535529736M5[t] + 0.358066167101888M6[t] + 0.454545831418218M7[t] + 0.770604000129826M8[t] + 0.380445097074110M9[t] + 0.249516963843914M10[t] + 0.398409694904394M11[t] -0.0293669140023821t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)12.97619732020130.91126514.239800
X-0.04373024244185210.009977-4.3836.7e-053.4e-05
M10.3918743788922990.2782711.40820.1657810.082891
M20.8978377113248070.3573882.51220.0155680.007784
M30.6604396095829970.3624271.82230.0749190.03746
M40.2344219077249630.3233710.72490.4721660.236083
M50.0635675355297360.2820310.22540.8226730.411336
M60.3580661671018880.2803391.27730.207920.10396
M70.4545458314182180.2827781.60740.1148040.057402
M80.7706040001298260.3338432.30830.0255310.012765
M90.3804450970741100.3035911.25310.2164840.108242
M100.2495169638439140.3165140.78830.4345490.217274
M110.3984096949043940.3486671.14270.259090.129545
t-0.02936691400238210.003053-9.619500


Multiple Linear Regression - Regression Statistics
Multiple R0.865878546514659
R-squared0.749745657314338
Adjusted R-squared0.679021603946651
F-TEST (value)10.6009995413652
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value7.08769265500564e-10
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.401166295786969
Sum Squared Residuals7.40298225627013


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
19.39.04002195305720.259978046942795
29.38.904394977301340.395605022698658
38.78.567661573650190.132338426349814
48.28.44899982459203-0.248999824592030
58.38.5811283809525-0.281128380952497
68.58.93809360765016-0.438093607650156
78.69.03144450342922-0.431444503429216
88.58.977039867092-0.477039867091993
98.28.58375219549901-0.383752195499008
108.18.39721900280132-0.297219002801319
117.98.14941078334786-0.249410783347860
128.68.82363628397576-0.223636283975755
138.78.83192878508667-0.131928785086671
148.78.573857130493680.126142869506320
158.58.438282842075050.0617171579249544
168.47.96103310499370.438966895006296
178.58.106280734086730.393719265913274
188.78.410769669854160.289230330145837
198.78.469136371679740.230863628320259
208.68.196080523133260.403919476866741
218.58.100158500144870.399841499855133
228.37.69934711948210.600652880517898
2387.674563136482090.325436863517912
248.28.39689190379602-0.196891903796023
258.18.28273972606975-0.182739726069751
268.18.077144362406980.0228556375930144
2787.683561643581420.316438356418579
287.97.516796627837230.383203372162772
297.97.495869335651210.404130664348787
3087.848461538104690.151538461895312
3187.915574288418640.0844257115813641
327.97.651264488360520.248735511639476
3387.568461538104690.431538461895313
347.77.311959957500040.388040042499964
357.27.20846153810469-0.00846153810468793
367.57.85207586902329-0.352075869023288
377.37.75541578827376-0.455415788273757
3877.67226510344818-0.672265103448178
3977.24369819066913-0.243698190669132
4077.03757595672727-0.0375759567272731
417.27.25716499797144-0.057164997971444
427.37.299272479087770.000727520912231643
437.17.24394055056453-0.143940550564531
446.87.45191736887842-0.651917368878422
456.46.97554223664592-0.575542236645916
466.16.8589774318552-0.758977431855192
476.56.81670135187844-0.316701351878436
487.77.416585440355180.283414559644817
497.97.389893747512620.510106252487384
507.57.372338426349820.127661573650185
516.97.16679575002421-0.266795750024215
526.67.13559448584977-0.535594485849765
536.97.35955655133812-0.45955655133812
547.77.70340270530322-0.00340270530322409
5587.739904285907880.260095714092124
5687.52369775253580.476302247464198
577.77.572085529605520.127914470394478
587.37.232496488361350.0675035116386488
597.47.150863190186930.249136809813071
608.17.610810502849750.48918949715025


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.2288831995748390.4577663991496790.771116800425161
180.1078848807481690.2157697614963380.892115119251831
190.04868223044559690.09736446089119380.951317769554403
200.03366135426414610.06732270852829210.966338645735854
210.02267801099529990.04535602199059970.9773219890047
220.01085461130493050.02170922260986100.98914538869507
230.004547492454977220.009094984909954440.995452507545023
240.004542383953234410.009084767906468830.995457616046766
250.03546363947831310.07092727895662630.964536360521687
260.05400223387386880.1080044677477380.945997766126131
270.04835023741694680.09670047483389360.951649762583053
280.03193727275695000.06387454551389990.96806272724305
290.03085863794327450.0617172758865490.969141362056726
300.02153054231991420.04306108463982830.978469457680086
310.01478510470296760.02957020940593520.985214895297032
320.01281911652738920.02563823305477840.98718088347261
330.01440218616582460.02880437233164920.985597813834175
340.04329613076488810.08659226152977630.956703869235112
350.05413354712043170.1082670942408630.945866452879568
360.04447134523386570.08894269046773130.955528654766134
370.09110906553630410.1822181310726080.908890934463696
380.2262986106987530.4525972213975060.773701389301247
390.1889826084845580.3779652169691170.811017391515442
400.2441529244597420.4883058489194840.755847075540258
410.5084922982170970.9830154035658070.491507701782903
420.6180882234712930.7638235530574150.381911776528708
430.5182572694237540.963485461152490.481742730576246


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level20.0740740740740741NOK
5% type I error level80.296296296296296NOK
10% type I error level160.592592592592593NOK