Multiple Linear Regression - Estimated Regression Equation
Consumentenvertrouwen[t] = + 93.1815812337098 -33.2632493483927Dummy[t] -0.870981754995648M1[t] -2.61476976542136M2[t] -2.35855777584706M3[t] -9.95499565595133M4[t] -5.04613379669851M5[t] -3.38992180712423M6[t] -2.73370981754994M7[t] -1.07749782797566M8[t] -1.22128583840137M9[t] + 2.28757602085144M10[t] + 0.943788010425726M11[t] -0.256211989574283t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)93.18158123370985.79924716.067900
Dummy-33.26324934839273.570317-9.316600
M1-0.8709817549956487.054806-0.12350.9022810.451141
M2-2.614769765421367.045201-0.37110.7122360.356118
M3-2.358557775847067.03705-0.33520.7390260.369513
M4-9.954995655951337.092537-1.40360.1671570.083578
M5-5.046133796698517.025131-0.71830.4762070.238103
M6-3.389921807124237.021371-0.48280.6315270.315764
M7-2.733709817549947.01908-0.38950.6987270.349364
M8-1.077497827975667.01826-0.15350.8786540.439327
M9-1.221285838401377.018912-0.1740.862630.431315
M102.287576020851446.9962790.3270.7451740.372587
M110.9437880104257266.9940650.13490.8932470.446624
t-0.2562119895742830.101625-2.52120.0152260.007613


Multiple Linear Regression - Regression Statistics
Multiple R0.89104115125093
R-squared0.793954333222582
Adjusted R-squared0.735724036089833
F-TEST (value)13.6347292099951
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value1.0915823800417e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation11.0574195977528
Sum Squared Residuals5624.26029539531


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
18492.05438748914-8.05438748913993
27890.05438748914-12.0543874891399
37490.0543874891399-16.0543874891399
47582.2017376194613-7.20173761946134
57986.8543874891399-7.85438748913987
67988.2543874891399-9.25438748913988
78288.6543874891399-6.65438748913987
88890.0543874891399-2.05438748913987
98189.6543874891399-8.65438748913987
106959.64378801042579.35621198957428
116258.04378801042573.95621198957428
126256.84378801042575.15621198957431
136855.716594265855812.2834057341442
145753.71659426585583.28340573414423
156753.716594265855813.2834057341442
167279.12719374457-7.12719374456993
177583.7798436142485-8.77984361424848
188185.1798436142485-4.17984361424847
198085.5798436142485-5.57984361424847
207986.9798436142485-7.97984361424848
218186.5798436142485-5.57984361424848
228389.832493483927-6.83249348392702
238488.232493483927-4.23249348392701
249087.0324934839272.96750651607299
258485.905299739357-1.90529973935707
269083.9052997393576.09470026064293
279283.90529973935718.0947002606429
289376.052649869678516.9473501303215
298580.7052997393574.29470026064292
309382.10529973935710.8947002606429
319482.50529973935711.4947002606429
329483.90529973935710.0947002606429
3310283.50529973935718.4947002606429
349686.75794960903569.24205039096438
359685.157949609035610.8420503909644
369283.95794960903568.0420503909644
379082.83075586446577.16924413553433
388480.83075586446573.16924413553433
398680.83075586446575.1692441355343
407072.9781059947871-2.97810599478714
416744.36750651607322.632493483927
426045.76750651607314.232493483927
436246.16750651607315.832493483927
446147.56750651607313.4324934839270
455447.1675065160736.83249348392702
465050.4201563857515-0.420156385751522
474548.8201563857515-3.82015638575152
483447.6201563857515-13.6201563857515
493746.4929626411816-9.49296264118157
504444.4929626411816-0.492962641181577
513444.4929626411816-10.4929626411816
523736.64031277150300.359687228496953
533141.2929626411816-10.2929626411816
543142.6929626411816-11.6929626411816
552843.0929626411816-15.0929626411816
563144.4929626411816-13.4929626411816
573344.0929626411816-11.0929626411816
583647.3456125108601-11.3456125108601
593945.7456125108601-6.74561251086012
604244.5456125108601-2.54561251086011


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.06590472410639680.1318094482127940.934095275893603
180.02971116114946990.05942232229893980.97028883885053
190.01036726350807710.02073452701615420.989632736491923
200.008809577736853520.01761915547370700.991190422263146
210.005055766325012520.01011153265002500.994944233674987
220.003248479798500010.006496959597000020.9967515202015
230.007270577728288940.01454115545657790.992729422271711
240.01824707019312410.03649414038624830.981752929806876
250.01427950029425290.02855900058850590.985720499705747
260.04570517717638830.09141035435277670.954294822823612
270.05351491194890170.1070298238978030.946485088051098
280.1091177375879140.2182354751758280.890882262412086
290.1153432804967950.2306865609935910.884656719503204
300.09533125659925730.1906625131985150.904668743400743
310.07310283019708740.1462056603941750.926897169802913
320.05085567913759380.1017113582751880.949144320862406
330.06485027313430170.1297005462686030.935149726865698
340.03904033285892310.07808066571784620.960959667141077
350.02412114882640900.04824229765281790.97587885117359
360.01288943574833360.02577887149666730.987110564251666
370.01032142466526850.02064284933053700.989678575334731
380.006913515538687160.01382703107737430.993086484461313
390.00748761891004480.01497523782008960.992512381089955
400.01413976207047360.02827952414094730.985860237929526
410.01547735605066870.03095471210133740.984522643949331
420.01573741910024650.0314748382004930.984262580899753
430.03223844156879170.06447688313758340.967761558431208


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0370370370370370NOK
5% type I error level150.555555555555556NOK
10% type I error level190.703703703703704NOK