Multiple Linear Regression - Estimated Regression Equation |
Nettoschuld[t] = + 339556.817626675 -0.0481617613139515Fiscale_en_parafiscale_ontvangsten[t] -0.41758570531133`Niet-fiscale_en_niet-parafiscale_ontvangsten`[t] -0.0790146949532075Lopende_uitgaven_exclusief_rentelasten[t] -23.2607666632163Rentelasten[t] + 0.599914487831654Kapitaaluitgaven[t] + 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) | 339556.817626675 | 43292.692778 | 7.8433 | 0 | 0 |
Fiscale_en_parafiscale_ontvangsten | -0.0481617613139515 | 0.451468 | -0.1067 | 0.91535 | 0.457675 |
`Niet-fiscale_en_niet-parafiscale_ontvangsten` | -0.41758570531133 | 2.485849 | -0.168 | 0.867079 | 0.43354 |
Lopende_uitgaven_exclusief_rentelasten | -0.0790146949532075 | 0.728579 | -0.1085 | 0.913949 | 0.456974 |
Rentelasten | -23.2607666632163 | 6.586492 | -3.5316 | 0.000736 | 0.000368 |
Kapitaaluitgaven | 0.599914487831654 | 1.551211 | 0.3867 | 0.700122 | 0.350061 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.776717115423033 |
R-squared | 0.603289477391077 |
Adjusted R-squared | 0.57495301149044 |
F-TEST (value) | 21.2902159184751 |
F-TEST (DF numerator) | 5 |
F-TEST (DF denominator) | 70 |
p-value | 6.98996416303999e-13 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 11873.7191966773 |
Sum Squared Residuals | 9868964529.30806 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 186448 | 223850.3578924 | -37402.3578924003 |
2 | 190530 | 222628.689405778 | -32098.6894057780 |
3 | 194207 | 221593.689258388 | -27386.689258388 |
4 | 190855 | 221368.361561704 | -30513.3615617041 |
5 | 200779 | 222383.239116042 | -21604.2391160417 |
6 | 204428 | 220279.360383874 | -15851.3603838745 |
7 | 207617 | 219546.621962367 | -11929.621962367 |
8 | 212071 | 218724.037611438 | -6653.03761143846 |
9 | 214239 | 218192.062555591 | -3953.06255559139 |
10 | 215883 | 215876.634292575 | 6.36570742467802 |
11 | 223484 | 219143.025379718 | 4340.97462028204 |
12 | 221529 | 217477.278261563 | 4051.72173843671 |
13 | 225247 | 225246.919448628 | 0.080551371988804 |
14 | 226699 | 229961.679867304 | -3262.6798673044 |
15 | 231406 | 231769.459007616 | -363.459007616462 |
16 | 232324 | 230826.078951515 | 1497.92104848527 |
17 | 237192 | 230616.631950384 | 6575.36804961628 |
18 | 236727 | 229570.767302102 | 7156.23269789849 |
19 | 240698 | 230727.164619166 | 9970.83538083404 |
20 | 240688 | 226507.968742248 | 14180.0312577521 |
21 | 245283 | 230760.520211049 | 14522.4797889514 |
22 | 243556 | 230050.018810528 | 13505.9811894715 |
23 | 247826 | 230897.047078693 | 16928.9529213067 |
24 | 245798 | 237908.697233608 | 7889.30276639181 |
25 | 250479 | 235548.791802696 | 14930.2081973038 |
26 | 249216 | 236803.185517575 | 12412.8144824255 |
27 | 251896 | 238478.665643961 | 13417.3343560386 |
28 | 247616 | 238526.27777981 | 9089.72222018982 |
29 | 249994 | 237160.447137015 | 12833.5528629848 |
30 | 246552 | 236876.100888231 | 9675.89911176933 |
31 | 248771 | 238326.138925629 | 10444.8610743709 |
32 | 247551 | 239318.473651425 | 8232.52634857501 |
33 | 249745 | 239614.916296358 | 10130.0837036422 |
34 | 245742 | 240068.641526505 | 5673.35847349459 |
35 | 249019 | 242814.575073595 | 6204.42492640488 |
36 | 245841 | 242384.578292205 | 3456.42170779515 |
37 | 248771 | 240491.679916583 | 8279.32008341728 |
38 | 244723 | 238083.446192438 | 6639.55380756212 |
39 | 246878 | 238939.267528247 | 7938.7324717535 |
40 | 246014 | 238027.721812410 | 7986.27818758961 |
41 | 248496 | 236933.232743889 | 11562.7672561112 |
42 | 244351 | 236076.423486660 | 8274.57651334038 |
43 | 248016 | 237995.911208351 | 10020.0887916491 |
44 | 246509 | 239199.019377301 | 7309.98062269914 |
45 | 249426 | 243968.785715264 | 5457.21428473575 |
46 | 247840 | 244755.552081246 | 3084.44791875431 |
47 | 251035 | 247304.927010381 | 3730.07298961888 |
48 | 250161 | 245848.166831541 | 4312.83316845855 |
49 | 254278 | 245033.462034772 | 9244.53796522848 |
50 | 250801 | 250337.450957799 | 463.549042200902 |
51 | 253985 | 251394.782091362 | 2590.21790863771 |
52 | 249174 | 250463.335031752 | -1289.33503175163 |
53 | 251287 | 252734.414774885 | -1447.41477488469 |
54 | 247947 | 253429.429781653 | -5482.42978165259 |
55 | 249992 | 254006.324100502 | -4014.32410050215 |
56 | 243805 | 256414.71389525 | -12609.7138952501 |
57 | 255812 | 263543.240454638 | -7731.24045463797 |
58 | 250417 | 257732.044523120 | -7315.04452311954 |
59 | 253033 | 259853.506099276 | -6820.50609927579 |
60 | 248705 | 258553.030091642 | -9848.03009164182 |
61 | 253950 | 261577.913953915 | -7627.91395391518 |
62 | 251484 | 260320.213242624 | -8836.21324262386 |
63 | 251093 | 259665.740602664 | -8572.74060266441 |
64 | 245996 | 260299.155158584 | -14303.1551585843 |
65 | 252721 | 260513.092809361 | -7792.09280936113 |
66 | 248019 | 259136.899477625 | -11117.8994776250 |
67 | 250464 | 258111.475995655 | -7647.47599565544 |
68 | 245571 | 258558.569420600 | -12987.5694205996 |
69 | 252690 | 258273.540707740 | -5583.54070773964 |
70 | 250183 | 256796.938604200 | -6613.93860420041 |
71 | 253639 | 258581.520151416 | -4942.52015141574 |
72 | 254436 | 255365.479777894 | -929.479777894237 |
73 | 265280 | 259870.250695415 | 5409.74930458466 |
74 | 268705 | 261136.427392119 | 7568.57260788126 |
75 | 270643 | 262697.35422867 | 7945.64577133008 |
76 | 271480 | 261894.456601271 | 9585.54339872872 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
9 | 0.152602195862953 | 0.305204391725905 | 0.847397804137047 |
10 | 0.16160512073923 | 0.32321024147846 | 0.83839487926077 |
11 | 0.092544355257393 | 0.185088710514786 | 0.907455644742607 |
12 | 0.0859902519289038 | 0.171980503857808 | 0.914009748071096 |
13 | 0.068524248201107 | 0.137048496402214 | 0.931475751798893 |
14 | 0.0572816499632050 | 0.114563299926410 | 0.942718350036795 |
15 | 0.085963681658103 | 0.171927363316206 | 0.914036318341897 |
16 | 0.0738045198640143 | 0.147609039728029 | 0.926195480135986 |
17 | 0.0944724870850086 | 0.188944974170017 | 0.905527512914991 |
18 | 0.0822557791476055 | 0.164511558295211 | 0.917744220852394 |
19 | 0.0791344339288093 | 0.158268867857619 | 0.92086556607119 |
20 | 0.474068748850206 | 0.948137497700412 | 0.525931251149794 |
21 | 0.501625160834709 | 0.996749678330582 | 0.498374839165291 |
22 | 0.465255904870881 | 0.930511809741763 | 0.534744095129118 |
23 | 0.623307729763885 | 0.75338454047223 | 0.376692270236115 |
24 | 0.554366111171059 | 0.891267777657882 | 0.445633888828941 |
25 | 0.829523181081362 | 0.340953637837276 | 0.170476818918638 |
26 | 0.831048275700119 | 0.337903448599763 | 0.168951724299881 |
27 | 0.857294400532548 | 0.285411198934903 | 0.142705599467452 |
28 | 0.858055487003079 | 0.283889025993842 | 0.141944512996921 |
29 | 0.989635663017233 | 0.0207286739655339 | 0.0103643369827670 |
30 | 0.985067550868913 | 0.0298648982621734 | 0.0149324491310867 |
31 | 0.978291988309868 | 0.0434160233802636 | 0.0217080116901318 |
32 | 0.987599359107654 | 0.0248012817846919 | 0.0124006408923460 |
33 | 0.999170161456863 | 0.00165967708627323 | 0.000829838543136614 |
34 | 0.99915968903504 | 0.00168062192991838 | 0.000840310964959188 |
35 | 0.999356340051563 | 0.00128731989687487 | 0.000643659948437437 |
36 | 0.999914575366404 | 0.000170849267192114 | 8.5424633596057e-05 |
37 | 0.999978917258258 | 4.21654834849044e-05 | 2.10827417424522e-05 |
38 | 0.99998100399941 | 3.79920011788771e-05 | 1.89960005894385e-05 |
39 | 0.999970006576907 | 5.99868461857307e-05 | 2.99934230928654e-05 |
40 | 0.999974810587664 | 5.03788246719306e-05 | 2.51894123359653e-05 |
41 | 0.999971084217052 | 5.7831565895595e-05 | 2.89157829477975e-05 |
42 | 0.999961097704769 | 7.78045904626402e-05 | 3.89022952313201e-05 |
43 | 0.999929861361585 | 0.000140277276830627 | 7.01386384153137e-05 |
44 | 0.999867563808405 | 0.000264872383189474 | 0.000132436191594737 |
45 | 0.999900974106376 | 0.000198051787247439 | 9.90258936237196e-05 |
46 | 0.999867033512298 | 0.000265932975404520 | 0.000132966487702260 |
47 | 0.999819465799302 | 0.000361068401395099 | 0.000180534200697549 |
48 | 0.99975387513226 | 0.000492249735478747 | 0.000246124867739373 |
49 | 0.999729313342882 | 0.000541373314236087 | 0.000270686657118043 |
50 | 0.99980452421739 | 0.000390951565220374 | 0.000195475782610187 |
51 | 0.99989103942781 | 0.000217921144379736 | 0.000108960572189868 |
52 | 0.999759404602581 | 0.000481190794838064 | 0.000240595397419032 |
53 | 0.999759155328846 | 0.000481689342307971 | 0.000240844671153986 |
54 | 0.99977789857475 | 0.000444202850500662 | 0.000222101425250331 |
55 | 0.999967142942667 | 6.57141146665261e-05 | 3.28570573332630e-05 |
56 | 0.999974581614983 | 5.08367700340518e-05 | 2.54183850170259e-05 |
57 | 0.99998567100186 | 2.86579962803586e-05 | 1.43289981401793e-05 |
58 | 0.999980259988177 | 3.94800236459461e-05 | 1.97400118229730e-05 |
59 | 0.999986771799267 | 2.64564014664237e-05 | 1.32282007332119e-05 |
60 | 0.999981833654548 | 3.63326909036622e-05 | 1.81663454518311e-05 |
61 | 0.99993375783682 | 0.000132484326360960 | 6.62421631804801e-05 |
62 | 0.999758356298257 | 0.000483287403485524 | 0.000241643701742762 |
63 | 0.999725460663313 | 0.000549078673374527 | 0.000274539336687264 |
64 | 0.998921811527923 | 0.00215637694415455 | 0.00107818847207727 |
65 | 0.996485706823846 | 0.00702858635230735 | 0.00351429317615367 |
66 | 0.987323330971868 | 0.0253533380562643 | 0.0126766690281322 |
67 | 0.988847179201368 | 0.0223056415972632 | 0.0111528207986316 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 33 | 0.559322033898305 | NOK |
5% type I error level | 39 | 0.661016949152542 | NOK |
10% type I error level | 39 | 0.661016949152542 | NOK |