Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 1.65596789050869 + 0.913038167653139X[t] + 1.13860134993134Y1[t] -0.542253852886171Y2[t] -0.170092084347798M1[t] + 0.37042972215349M2[t] -0.310491195601124M3[t] -0.799607124513897M4[t] -0.99811330052441M5[t] -0.577619444079062M6[t] -1.24340332230172M7[t] + 0.0569418787685395M8[t] + 3.12930286471154M9[t] -0.909771222546327M10[t] + 0.142479922141714M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1.655967890508691.0922551.51610.1368120.068406
X0.9130381676531390.2287583.99130.0002520.000126
Y11.138601349931340.1270138.964500
Y2-0.5422538528861710.100297-5.40653e-061e-06
M1-0.1700920843477980.433788-0.39210.6969140.348457
M20.370429722153490.4941380.74960.4575480.228774
M3-0.3104911956011240.532876-0.58270.5631580.281579
M4-0.7996071245138970.542691-1.47340.1479240.073962
M5-0.998113300524410.530749-1.88060.0668140.033407
M6-0.5776194440790620.527891-1.09420.2799580.139979
M7-1.243403322301720.509301-2.44140.0188210.00941
M80.05694187876853950.5204710.10940.9133910.456695
M93.129302864711540.558935.59871e-061e-06
M10-0.9097712225463270.640367-1.42070.1626150.081307
M110.1424799221417140.4612250.30890.7588770.379439


Multiple Linear Regression - Regression Statistics
Multiple R0.974673811936578
R-squared0.94998903967498
Adjusted R-squared0.933706401429624
F-TEST (value)58.3436802660627
F-TEST (DF numerator)14
F-TEST (DF denominator)43
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.623972228455184
Sum Squared Residuals16.7416777009831


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
12221.43681542304630.56318457695368
221.321.16330107191340.136698928086635
320.720.7897983926439-0.0897983926439313
420.419.99709935079270.402900649207332
520.319.78236508153450.517634918465548
620.419.97776350855660.422236491443420
719.819.48006515061570.319934849384338
819.519.6778088893772-0.17780888937725
923.123.09915704913380.000842950866200051
1023.523.32172397749460.178276022505369
1123.522.96860560853030.531394391469691
1222.922.70052796199940.199472038000559
1321.921.84727506769280.0527249323071645
1421.521.7571554695251-0.257155469525107
1520.521.3456554982148-0.845655498214755
1620.220.02614357729040.173856422709579
1719.420.0283108491867-0.628310849186675
1819.219.7005997815528-0.500599781552799
1918.818.9669872653569-0.166987265356861
2018.819.3725197964399-0.572519796439939
2122.622.29656705647610.303432943523851
2223.322.31026664866150.989733351338549
232322.19027791409930.809722085900703
2421.421.5092475234885-0.109247523488489
2519.919.77137325188170.128626748118296
2618.819.5629030148692-0.762903014869161
2718.618.53420520828460.0657947917153587
2818.418.32254443079510.077455569204924
2918.617.82216112184490.777838878155106
3019.918.67012983561911.22987016438093
3119.219.19346930819930.00653069180071754
3218.418.6266482885043-0.226648288504332
3321.121.4416173418185-0.341617341818513
3420.520.8192661649189-0.319266164918905
3519.119.5416634633248-0.441663463324846
3618.118.03919014624560.0608098537543599
371717.3983482892418-0.398348289241824
3817.117.5025739140007-0.402573914000742
3917.417.80590381971-0.405903819709998
4016.817.604142910488-0.804142910488006
4115.316.1945845015916-0.894584501591583
4214.314.9586171945757-0.658617194575673
4313.413.6937012954550-0.29370129545498
4415.314.78547058476910.514529415230851
4522.121.51354458759770.58645541240229
4623.724.2779811761546-0.577981176154579
4722.223.0994530140455-0.899453014045548
4819.519.6510343682664-0.151034368266431
4916.616.9461879681373-0.346187968137317
5017.316.01406652969161.28593347030837
5119.818.52443708114671.27556291885333
5221.221.05006973063380.149930269366171
5321.521.27257844584240.227421554157604
5420.621.0928896796959-0.49288967969588
5519.118.96577698037320.134223019626786
5619.619.13755244090930.462447559090670
5723.524.0491139649738-0.549113964973829
582424.2707620327704-0.270762032770434


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
180.06461493458243560.1292298691648710.935385065417564
190.01904704521252690.03809409042505370.980952954787473
200.005943199786518630.01188639957303730.994056800213481
210.004508701228980650.00901740245796130.99549129877102
220.002354459305026810.004708918610053620.997645540694973
230.004669284679285490.009338569358570980.995330715320714
240.01192801309756840.02385602619513680.988071986902432
250.005005437017135920.01001087403427180.994994562982864
260.004919975457226410.009839950914452820.995080024542774
270.0104981565624560.0209963131249120.989501843437544
280.005373538784920250.01074707756984050.99462646121508
290.007958983578815450.01591796715763090.992041016421185
300.06616946076365180.1323389215273040.933830539236348
310.06428935254351060.1285787050870210.93571064745649
320.04541337918418520.09082675836837040.954586620815815
330.04131203790671990.08262407581343970.95868796209328
340.04448824550170790.08897649100341580.955511754498292
350.03623374276123010.07246748552246030.96376625723877
360.02680689214653620.05361378429307250.973193107853464
370.02766607430155670.05533214860311350.972333925698443
380.6201074686919110.7597850626161780.379892531308089
390.9197961351959810.1604077296080380.0802038648040189
400.8485036378927780.3029927242144440.151496362107222


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level40.173913043478261NOK
5% type I error level110.478260869565217NOK
10% type I error level170.739130434782609NOK