Multiple Linear Regression - Estimated Regression Equation
Consumptieindexprijs[t] = + 103.373409090909 + 0.0529318181817703M1[t] + 0.392545454545451M2[t] + 0.312159090909086M3[t] + 0.493772727272725M4[t] + 0.627386363636359M5[t] + 0.510999999999996M6[t] + 0.596613636363628M7[t] + 0.350227272727270M8[t] + 0.169840909090903M9[t] + 0.0514545454545356M10[t] + 0.0953863636363579M11[t] + 0.190386363636364t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)103.3734090909090.679554152.119400
M10.05293181818177030.8244230.06420.9490920.474546
M20.3925454545454510.8239040.47640.6360620.318031
M30.3121590909090860.82350.37910.7064230.353212
M40.4937727272727250.8232120.59980.551640.27582
M50.6273863636363590.8230390.76230.449870.224935
M60.5109999999999960.8229810.62090.5377890.268895
M70.5966136363636280.8230390.72490.4722710.236136
M80.3502272727272700.8232120.42540.6725440.336272
M90.1698409090909030.82350.20620.8375320.418766
M100.05145454545453560.8239040.06250.9504790.47524
M110.09538636363635790.8675530.10990.9129390.456469
t0.1903863636363640.00974819.531200


Multiple Linear Regression - Regression Statistics
Multiple R0.947165971215957
R-squared0.897123377029467
Adjusted R-squared0.869689610903991
F-TEST (value)32.7014297973613
F-TEST (DF numerator)12
F-TEST (DF denominator)45
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1.22682766565322
Sum Squared Residuals67.7297754545456


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1103.48103.616727272727-0.136727272727445
2103.93104.146727272727-0.216727272727259
3103.89104.256727272727-0.366727272727266
4104.4104.628727272727-0.228727272727262
5104.79104.952727272727-0.162727272727259
6104.77105.026727272727-0.256727272727271
7105.13105.302727272727-0.172727272727268
8105.26105.2467272727270.0132727272727364
9104.96105.256727272727-0.296727272727272
10104.75105.328727272727-0.578727272727262
11105.01105.563045454545-0.553045454545445
12105.15105.658045454545-0.508045454545449
13105.2105.901363636364-0.70136363636359
14105.77106.431363636364-0.661363636363637
15105.78106.541363636364-0.761363636363631
16106.26106.913363636364-0.65336363636363
17106.13107.237363636364-1.10736363636364
18106.12107.311363636364-1.19136363636363
19106.57107.587363636364-1.01736363636364
20106.44107.531363636364-1.09136363636364
21106.54107.541363636364-1.00136363636363
22107.1107.613363636364-0.513363636363634
23108.1107.8476818181820.252318181818179
24108.4107.9426818181820.457318181818184
25108.84108.1860.654000000000048
26109.62108.7160.904000000000005
27110.42108.8261.59400000000000
28110.67109.1981.472
29111.66109.5222.13800000000000
30112.28109.5962.684
31112.87109.8722.99800000000001
32112.18109.8162.36400000000000
33112.36109.8262.534
34112.16109.8982.262
35111.49110.1323181818181.35768181818181
36111.25110.2273181818181.02268181818181
37111.36110.4706363636360.889363636363678
38111.74111.0006363636360.739363636363628
39111.1111.110636363636-0.0106363636363711
40111.33111.482636363636-0.152636363636371
41111.25111.806636363636-0.556636363636368
42111.04111.880636363636-0.840636363636362
43110.97112.156636363636-1.18663636363636
44111.31112.100636363636-0.790636363636367
45111.02112.110636363636-1.09063636363637
46111.07112.182636363636-1.11263636363637
47111.36112.416954545455-1.05695454545455
48111.54112.511954545455-0.971954545454548
49112.05112.755272727273-0.705272727272692
50112.52113.285272727273-0.765272727272738
51112.94113.395272727273-0.455272727272735
52113.33113.767272727273-0.437272727272737
53113.78114.091272727273-0.311272727272733
54113.77114.165272727273-0.395272727272737
55113.82114.441272727273-0.621272727272739
56113.89114.385272727273-0.495272727272736
57114.25114.395272727273-0.145272727272733
58114.41114.467272727273-0.0572727272727344


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
167.30168962605973e-050.0001460337925211950.99992698310374
170.0003740243745605400.0007480487491210810.99962597562544
180.0001419882028783810.0002839764057567610.999858011797122
193.22493177008497e-056.44986354016994e-050.9999677506823
202.45812555089469e-054.91625110178938e-050.999975418744491
218.11282689917961e-061.62256537983592e-050.9999918871731
226.12792521584869e-050.0001225585043169740.999938720747842
230.00163772444691810.00327544889383620.998362275553082
240.006825882363013270.01365176472602650.993174117636987
250.02557232932745830.05114465865491670.974427670672542
260.05051238100500030.1010247620100010.949487618995
270.1189009809164200.2378019618328390.88109901908358
280.1323835349069000.2647670698137990.8676164650931
290.2051550816513260.4103101633026520.794844918348674
300.349546190620350.69909238124070.65045380937965
310.5587258082185550.882548383562890.441274191781445
320.5961099715400020.8077800569199960.403890028459998
330.7027607216428580.5944785567142840.297239278357142
340.8069888106062450.3860223787875100.193011189393755
350.8745455518735770.2509088962528470.125454448126423
360.9260517929408680.1478964141182640.073948207059132
370.9631852906929640.07362941861407240.0368147093070362
380.9953124966866280.00937500662674330.00468750331337165
390.9969308566086850.006138286782629890.00306914339131495
400.998536454732610.00292709053478120.0014635452673906
410.9966739169198790.006652166160242730.00332608308012136
420.9878963294825820.02420734103483600.0121036705174180


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level120.444444444444444NOK
5% type I error level140.518518518518518NOK
10% type I error level160.592592592592593NOK