Multiple Linear Regression - Estimated Regression Equation
Indexprijs[t] = + 186.456470588235 -12.2956209150327M1[t] -24.0112418300654M2[t] -21.8641176470589M3[t] -20.2569934640523M4[t] -4.50986928104575M5[t] + 8.97725490196074M6[t] + 22.2243790849673M7[t] + 40.2915032679738M8[t] + 44.6786274509804M9[t] + 35.8257516339870M10[t] + 18.9328758169935M11[t] + 1.55287581699346t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)186.45647058823538.4500534.84931.3e-057e-06
M1-12.295620915032744.841807-0.27420.7851080.392554
M2-24.011241830065447.066221-0.51020.6122780.306139
M3-21.864117647058947.006117-0.46510.6439390.32197
M4-20.256993464052346.952274-0.43140.6680820.334041
M5-4.5098692810457546.904715-0.09610.9238020.461901
M68.9772549019607446.8634580.19160.8488930.424447
M722.224379084967346.8285190.47460.6372310.318615
M840.291503267973846.7999140.86090.3935560.196778
M944.678627450980446.7776530.95510.3442990.172149
M1035.825751633987046.7617460.76610.4473480.223674
M1118.932875816993546.7521990.4050.6873040.343652
t1.552875816993460.5455142.84660.0064820.003241


Multiple Linear Regression - Regression Statistics
Multiple R0.503660876987238
R-squared0.253674279007554
Adjusted R-squared0.0670928487594425
F-TEST (value)1.35959017288175
F-TEST (DF numerator)12
F-TEST (DF denominator)48
p-value0.218275722619624
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation73.9166856665979
Sum Squared Residuals262256.468156863


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1149.8175.713725490196-25.9137254901962
2137.7165.550980392157-27.8509803921568
3151.7169.250980392157-17.5509803921568
4156.8172.410980392157-15.6109803921568
5180189.710980392157-9.71098039215681
6180.4204.750980392157-24.3509803921569
7170.4219.550980392157-49.1509803921568
8191.6239.170980392157-47.5709803921569
9199.5245.110980392157-45.6109803921567
10218.2237.810980392157-19.6109803921568
11217.5222.470980392157-4.97098039215689
12205205.090980392157-0.0909803921568542
13194194.348235294118-0.348235294117580
14199.3184.18549019607815.1145098039215
15219.3187.88549019607831.4145098039216
16211.1191.04549019607820.0545098039215
17215.2208.3454901960786.85450980392158
18240.2223.38549019607816.8145098039216
19242.2238.1854901960784.01450980392158
20240.7257.805490196078-17.1054901960784
21255.4263.745490196078-8.34549019607845
22253256.445490196078-3.44549019607845
23218.2241.105490196078-22.9054901960784
24203.7223.725490196078-20.0254901960784
25205.6212.982745098039-7.3827450980392
26215.6202.8212.7800000000000
27188.5206.52-18.02
28202.9209.68-6.78000000000001
29214226.98-12.9800000000000
30230.3242.02-11.7200000000000
31230256.82-26.82
32241276.44-35.44
33259.6282.38-22.78
34247.8275.08-27.28
35270.3259.7410.56
36289.7242.3647.34
37322.7231.61725490196191.0827450980393
38315221.45450980392293.5454901960784
39320.2225.15450980392295.0454901960784
40329.5228.314509803922101.185490196078
41360.6245.614509803922114.985490196078
42382.2260.654509803922121.545490196078
43435.4275.454509803922159.945490196078
44464295.074509803922168.925490196078
45468.8301.014509803922167.785490196078
46403293.714509803922109.285490196078
47351.6278.37450980392273.2254901960785
48252260.994509803922-8.99450980392156
49188250.251764705882-62.2517647058823
50146.5240.089019607843-93.5890196078431
51152.9243.789019607843-90.8890196078431
52148.1246.949019607843-98.8490196078431
53165.1264.249019607843-99.1490196078432
54177279.289019607843-102.289019607843
55206.1294.089019607843-87.9890196078431
56244.9313.709019607843-68.8090196078431
57228.6319.649019607843-91.0490196078432
58253.4312.349019607843-58.9490196078431
59241.1297.009019607843-55.9090196078431
60261.4279.629019607843-18.2290196078431
61273.7268.8862745098044.8137254901961


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.0007804901644778130.001560980328955630.999219509835522
170.0002538780934387210.0005077561868774410.999746121906561
182.57817939181908e-055.15635878363817e-050.999974218206082
195.58425863657065e-061.11685172731413e-050.999994415741363
206.04536223789105e-071.20907244757821e-060.999999395463776
215.31201894679895e-081.06240378935979e-070.99999994687981
221.74153591642974e-083.48307183285949e-080.99999998258464
232.44390843256174e-074.88781686512347e-070.999999755609157
244.21641227882270e-078.43282455764541e-070.999999578358772
252.08063058986654e-074.16126117973307e-070.99999979193694
264.16984492090240e-088.33968984180481e-080.99999995830155
279.16844287700599e-081.83368857540120e-070.999999908315571
283.74978251650155e-087.4995650330031e-080.999999962502175
291.56858798425946e-083.13717596851892e-080.99999998431412
305.41732713649657e-091.08346542729931e-080.999999994582673
312.43318218959333e-094.86636437918667e-090.999999997566818
321.93194310205314e-093.86388620410628e-090.999999998068057
331.78823086892251e-093.57646173784501e-090.99999999821177
346.11095551587227e-091.22219110317445e-080.999999993889044
351.69095799049995e-083.3819159809999e-080.99999998309042
361.54501463424023e-073.09002926848046e-070.999999845498537
378.86376561206864e-061.77275312241373e-050.999991136234388
381.65209022905853e-053.30418045811705e-050.99998347909771
392.04520744430858e-054.09041488861716e-050.999979547925557
402.31888948031983e-054.63777896063967e-050.999976811105197
414.02750683604052e-058.05501367208104e-050.99995972493164
427.25887105038182e-050.0001451774210076360.999927411289496
430.0007660284624849340.001532056924969870.999233971537515
440.005080843796725420.01016168759345080.994919156203275
450.05553992660302380.1110798532060480.944460073396976


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level280.933333333333333NOK
5% type I error level290.966666666666667NOK
10% type I error level290.966666666666667NOK