Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 527.153964987183 + 0.240954871069374X[t] + 0.0818613967871051`Yt-1`[t] + 0.219375924876468`Yt-2`[t] + 0.0732409941807161`Yt-3`[t] -0.203227371439877`Yt-4 `[t] -376.320123526623M1[t] -566.548733539981M2[t] -453.392933547681M3[t] -284.226352917444M4[t] -102.796221338208M5[t] -229.174297826116M6[t] -101.477955789942M7[t] -162.031792665541M8[t] + 492.054561282492M9[t] -489.494924058148M10[t] -27.2853312979341M11[t] -2.8468762610436t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)527.153964987183428.0010271.23170.2254490.112725
X0.2409548710693740.0320747.512500
`Yt-1`0.08186139678710510.0844150.96970.3381480.169074
`Yt-2`0.2193759248764680.1126891.94670.0587940.029397
`Yt-3`0.07324099418071610.1092140.67060.5064140.253207
`Yt-4 `-0.2032273714398770.121176-1.67710.1015160.050758
M1-376.320123526623223.342297-1.68490.0999860.049993
M2-566.548733539981229.555998-2.4680.0180780.009039
M3-453.392933547681163.563729-2.7720.0084970.004249
M4-284.226352917444175.825767-1.61650.1140430.057021
M5-102.796221338208172.235645-0.59680.5540670.277033
M6-229.174297826116207.469621-1.10460.2760950.138047
M7-101.477955789942234.645415-0.43250.6677790.33389
M8-162.031792665541175.801986-0.92170.3623660.181183
M9492.054561282492198.9377442.47340.0178440.008922
M10-489.494924058148222.378604-2.20120.0337090.016854
M11-27.2853312979341202.411735-0.13480.8934620.446731
t-2.84687626104362.323603-1.22520.2278480.113924


Multiple Linear Regression - Regression Statistics
Multiple R0.947855213102673
R-squared0.898429505005913
Adjusted R-squared0.854155186675157
F-TEST (value)20.2923396424559
F-TEST (DF numerator)17
F-TEST (DF denominator)39
p-value2.86437540353290e-14
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation215.815377171798
Sum Squared Residuals1816474.80392841


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
136133732.86246543437-119.862465434367
23730.53923.62816530057-193.128165300567
33481.33447.1237913785434.1762086214585
43649.53790.30605815103-140.806058151032
54215.24412.03222326646-196.832223266460
64066.63998.7474003985667.8525996014425
74196.84136.3876513964460.4123486035631
84536.64348.03457548654188.565424513461
94441.64396.5921560770745.0078439229288
103548.33549.85117744227-1.55117744227235
114735.94569.93326978164165.966730218363
124130.64058.4533492777172.1466507222936
134356.24226.86565412097129.334345879032
144159.64293.72933518343-134.129335183434
1539883952.4454264826835.5545735173243
164167.84240.25557452122-72.4555745212196
174902.24922.25190030101-20.0519003010127
183909.44164.68032458006-255.280324580062
194697.64669.6605448429027.9394551571036
204308.94485.22566579919-176.325665799188
214420.44609.14007036491-188.740070364910
223544.23843.94060341878-299.740603418783
2344334523.02311663451-90.0231166345052
244479.74470.610852771779.08914722822901
254533.24292.11266107063241.087338929375
264237.54053.42147700109184.078522998910
274207.44086.37110232052121.028897679482
2843944199.67304744946194.326952550539
295148.44724.40286751344423.997132486556
304202.24243.81941451376-41.6194145137602
314682.54791.63849824442-109.138498244420
324884.34695.96031187812188.339688121877
335288.95001.88640020074287.013599799263
344505.24047.81787133411457.382128665892
354611.54819.01125403667-207.511254036666
3651045084.7199036418519.28009635815
374586.64507.2262170819179.3737829180911
384529.34405.77487312435123.525126875648
394504.14645.4846927837-141.384692783701
404604.94841.97604959047-237.076049590472
414795.45080.18846632577-284.788466325774
425391.15181.38733059569209.712669404312
435213.95065.29701784031148.602982159690
4454155655.4803519969-240.480351996901
455990.35862.58043996156127.719560038441
464241.84397.89034780484-156.090347804836
475677.65546.03235954719131.567640452809
485164.25264.71589430867-100.515894308673
493962.34292.23300229213-329.933002292131
5040113991.3461493905619.653850609443
513310.33359.67498703456-49.3749870345644
523837.33581.28927028782256.010729712184
534145.34067.6245425933177.6754574066904
543796.73777.3655299119319.3344700880675
553849.63977.41628767594-127.816287675937
5642854245.0990948392539.9009051607516
574189.64460.60093339572-271.000933395723


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.1009157252451310.2018314504902610.89908427475487
220.05431068229165860.1086213645833170.945689317708341
230.0748278359221450.149655671844290.925172164077855
240.03379219116589020.06758438233178030.96620780883411
250.114068062674760.228136125349520.88593193732524
260.1457694008691190.2915388017382370.854230599130881
270.08843856423298830.1768771284659770.911561435767012
280.08905313138102260.1781062627620450.910946868618977
290.160909551068920.321819102137840.83909044893108
300.1277172305722200.2554344611444410.87228276942778
310.1189983084901310.2379966169802620.881001691509869
320.0797888301473940.1595776602947880.920211169852606
330.08362730781495830.1672546156299170.916372692185042
340.1376513718889140.2753027437778280.862348628111086
350.2962048404678940.5924096809357890.703795159532106
360.1699515340027770.3399030680055540.830048465997223


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