Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 93124.3064063537 + 0.595245145625902X[t] + 1460.64625979357M1[t] + 2625.50165379033M2[t] + 2063.61079494683M3[t] + 2144.30079128605M4[t] -474.914587784631M5[t] -4747.33433857108M6[t] -1131.23893509993M7[t] -6743.02998141279M8[t] -2789.33139941479M9[t] -2464.15797519326M10[t] -2133.01676893371M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)93124.306406353716338.1647575.69981e-060
X0.5952451456259020.05433610.95500
M11460.646259793575794.1316530.25210.8019280.400964
M22625.501653790335795.4211350.4530.6523420.326171
M32063.610794946835807.0311470.35540.7237010.361851
M42144.300791286055824.9078860.36810.7142180.357109
M5-474.9145877846315858.378469-0.08110.9356890.467845
M6-4747.334338571085827.960201-0.81460.4188910.209446
M7-1131.238935099935878.16325-0.19240.8481130.424057
M8-6743.029981412796229.689339-1.08240.2838840.141942
M9-2789.331399414796141.928098-0.45410.6515440.325772
M10-2464.157975193266073.938233-0.40570.6865710.343285
M11-2133.016768933716051.646679-0.35250.7258590.362929


Multiple Linear Regression - Regression Statistics
Multiple R0.860025172821497
R-squared0.739643297886646
Adjusted R-squared0.681786252972568
F-TEST (value)12.7839798763498
F-TEST (DF numerator)12
F-TEST (DF denominator)54
p-value7.89301957127009e-12
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation9568.45326181193
Sum Squared Residuals4943986082.46788


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1267413270129.889052973-2716.88905297294
2267366270447.115359599-3081.11535959852
3264777268139.370488634-3362.37048863429
4258863264756.328982576-5893.32898257637
5254844260400.188268569-5556.18826856933
6254868259720.668216781-4852.66821678082
7277267280247.082962338-2980.08296233820
8285351280081.1897533575269.81024664329
9286602284391.4401775852210.55982241537
10283042286068.415327523-3026.41532752258
11276687279969.718470731-3282.71847073114
12277915282137.854703257-4222.85470325678
13277128281335.378919381-4207.37891938067
14277103281630.581155618-4527.58115561799
15275037279351.408051644-4314.40805164376
16270150275598.124065007-5448.12406500655
17267140271411.032972357-4271.03297235725
18264993269352.329918154-4359.32991815353
19287259290493.037653997-3234.03765399685
20291186287394.3716125173791.62838748346
21292300290296.8672673392003.1327326608
22288186283478.5036989044707.49630109572
23281477277854.8124683223622.18753167769
24282656280319.9760285152336.02397148472
25280190281026.446688801-836.446688800826
26280408280075.800835243332.199164756861
27276836275525.1722555601310.82774443953
28275216273240.3580431821975.64195681765
29274352270284.2339116874067.76608831259
30271311267921.3605880693389.63941193114
31289802288284.0829185791517.91708142087
32290726285837.8055567054888.19444329519
33292300285346.8086363146953.1913636858
34278506274661.7326018933844.26739810657
35269826267133.8521504542692.1478495458
36265861266586.480028634-725.480028634476
37269034268123.912912214910.087087786215
38264176265203.005626634-1027.00562663437
39255198259758.318838222-4560.31883822159
40253353257512.195560309-4159.19556030916
41246057250378.045751666-4321.04575166602
42235372245099.066459626-9727.06645962618
43258556268665.398163895-10109.3981638950
44260993267096.512146673-6103.5121466733
45254663261166.760330699-6503.76033069883
46250643255201.978301091-4558.97830109146
47243422249578.882315655-6156.88231565511
48247105252145.83279575-5040.8327957501
49248541254337.440094372-5796.44009437228
50245039252014.754180147-6975.75418014688
51237080247298.052204835-10218.0522048346
52237085245959.677774002-8874.67777400166
53225554237771.944057601-12217.9440576007
54226839237629.335127167-10790.3351271667
55247934258926.592336310-10992.5923363097
56248333256179.120930749-7846.12093074864
57246969251632.123588063-4663.12358806314
58245098246064.370070588-966.370070588245
59246263243137.7345948373125.26540516277
60255765248111.8564438437653.14355615663
61264319251671.93233225912647.0676677405
62268347253067.74284275915279.2571572409
63273046251901.67816110521144.3218388947
64273963251563.31557492422399.6844250761
65267430245131.55503811922298.4449618807
66271993245653.23969020426339.7603097961
67292710266911.80596488125798.1940351189


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.0002727403066822880.0005454806133645760.999727259693318
178.40239482044959e-050.0001680478964089920.999915976051795
187.49170597548235e-061.49834119509647e-050.999992508294025
194.92950080567018e-079.85900161134036e-070.99999950704992
205.98715748209359e-081.19743149641872e-070.999999940128425
213.62299972378704e-097.24599944757409e-090.999999996377
222.10110891749833e-064.20221783499666e-060.999997898891082
233.95714747858896e-067.91429495717792e-060.999996042852521
243.70853660413269e-067.41707320826538e-060.999996291463396
251.19816370468405e-062.39632740936809e-060.999998801836295
265.85719310664065e-071.17143862132813e-060.99999941428069
273.79400249429956e-077.58800498859913e-070.99999962059975
286.51165243118333e-071.30233048623667e-060.999999348834757
291.29136350023109e-062.58272700046217e-060.9999987086365
301.29952461265898e-062.59904922531795e-060.999998700475387
315.39656413898947e-071.07931282779789e-060.999999460343586
321.45978497106152e-072.91956994212303e-070.999999854021503
336.76760033735602e-081.35352006747120e-070.999999932323997
342.27338012034522e-084.54676024069044e-080.999999977266199
356.51820861675371e-091.30364172335074e-080.999999993481791
361.53816005183794e-093.07632010367588e-090.99999999846184
374.89495386889852e-109.78990773779704e-100.999999999510505
381.24912743062200e-102.49825486124401e-100.999999999875087
394.88148937542593e-119.76297875085186e-110.999999999951185
401.89791477030563e-113.79582954061126e-110.99999999998102
419.34239246869916e-121.86847849373983e-110.999999999990658
422.21511899107560e-114.43023798215119e-110.999999999977849
431.08375414951116e-102.16750829902233e-100.999999999891625
442.56484865842372e-105.12969731684744e-100.999999999743515
454.75735421326044e-109.51470842652088e-100.999999999524265
462.34334157908895e-094.68668315817789e-090.999999997656658
477.47462107226761e-081.49492421445352e-070.99999992525379
485.70879206197699e-061.14175841239540e-050.999994291207938
490.01811501335689920.03623002671379840.9818849866431
500.3826833305956540.7653666611913080.617316669404346
510.7985567728828160.4028864542343690.201443227117184


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level330.916666666666667NOK
5% type I error level340.944444444444444NOK
10% type I error level340.944444444444444NOK