Multiple Linear Regression - Estimated Regression Equation
X[t] = + 24.1698363156218 + 3.12409265557007Y[t] + 0.354106572914146`y(t)`[t] + 0.386685471568013`y(t-1)`[t] + 0.316297204680138`y(t-2)`[t] -0.0792357995923454`y(t-3)`[t] + 4.29883047671241M1[t] -22.2968495935551M2[t] -39.5691693349632M3[t] -35.9297143015368M4[t] -20.3378644943873M5[t] -6.9663341972657M6[t] -15.9323504617263M7[t] -22.9939682907714M8[t] -6.55872286116876M9[t] -44.2832772039972M10[t] -31.4045454857822M11[t] -0.0983757038209553t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)24.169836315621818.6389841.29670.2018010.100901
Y3.124092655570073.7730850.8280.4123540.206177
`y(t)`0.3541065729141460.1534972.30690.026060.01303
`y(t-1)`0.3866854715680130.1614542.3950.0211570.010578
`y(t-2)`0.3162972046801380.1562692.02410.0493560.024678
`y(t-3)`-0.07923579959234540.157901-0.50180.6184230.309212
M14.298830476712419.7994880.43870.6631420.331571
M2-22.296849593555110.749129-2.07430.0442180.022109
M3-39.56916933496327.999304-4.94661.3e-056e-06
M4-35.92971430153685.974976-6.013400
M5-20.33786449438736.115281-3.32570.0018380.000919
M6-6.96633419726576.522986-1.0680.2916360.145818
M7-15.93235046172637.900121-2.01670.0501480.025074
M8-22.99396829077147.837306-2.93390.0054040.002702
M9-6.558722861168766.469515-1.01380.3164880.158244
M10-44.28327720399727.364443-6.013100
M11-31.40454548578228.394784-3.7410.000550.000275
t-0.09837570382095530.065916-1.49240.1430570.071528


Multiple Linear Regression - Regression Statistics
Multiple R0.938958363418636
R-squared0.881642808233803
Adjusted R-squared0.833736325852247
F-TEST (value)18.4034135758888
F-TEST (DF numerator)17
F-TEST (DF denominator)42
p-value3.19744231092045e-14
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation7.73467319800471
Sum Squared Residuals2512.65711815716


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1112.3122.614877127651-10.3148771276511
2117.3111.0406461661046.25935383389579
3111.1101.7911189726569.3088810273439
4102.2101.9038982934170.296101706582654
5104.3113.818115415492-9.5181154154915
6122.9122.0361714479780.863828552022036
7107.6118.046418062012-10.4464180620117
8121.3114.0303664809247.26963351907558
9131.5135.018941368546-3.51894136854592
108999.7923562220788-10.7923562220788
11104.4107.012954135496-2.61295413549615
12128.9129.478933632017-0.578933632017009
13135.9134.0591193487051.84088065129534
14133.3127.556102073185.74389792681967
15121.3118.5005780402922.79942195970812
16120.5113.9357069560296.56429304397087
17120.4123.128646812895-2.72864681289544
18137.9132.4674889944295.43251100557129
19126.1130.259085336352-4.15908533635198
20133.2125.7193889147457.48061108525491
21151.1145.5506514055765.54934859442373
22105111.692762354131-6.69276235413127
23119118.2511678866690.74883211333072
24140.4141.787775236812-1.38777523681202
25156.6142.98008532356113.619914676439
26137.1138.378556348966-1.27855634896627
27122.7126.026546357175-3.3265463571753
28125.8120.3564929457835.44350705421719
29139.3123.92801118990715.3719888100929
30134.9140.170747824066-5.27074782406636
31149.2136.89005764976912.309942350231
32132.3137.116753319122-4.81675331912151
33149150.537433210987-1.53743321098744
34117.2116.9647860076370.235213992362869
35119.6118.4637056852821.13629431471772
36152144.9443815776447.05561842235639
37149.4150.164445482696-0.764445482696067
38127.3138.357133616103-11.0571336161034
39114.1122.21316419601-8.11316419600972
40102.1109.144675202535-7.04467520253496
41107.7108.500467061705-0.800467061705028
42104.4116.692380873722-12.2923808737218
43102.1105.875221954062-3.77522195406175
4496102.470907844206-6.47090784420568
45109.3111.146756981873-1.84675698187297
469078.332750201877311.6672497981227
4783.987.6745955213964-3.77459552139643
48112114.047776807078-2.04777680707792
49114.3118.681472717387-4.38147271738714
50103.6103.2675617956460.332438204354196
5191.792.368592433867-0.668592433867005
5280.886.0592266022358-5.25922660223576
5387.289.5247595200009-2.3247595200009
54109.297.933210859805211.2667891401948
55102.796.62921699780566.07078300219443
5695.198.5625834410033-3.4625834410033
57117.5116.1462170330171.3537829669826
5885.179.51734521427555.58265478572454
5992.187.59757677115584.50242322884415
60113.5116.541132746449-3.04113274644943


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.02599734881168940.05199469762337890.97400265118831
220.008086277984762380.01617255596952480.991913722015238
230.001803603887778550.00360720777555710.998196396112221
240.002275122198873860.004550244397747730.997724877801126
250.0008654850374799670.001730970074959930.99913451496252
260.00487259117129010.00974518234258020.99512740882871
270.1140087418931560.2280174837863110.885991258106844
280.3078054434329450.615610886865890.692194556567055
290.3323833128300790.6647666256601570.667616687169921
300.2911401810720040.5822803621440070.708859818927996
310.5939275480010240.8121449039979510.406072451998976
320.5175188770473290.9649622459053420.482481122952671
330.7043062810377710.5913874379244580.295693718962229
340.5997720583350180.8004558833299650.400227941664982
350.5120295903143820.9759408193712370.487970409685618
360.7449612387327650.5100775225344710.255038761267235
370.6389562866082740.7220874267834520.361043713391726
380.6344583207135010.7310833585729970.365541679286499
390.5276491356894530.9447017286210930.472350864310547


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level40.210526315789474NOK
5% type I error level50.263157894736842NOK
10% type I error level60.315789473684211NOK