Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 7218.81321367391 + 0.168547715381535X[t] + 0.979872427652679Y1[t] + 0.137046798716369Y2[t] + 0.0699500275999237Y3[t] -0.406984626398871Y4[t] -1804.08726665933M1[t] + 1408.97397886702M2[t] + 18831.5706048898M3[t] -822.813077601211M4[t] -8320.63177610417M5[t] -14608.2217206370M6[t] -4583.64714859553M7[t] + 5149.13242714079M8[t] + 5625.48810387275M9[t] + 1211.36402069791M10[t] -3453.02634995847M11[t] + 72.3725529323416t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)7218.8132136739113548.2960590.53280.5967790.29839
X0.1685477153815350.0964251.7480.0872910.043645
Y10.9798724276526790.138957.05200
Y20.1370467987163690.2026690.67620.5023680.251184
Y30.06995002759992370.2084330.33560.7387330.369367
Y4-0.4069846263988710.142958-2.84690.0066290.003314
M1-1804.087266659332222.876655-0.81160.4212930.210647
M21408.973978867022207.6600130.63820.5265650.263282
M318831.57060488984106.9883874.58533.6e-051.8e-05
M4-822.8130776012115548.036122-0.14830.8827630.441382
M5-8320.631776104174502.43792-1.8480.0711770.035588
M6-14608.22172063703618.16973-4.03750.0002080.000104
M7-4583.647148595532233.34681-2.05240.0459780.022989
M85149.132427140792384.7002572.15920.03620.0181
M95625.488103872752819.125211.99550.0520670.026033
M101211.364020697912713.9171920.44640.6574830.328742
M11-3453.026349958472233.000971-1.54640.1290220.064511
t72.372552932341668.6221671.05470.2972140.148607


Multiple Linear Regression - Regression Statistics
Multiple R0.985779580101678
R-squared0.97176138054544
Adjusted R-squared0.961093457640385
F-TEST (value)91.0919013189444
F-TEST (DF numerator)17
F-TEST (DF denominator)45
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3446.92213769629
Sum Squared Residuals534657250.050334


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1254844252795.71419662048.28580340013
2254868252187.9276067412680.07239325895
3277267274583.8934207132683.10657928659
4285351280621.1548889414729.84511105919
5286602285925.018788635676.981211364627
6283042283983.32302366-941.323023660072
7276687280392.144806243-3705.14480624268
8277915280289.709133675-2374.70913367484
9277128279771.810018893-2643.8100188928
10277103275585.2769893211517.7230106786
11275037273046.9323060981990.06769390194
12270150272904.044975779-2754.0449757791
13267140265975.1484899361164.85151006359
14264993266133.905387976-1140.90538797611
15287259286573.775342432685.224657568355
16291186291005.35695062180.643049380156
17292300291256.5395995001043.46040050027
18288186287079.6450459881106.35495401205
19281477282824.689859679-1347.68985967947
20282656284065.812669368-1409.81266936802
21280190283895.658275904-3705.65827590387
22280408277905.1409521282502.85904787243
23276836274872.2706182761963.72938172408
24275216273605.3011482001610.69885180037
25274352270720.1371244713631.86287552912
26271311273139.062255319-1828.06225531923
27289802293618.182413021-3816.18241302057
28290726293233.44804961-2507.44804960997
29292300288127.9072747784172.09272522187
30278506282995.099444134-4489.09944413378
31269826270105.143575825-279.143575824519
32265861268489.656677261-2628.65667726102
33269034262379.8826910436654.11730895658
34264176264453.743995432-277.743995432311
35255198257409.033204932-2211.03320493236
36253353252648.156566013704.843433987028
37246057244968.5571895781088.44281042175
38235372241916.096192795-6544.09619279472
39258556257115.1304424611440.86955753896
40260993260171.443948526821.556051474032
41254663257734.617413691-3071.61741369118
42250643249840.099068033802.900931967098
43243422244179.406639836-757.406639836445
44247105245046.2379128572058.76208714311
45248541250716.211528677-2175.21152867679
46245039248429.74814862-3390.74814861993
47237080242623.015177727-5543.01517772657
48237085236069.3776469621015.62235303814
49225554230845.648026832-5291.64802683159
50226839224870.7700373191968.22996268103
51247934250290.670379149-2356.67037914903
52248333251557.596162303-3224.59616230341
53246969249789.916923396-2820.91692339559
54245098241576.8334181853521.1665818147
55246263240173.6151184176089.38488158311
56255765251410.5836068394354.41639316078
57264319262448.4374854831870.56251451689
58268347268699.089914499-352.089914498789
59273046269245.7486929673800.25130703291
60273963274540.119663046-577.119663046446
61267430270071.794972583-2641.79497258300
62271993267128.238519854864.76148015008
63292710291346.3480022241363.65199777570


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.3192396556394280.6384793112788560.680760344360572
220.1696758268614340.3393516537228670.830324173138566
230.08997818456618120.1799563691323620.910021815433819
240.07803612915022730.1560722583004550.921963870849773
250.05159626125085330.1031925225017070.948403738749147
260.02401262021657770.04802524043315540.975987379783422
270.01104398845668170.02208797691336340.988956011543318
280.01390060344510610.02780120689021230.986099396554894
290.007315354192827790.01463070838565560.992684645807172
300.5564005840843930.8871988318312130.443599415915607
310.729671652422560.540656695154880.27032834757744
320.8247302494315380.3505395011369240.175269750568462
330.7468391680147950.506321663970410.253160831985205
340.7447072489636150.510585502072770.255292751036385
350.7742182779620920.4515634440758160.225781722037908
360.7629600515806080.4740798968387840.237039948419392
370.822161891638960.355676216722080.17783810836104
380.9880376988769240.0239246022461510.0119623011230755
390.9896582889676380.02068342206472470.0103417110323624
400.9779876817436680.04402463651266480.0220123182563324
410.9419043803312920.1161912393374150.0580956196687076
420.8748950473891380.2502099052217230.125104952610861


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