Multiple Linear Regression - Estimated Regression Equation
Y(t)[t] = + 545.186455397854 + 0.141348092963167`Y(t-1)`[t] + 0.00880922248867556`Y(t-2)`[t] + 71.4208577566432X[t] + 98.2230519212738M1[t] + 1.62679385532139M2[t] + 32.0269502909186M3[t] + 160.81742550343M4[t] -232.68270559757M5[t] -257.700350126129M6[t] + 222.814216532563M7[t] + 104.723350792037M8[t] + 8.83524526213836M9[t] + 53.2794395618514M10[t] + 48.363914887757M11[t] -0.637210678003292t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)545.186455397854149.2554173.65270.0007140.000357
`Y(t-1)`0.1413480929631670.163420.86490.3919870.195993
`Y(t-2)`0.008809222488675560.1600740.0550.9563740.478187
X71.420857756643228.2219742.53070.0152190.007609
M198.223051921273837.660512.60810.0125540.006277
M21.6267938553213937.7472570.04310.9658280.482914
M332.026950290918640.3015390.79470.4312660.215633
M4160.8174255034336.9470524.35268.4e-054.2e-05
M5-232.6827055975741.349124-5.62731e-061e-06
M6-257.70035012612963.495252-4.05860.000210.000105
M7222.81421653256371.8112883.10280.0034230.001711
M8104.72335079203765.4626721.59970.1171520.058576
M98.8352452621383646.7961980.18880.8511570.425578
M1053.279439561851441.8608111.27280.2100980.105049
M1148.36391488775739.4100491.22720.2265830.113291
t-0.6372106780032920.641103-0.99390.325950.162975


Multiple Linear Regression - Regression Statistics
Multiple R0.947365382278292
R-squared0.897501167539294
Adjusted R-squared0.860894441660471
F-TEST (value)24.5173843328744
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value4.44089209850063e-16
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation54.8915474089605
Sum Squared Residuals126549.443031907


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1825746.67395184389278.3260481561084
2677668.28222344398.71777655609997
3656678.262041143984-22.2620411439842
4785802.143230797942-17.1432307979421
5412426.054799338925-14.0547993389251
6352348.8134951581413.18650484185928
7839816.92412557276322.0758744272371
8729766.504017077975-37.5040170779754
9696658.7205019961137.2794980038895
10641696.893984076281-55.8939840762814
11695683.27639926908311.7236007309167
12638641.423563486457-3.42356348645686
13762731.42826144521530.5717385547847
14635651.219830546838-16.2198305468378
15721664.12391208670556.8760879132948
16854803.31434135998450.6856586400158
17418428.733889079108-10.7338890791081
18367342.62289193159924.3771080684011
19824811.45067416610312.5493258338969
20687756.869405884819-69.8694058848186
21601645.005215618288-44.0052156182879
22676675.4493997642170.550600235783341
23740679.7401782503360.2598217496695
24691640.44602232086350.5539776791365
25683731.669597248214-48.6695972482141
26594632.873691858608-38.8736918586079
27729649.98618356257079.0138164374295
28731796.437419845614-65.4374198456143
29386403.772019288508-17.7720192885085
30331329.3696904546311.63030954536914
31707798.433719563752-91.433719563752
32715732.368018862496-17.3680188624962
33657640.28575505404216.7142449459580
34653675.965023063797-22.9650230637974
35642669.335960435504-27.3359604355040
36643618.74476895719424.2552310428059
37718716.3750568460521.62494315394763
38654629.75150429682324.2484957031771
39632651.128863791425-19.1288637914246
40731775.608680041468-44.6086800414681
41392395.270996571067-3.27099657106742
42344322.57125087637021.4287491236296
43792792.677571971166-0.677571971165651
44852736.850598520679115.149401479321
45649652.752699565494-3.75269956549375
46629668.394573665001-39.3945736650011
47685729.647462045082-44.6474620450822
48617688.385645235486-71.3856452354857
49715776.853132616627-61.8531326166267
50715692.87274985383122.1272501461686
51629723.498999415316-94.4989994153155
52916839.49632795499176.5036720450085
53531485.16829572239145.8317042776090
54357407.622671579259-50.6226715792592
55917859.51390872621657.4860912737836
56828818.4079596540319.5920403459689
57708714.235827766066-6.2358277660659
58858740.297019430703117.702980569297


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.1604720883129540.3209441766259080.839527911687046
200.08909158129436710.1781831625887340.910908418705633
210.1040430009236230.2080860018472450.895956999076377
220.1017784559094120.2035569118188250.898221544090588
230.06841079155635230.1368215831127050.931589208443648
240.06211174083611020.1242234816722200.93788825916389
250.0867907760113970.1735815520227940.913209223988603
260.04826925949876040.09653851899752090.95173074050124
270.07286199041091070.1457239808218210.92713800958909
280.1639026271871740.3278052543743490.836097372812826
290.1123191012525840.2246382025051680.887680898747416
300.09065704193708840.1813140838741770.909342958062912
310.1265936821213040.2531873642426070.873406317878696
320.1003449351632600.2006898703265210.89965506483674
330.0650651803863090.1301303607726180.934934819613691
340.03779125515850880.07558251031701750.962208744841491
350.0222812102011720.0445624204023440.977718789798828
360.02117282851601580.04234565703203170.978827171483984
370.01945300174557840.03890600349115670.980546998254422
380.01669090447649020.03338180895298040.98330909552351
390.04438833668745260.08877667337490530.955611663312547


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level40.190476190476190NOK
10% type I error level70.333333333333333NOK