Multiple Linear Regression - Estimated Regression Equation
BeurswaardeAandelen [t] = + 22841154.2010123 -181.481421032267Beroepsbevolking[t] -973.839663571263Werkloosheid[t] + 338.557105254209Faillisementen[t] -3685.27071944568Faillisementennijverheid[t] -1.25949859485318Bevolkingsaantal[t] + 527.407825420693Nijverheid[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)22841154.20101235649403.876674.04310.0001728.6e-05
Beroepsbevolking-181.481421032267222.781793-0.81460.4189380.209469
Werkloosheid-973.839663571263406.888424-2.39340.0202670.010134
Faillisementen338.557105254209233.3255041.4510.1526710.076336
Faillisementennijverheid-3685.270719445681434.561248-2.56890.0130530.006527
Bevolkingsaantal-1.259498594853180.423565-2.97360.0044220.002211
Nijverheid527.4078254206931582.4954580.33330.7402410.37012


Multiple Linear Regression - Regression Statistics
Multiple R0.818018419458674
R-squared0.669154134573666
Adjusted R-squared0.631699885657478
F-TEST (value)17.8659071784094
F-TEST (DF numerator)6
F-TEST (DF denominator)53
p-value3.38754579942702e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation100388.301564770
Sum Squared Residuals534123987826.143


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1508643634866.728873536-126223.728873536
2527568618169.52706869-90601.5270686903
3520008621939.914750301-101931.914750301
4498484601829.293053636-103345.293053636
5523917633515.86399048-109598.863990480
6553522590883.067360497-37361.0673604974
7558901566527.340206094-7626.34020609372
8548933588250.655739983-39317.6557399831
9567013511421.93045335755591.0695466426
10551085611140.219430094-60055.219430094
11588245637247.10510198-49002.1051019807
12605010606013.94422466-1003.94422466059
13631572625660.8006694135911.19933058667
14639180618694.59484368720485.4051563130
15653847653598.093004048248.906995952058
16657073662926.750018585-5853.75001858501
17626291653220.367656568-26929.3676565679
18625616612366.2302313913249.7697686102
19633352633571.151806943-219.151806942946
20672820677844.889657549-5024.88965754921
21691369694995.817022386-3626.81702238586
22702595669316.82331302233278.1766869775
23692241663236.17629774429004.8237022564
24718722690657.2172328928064.7827671105
25732297618051.728076325114245.271923675
26721798603896.808137561117901.191862439
27766192656963.14817614109228.851823859
28788456642398.916854847146057.083145153
29806132641966.942974978164165.057025022
30813944639204.000391422174739.999608578
31788025603670.250733363184354.749266637
32765985661714.752648578104270.247351422
33702684625501.20283042177182.7971695794
34730159597550.474369709132608.525630291
35678942574796.900339135104145.099660865
36672527622925.493459249601.5065407997
37594783635883.634968665-41100.6349686652
38594575563967.74910996230607.2508900381
39576299572688.0000184723610.99998152829
40530770567468.69359349-36698.6935934899
41524491551488.273074620-26997.2730746196
42456590511481.245151839-54891.2451518388
43428448524143.114662043-95695.1146620431
44444937545434.664974553-100497.664974553
45372206529307.241862035-157101.241862035
46317272528012.485033005-210740.485033005
47297604463116.098225519-165512.098225519
48288561495081.178152147-206520.178152147
49289287392028.600216541-102741.600216541
50258923338922.083271693-79999.0832716933
51255493270283.781469577-14790.7814695774
52277992405137.387920188-127145.387920188
53295474381362.399566272-85888.3995662715
54291680199112.90307252192567.0969274794
55318736282880.96768410435855.0323158961
56338463256264.18230633482198.8176936664
57351963272095.29738065979867.7026193414
58347240272510.22109380674729.778906194
59347081285005.33068809862075.6693119015
60383486235291.345504642148194.654495358


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
100.003601204966868740.007202409933737480.996398795033131
110.0009662774571866470.001932554914373290.999033722542813
120.0001881996221513970.0003763992443027950.999811800377849
130.0002416246798216870.0004832493596433740.999758375320178
146.95606049210073e-050.0001391212098420150.99993043939508
152.71572824626983e-055.43145649253967e-050.999972842717537
160.0002029515422238810.0004059030844477610.999797048457776
177.71503554052705e-050.0001543007108105410.999922849644595
183.12268938005312e-056.24537876010625e-050.9999687731062
191.85650243927284e-053.71300487854567e-050.999981434975607
207.67097457637961e-061.53419491527592e-050.999992329025424
213.40749049108725e-066.8149809821745e-060.99999659250951
221.64810334680115e-063.29620669360229e-060.999998351896653
231.14346609068445e-062.28693218136890e-060.99999885653391
244.74424303711346e-079.48848607422693e-070.999999525575696
253.95248809929059e-077.90497619858119e-070.99999960475119
261.56140299079308e-063.12280598158616e-060.99999843859701
272.40217392980883e-064.80434785961766e-060.99999759782607
287.33116681631883e-061.46623336326377e-050.999992668833184
298.60262032480446e-061.72052406496089e-050.999991397379675
303.25597484735795e-066.5119496947159e-060.999996744025153
312.69373175291001e-065.38746350582001e-060.999997306268247
328.66806301226027e-050.0001733612602452050.999913319369877
330.01570681005863420.03141362011726850.984293189941366
340.08367499761031030.1673499952206210.91632500238969
350.2343384825727730.4686769651455460.765661517427227
360.4650074095557910.9300148191115820.534992590444209
370.8307172729386240.3385654541227520.169282727061376
380.8162024542728130.3675950914543740.183797545727187
390.7863018212231230.4273963575537540.213698178776877
400.8904672372446430.2190655255107140.109532762755357
410.8511534000216550.2976931999566910.148846599978346
420.8660909355452480.2678181289095040.133909064454752
430.9081534218382530.1836931563234950.0918465781617475
440.990154400467240.01969119906552010.00984559953276003
450.9999737553267485.24893465037909e-052.62446732518954e-05
460.9999229369119320.000154126176136197.7063088068095e-05
470.999695855527680.0006082889446391350.000304144472319568
480.999482444048060.001035111903880370.000517555951940183
490.9987813738025050.002437252394990230.00121862619749511
500.9939232136475180.01215357270496390.00607678635248193


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