Multiple Linear Regression - Estimated Regression Equation |
totaal[t] = + 30804.5369680775 -23401252.9732768jaar[t] + 0.870436647176309vlaams_man[t] + 1.09619421051282vlaams_vrouw[t] + 1.08567272568283waals_man[t] + 0.972768756511784waals_vrouw[t] + 0.909537250570316brussel_man[t] + 1.13627288054705brussel_vrouw[t] -15.1769126220416t + e[t] |
Multiple Linear Regression - Ordinary Least Squares | |||||
Variable | Parameter | S.D. | T-STAT H0: parameter = 0 | 2-tail p-value | 1-tail p-value |
(Intercept) | 30804.5369680775 | 17412.998433 | 1.7691 | 0.084323 | 0.042162 |
jaar | -23401252.9732768 | 13217986.10236 | -1.7704 | 0.084094 | 0.042047 |
vlaams_man | 0.870436647176309 | 0.08397 | 10.3661 | 0 | 0 |
vlaams_vrouw | 1.09619421051282 | 0.083069 | 13.1961 | 0 | 0 |
waals_man | 1.08567272568283 | 0.065387 | 16.6037 | 0 | 0 |
waals_vrouw | 0.972768756511784 | 0.073952 | 13.1541 | 0 | 0 |
brussel_man | 0.909537250570316 | 0.067987 | 13.3781 | 0 | 0 |
brussel_vrouw | 1.13627288054705 | 0.072378 | 15.6992 | 0 | 0 |
t | -15.1769126220416 | 8.526204 | -1.78 | 0.082483 | 0.041242 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.999998996517776 |
R-squared | 0.999997993036559 |
Adjusted R-squared | 0.999997601433936 |
F-TEST (value) | 2553603.92142985 |
F-TEST (DF numerator) | 8 |
F-TEST (DF denominator) | 41 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 0.61079340580206 |
Sum Squared Residuals | 15.2958119674225 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 9190 | 9189.77347683671 | 0.226523163287704 |
2 | 9251 | 9250.81170179836 | 0.188298201637033 |
3 | 9328 | 9328.6444564847 | -0.644456484702895 |
4 | 9428 | 9428.66738234806 | -0.66738234806104 |
5 | 9499 | 9498.92433315414 | 0.0756668458610427 |
6 | 9556 | 9555.93466926213 | 0.0653307378749467 |
7 | 9606 | 9604.94429100204 | 1.0557089979562 |
8 | 9632 | 9631.30155216273 | 0.698447837264957 |
9 | 9660 | 9660.06217742192 | -0.0621774219207797 |
10 | 9651 | 9650.92597128438 | 0.0740287156173079 |
11 | 9695 | 9695.87356337378 | -0.873563373777729 |
12 | 9727 | 9727.10634819719 | -0.106348197191145 |
13 | 9757 | 9757.31898316549 | -0.318983165493528 |
14 | 9788 | 9788.09302892045 | -0.0930289204474411 |
15 | 9813 | 9811.78879632419 | 1.21120367581114 |
16 | 9823 | 9822.87960361499 | 0.120396385009302 |
17 | 9837 | 9836.89835953629 | 0.101640463713074 |
18 | 9842 | 9842.02400156293 | -0.024001562932786 |
19 | 9855 | 9856.19935081646 | -1.19935081645882 |
20 | 9863 | 9864.28919610798 | -1.28919610797912 |
21 | 9855 | 9854.34405747037 | 0.655942529625127 |
22 | 9858 | 9858.16578246824 | -0.165782468244185 |
23 | 9853 | 9853.22964265127 | -0.229642651268907 |
24 | 9858 | 9857.41919079922 | 0.58080920078305 |
25 | 9859 | 9858.47772194346 | 0.522278056542202 |
26 | 9865 | 9864.30344995278 | 0.696550047222603 |
27 | 9876 | 9876.31011019002 | -0.310110190018058 |
28 | 9928 | 9927.5636461118 | 0.436353888201801 |
29 | 9948 | 9948.5570433318 | -0.55704333179597 |
30 | 9987 | 9988.15926161825 | -1.1592616182492 |
31 | 10022 | 10022.0000787662 | -7.8766211996077e-05 |
32 | 10068 | 10067.9821576312 | 0.0178423688248848 |
33 | 10101 | 10100.8798612419 | 0.120138758075812 |
34 | 10131 | 10130.6732258955 | 0.326774104470233 |
35 | 10143 | 10142.7649391672 | 0.235060832832552 |
36 | 10170 | 10169.6104478578 | 0.389552142152874 |
37 | 10192 | 10191.5864536743 | 0.413546325707174 |
38 | 10214 | 10213.5482560299 | 0.451743970071526 |
39 | 10239 | 10239.5981731885 | -0.598173188471221 |
40 | 10263 | 10262.744154882 | 0.255845117979388 |
41 | 10310 | 10309.9201642322 | 0.0798357678287411 |
42 | 10355 | 10355.5766416934 | -0.576641693397184 |
43 | 10396 | 10396.0256857544 | -0.0256857543607167 |
44 | 10446 | 10446.0862200922 | -0.0862200921823565 |
45 | 10511 | 10511.2845894911 | -0.284589491120514 |
46 | 10585 | 10584.065609849 | 0.934390151005746 |
47 | 10667 | 10667.0372692159 | -0.0372692158626008 |
48 | 10753 | 10753.8935098748 | -0.89350987480154 |
49 | 10840 | 10840.3340036275 | -0.334003627516723 |
50 | 10951 | 10950.3974079229 | 0.602592077110022 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
12 | 0.426155624448077 | 0.852311248896154 | 0.573844375551923 |
13 | 0.279084312238462 | 0.558168624476924 | 0.720915687761538 |
14 | 0.288219859976913 | 0.576439719953826 | 0.711780140023087 |
15 | 0.30745934464137 | 0.614918689282739 | 0.69254065535863 |
16 | 0.276177609322577 | 0.552355218645155 | 0.723822390677423 |
17 | 0.224257766897938 | 0.448515533795875 | 0.775742233102062 |
18 | 0.307821109235839 | 0.615642218471678 | 0.692178890764161 |
19 | 0.269643415191122 | 0.539286830382244 | 0.730356584808878 |
20 | 0.292667936291326 | 0.585335872582653 | 0.707332063708674 |
21 | 0.563491788957937 | 0.873016422084127 | 0.436508211042064 |
22 | 0.554098226757133 | 0.891803546485734 | 0.445901773242867 |
23 | 0.620463255931296 | 0.759073488137407 | 0.379536744068704 |
24 | 0.556634964384487 | 0.886730071231027 | 0.443365035615513 |
25 | 0.606655680740953 | 0.786688638518093 | 0.393344319259047 |
26 | 0.595472278661484 | 0.809055442677032 | 0.404527721338516 |
27 | 0.76358543229852 | 0.47282913540296 | 0.23641456770148 |
28 | 0.868559884791257 | 0.262880230417485 | 0.131440115208743 |
29 | 0.870960914547067 | 0.258078170905865 | 0.129039085452933 |
30 | 0.80812310596933 | 0.383753788061341 | 0.19187689403067 |
31 | 0.86744197116106 | 0.26511605767788 | 0.13255802883894 |
32 | 0.875295288383251 | 0.249409423233497 | 0.124704711616749 |
33 | 0.833362315600216 | 0.333275368799568 | 0.166637684399784 |
34 | 0.760634505220777 | 0.478730989558446 | 0.239365494779223 |
35 | 0.693326222989381 | 0.613347554021238 | 0.306673777010619 |
36 | 0.575783531385641 | 0.848432937228717 | 0.424216468614359 |
37 | 0.50487749289238 | 0.990245014215239 | 0.49512250710762 |
38 | 0.360342707844356 | 0.720685415688711 | 0.639657292155644 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 0 | 0 | OK |
5% type I error level | 0 | 0 | OK |
10% type I error level | 0 | 0 | OK |