Multiple Linear Regression - Estimated Regression Equation |
O-Totaal[t] = + 0.137220054817536 + 0.999903412773738`O-InbrengInContanten`[t] + 1.0000549069098`O-InbrengInNatura`[t] + 0.999875971355442`O-TeStortenBedrag`[t] -0.0106768387025519`KH-Totaal`[t] + 0.0106713694464462`KH-InbrengInContanten`[t] + 0.0106901657398105`KH-InbrengInNatura`[t] + 0.0105392359156959`KH-TeStortenBedrag`[t] + 0.0106840760155234`KH-ConversieVanEigenMiddelen`[t] + 0.0106505363785584`KH-Schuldconversie`[t] + 0.0106983051187204`KH-Uitgiftepremies`[t] + 0.0924724690751978`KV-Totaal`[t] -0.0924805201942237`KV-TerugbetalingAanDeAandeelhouders`[t] -0.0924749298987029`KV-AanzuiveringVanVerliezen`[t] -0.092505989284591`KV-Andere`[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) | 0.137220054817536 | 0.106013 | 1.2944 | 0.199456 | 0.099728 |
`O-InbrengInContanten` | 0.999903412773738 | 0.000293 | 3415.4135 | 0 | 0 |
`O-InbrengInNatura` | 1.0000549069098 | 9.6e-05 | 10386.3869 | 0 | 0 |
`O-TeStortenBedrag` | 0.999875971355442 | 0.00045 | 2222.8143 | 0 | 0 |
`KH-Totaal` | -0.0106768387025519 | 0.091457 | -0.1167 | 0.907373 | 0.453686 |
`KH-InbrengInContanten` | 0.0106713694464462 | 0.091454 | 0.1167 | 0.907417 | 0.453709 |
`KH-InbrengInNatura` | 0.0106901657398105 | 0.091455 | 0.1169 | 0.907256 | 0.453628 |
`KH-TeStortenBedrag` | 0.0105392359156959 | 0.09146 | 0.1152 | 0.908564 | 0.454282 |
`KH-ConversieVanEigenMiddelen` | 0.0106840760155234 | 0.091463 | 0.1168 | 0.907316 | 0.453658 |
`KH-Schuldconversie` | 0.0106505363785584 | 0.091457 | 0.1165 | 0.9076 | 0.4538 |
`KH-Uitgiftepremies` | 0.0106983051187204 | 0.091465 | 0.117 | 0.907195 | 0.453598 |
`KV-Totaal` | 0.0924724690751978 | 0.12329 | 0.75 | 0.455544 | 0.227772 |
`KV-TerugbetalingAanDeAandeelhouders` | -0.0924805201942237 | 0.12329 | -0.7501 | 0.455506 | 0.227753 |
`KV-AanzuiveringVanVerliezen` | -0.0924749298987029 | 0.123291 | -0.7501 | 0.455537 | 0.227769 |
`KV-Andere` | -0.092505989284591 | 0.123292 | -0.7503 | 0.45539 | 0.227695 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.999999925855166 |
R-squared | 0.999999851710337 |
Adjusted R-squared | 0.99999982439382 |
F-TEST (value) | 36607882.9336255 |
F-TEST (DF numerator) | 14 |
F-TEST (DF denominator) | 76 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 0.639164625128585 |
Sum Squared Residuals | 31.0483877691981 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 175 | 175.173238280556 | -0.173238280556442 |
2 | 357 | 356.105590675747 | 0.894409324253349 |
3 | 107 | 107.201126237743 | -0.201126237742722 |
4 | 310 | 311.132524255604 | -1.13252425560452 |
5 | 116 | 115.184428215477 | 0.815571784522731 |
6 | 376 | 374.892985928976 | 1.10701407102364 |
7 | 230 | 230.01549340805 | -0.0154934080501939 |
8 | 54 | 54.1271632048273 | -0.127163204827325 |
9 | 194 | 194.098846382175 | -0.0988463821751275 |
10 | 171 | 171.967612394438 | -0.967612394438396 |
11 | 311 | 311.194074264306 | -0.194074264305549 |
12 | 290 | 288.8912566333 | 1.10874336670041 |
13 | 4435 | 4434.82094185196 | 0.179058148043768 |
14 | 440 | 440.129884678232 | -0.129884678232336 |
15 | 1430 | 1430.04843816666 | -0.0484381666585048 |
16 | 820 | 820.222723799499 | -0.222723799499125 |
17 | 223 | 223.105353250618 | -0.105353250618012 |
18 | 426 | 425.993825376968 | 0.00617462303210115 |
19 | 1693 | 1693.19990322661 | -0.199903226607016 |
20 | 2068 | 2067.2252825707 | 0.774717429299946 |
21 | 832 | 831.098046564636 | 0.901953435364089 |
22 | 416 | 415.093111256356 | 0.906888743644411 |
23 | 372 | 372.088652670991 | -0.0886526709910966 |
24 | 5266 | 5266.25563284847 | -0.255632848467777 |
25 | 633 | 633.0384520226 | -0.0384520225995733 |
26 | 191 | 190.213412009145 | 0.786587990854672 |
27 | 337 | 336.135076582614 | 0.864923417386264 |
28 | 280 | 280.088524254792 | -0.0885242547915626 |
29 | 619 | 619.093378687552 | -0.0933786875518276 |
30 | 2423 | 2423.01120196234 | -0.0112019623428069 |
31 | 538 | 537.572784828606 | 0.427215171394412 |
32 | 294 | 292.998925297194 | 1.00107470280623 |
33 | 430 | 430.04182030469 | -0.0418203046904574 |
34 | 737 | 738.077121982734 | -1.07712198273434 |
35 | 541 | 541.207170205654 | -0.207170205654353 |
36 | 1214 | 1213.36331186006 | 0.636688139942926 |
37 | 929 | 928.92733285353 | 0.0726671464696878 |
38 | 1288 | 1288.14666516286 | -0.146665162862255 |
39 | 321 | 321.034744662243 | -0.0347446622434284 |
40 | 1912 | 1911.20318716893 | 0.796812831065523 |
41 | 146 | 146.060377007996 | -0.0603770079964529 |
42 | 357 | 357.089561782149 | -0.0895617821488086 |
43 | 473 | 473.090023439329 | -0.0900234393294607 |
44 | 153 | 152.890384766838 | 0.109615233162023 |
45 | 681 | 681.919606800379 | -0.919606800378562 |
46 | 337 | 337.043422546885 | -0.0434225468847625 |
47 | 433 | 433.08671313589 | -0.0867131358901815 |
48 | 751 | 751.891647453485 | -0.891647453484593 |
49 | 655 | 656.12984077612 | -1.1298407761197 |
50 | 233 | 232.139349430012 | 0.860650569988191 |
51 | 118 | 118.017362544454 | -0.0173625444538151 |
52 | 146 | 146.126287120003 | -0.126287120002863 |
53 | 365 | 366.106714730826 | -1.1067147308262 |
54 | 653 | 652.948258792589 | 0.051741207410638 |
55 | 434 | 432.895420602617 | 1.10457939738253 |
56 | 231 | 230.196806357077 | 0.80319364292274 |
57 | 123 | 123.031113784844 | -0.0311137848437668 |
58 | 259 | 258.979547644241 | 0.0204523557592323 |
59 | 98 | 97.0826204040143 | 0.917379595985669 |
60 | 2107 | 2106.96909519703 | 0.0309048029716968 |
61 | 715 | 714.10079161023 | 0.899208389770099 |
62 | 136 | 136.077067714654 | -0.0770677146536877 |
63 | 180 | 181.144940504846 | -1.14494050484568 |
64 | 172 | 173.101318964143 | -1.10131896414256 |
65 | 170 | 169.945843637258 | 0.0541563627415037 |
66 | 380 | 381.10465231655 | -1.1046523165495 |
67 | 813 | 812.940416798579 | 0.0595832014213218 |
68 | 708 | 708.266376814102 | -0.266376814101867 |
69 | 193 | 194.173048315387 | -1.17304831538661 |
70 | 248 | 248.076517862253 | -0.0765178622532203 |
71 | 725 | 725.052564048561 | -0.0525640485613419 |
72 | 13007 | 13007.1804343528 | -0.180434352750649 |
73 | 976 | 975.25300428511 | 0.746995714889879 |
74 | 185 | 184.947823984838 | 0.05217601516232 |
75 | 234 | 235.110456926475 | -1.11045692647529 |
76 | 185 | 185.108835051751 | -0.108835051750847 |
77 | 217 | 217.140452124728 | -0.140452124727829 |
78 | 802 | 802.086749869207 | -0.0867498692068789 |
79 | 705 | 704.549440309491 | 0.450559690509203 |
80 | 304 | 303.07141641837 | 0.928583581630279 |
81 | 395 | 395.882366528268 | -0.882366528268366 |
82 | 439 | 439.091837752413 | -0.0918377524130363 |
83 | 321 | 320.930995623414 | 0.0690043765861102 |
84 | 1015 | 1015.06028291222 | -0.0602829122183546 |
85 | 340 | 340.141137112941 | -0.141137112941032 |
86 | 372 | 371.991006140058 | 0.00899385994243839 |
87 | 1772 | 1771.94792296652 | 0.0520770334777027 |
88 | 163 | 163.166158604895 | -0.166158604895101 |
89 | 197 | 197.100397306381 | -0.100397306380828 |
90 | 610 | 610.100694550959 | -0.100694550958798 |
91 | 313 | 313.041648287432 | -0.0416482874323504 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
18 | 0.101058819519683 | 0.202117639039365 | 0.898941180480317 |
19 | 0.473287742740922 | 0.946575485481843 | 0.526712257259078 |
20 | 0.611641043365529 | 0.776717913268942 | 0.388358956634471 |
21 | 0.510230777626858 | 0.979538444746284 | 0.489769222373142 |
22 | 0.573197094591824 | 0.853605810816351 | 0.426802905408176 |
23 | 0.591134273851882 | 0.817731452296237 | 0.408865726148118 |
24 | 0.488506328286223 | 0.977012656572446 | 0.511493671713777 |
25 | 0.457372223409411 | 0.914744446818821 | 0.542627776590589 |
26 | 0.726833468517842 | 0.546333062964315 | 0.273166531482158 |
27 | 0.723602779596566 | 0.552794440806868 | 0.276397220403434 |
28 | 0.645508992625521 | 0.708982014748958 | 0.354491007374479 |
29 | 0.564620591040572 | 0.870758817918857 | 0.435379408959428 |
30 | 0.643162474990941 | 0.713675050018117 | 0.356837525009059 |
31 | 0.666772664201833 | 0.666454671596335 | 0.333227335798167 |
32 | 0.717066905363824 | 0.565866189272353 | 0.282933094636176 |
33 | 0.652716911248942 | 0.694566177502115 | 0.347283088751058 |
34 | 0.766596739074018 | 0.466806521851965 | 0.233403260925982 |
35 | 0.707011042871229 | 0.585977914257541 | 0.292988957128771 |
36 | 0.661063896770156 | 0.677872206459688 | 0.338936103229844 |
37 | 0.634775920912605 | 0.73044815817479 | 0.365224079087395 |
38 | 0.565873181322365 | 0.86825363735527 | 0.434126818677635 |
39 | 0.493569261021701 | 0.987138522043402 | 0.506430738978299 |
40 | 0.549621706048446 | 0.900756587903107 | 0.450378293951554 |
41 | 0.478206258195537 | 0.956412516391075 | 0.521793741804462 |
42 | 0.456776087544834 | 0.913552175089668 | 0.543223912455166 |
43 | 0.399444863157169 | 0.798889726314337 | 0.600555136842831 |
44 | 0.346813838803147 | 0.693627677606294 | 0.653186161196853 |
45 | 0.405086260934496 | 0.810172521868992 | 0.594913739065504 |
46 | 0.339361611972988 | 0.678723223945977 | 0.660638388027012 |
47 | 0.279361077135161 | 0.558722154270322 | 0.720638922864839 |
48 | 0.33774132987138 | 0.675482659742759 | 0.66225867012862 |
49 | 0.448698214280531 | 0.897396428561061 | 0.55130178571947 |
50 | 0.514678104437901 | 0.970643791124199 | 0.485321895562099 |
51 | 0.441282474016176 | 0.882564948032352 | 0.558717525983824 |
52 | 0.388172011202292 | 0.776344022404583 | 0.611827988797708 |
53 | 0.475841681046874 | 0.951683362093747 | 0.524158318953126 |
54 | 0.42132213118678 | 0.842644262373561 | 0.578677868813219 |
55 | 0.498481728586929 | 0.996963457173858 | 0.501518271413071 |
56 | 0.618758792945719 | 0.762482414108562 | 0.381241207054281 |
57 | 0.556673310742634 | 0.886653378514732 | 0.443326689257366 |
58 | 0.476989675148792 | 0.953979350297584 | 0.523010324851208 |
59 | 0.592966900933798 | 0.814066198132403 | 0.407033099066202 |
60 | 0.543019897959713 | 0.913960204080574 | 0.456980102040287 |
61 | 0.766639264762578 | 0.466721470474844 | 0.233360735237422 |
62 | 0.787870257093144 | 0.424259485813712 | 0.212129742906856 |
63 | 0.894101542244364 | 0.211796915511273 | 0.105898457755636 |
64 | 0.900258628203802 | 0.199482743592397 | 0.0997413717961984 |
65 | 0.873961157599372 | 0.252077684801255 | 0.126038842400628 |
66 | 0.834098505447062 | 0.331802989105875 | 0.165901494552938 |
67 | 0.815291196605328 | 0.369417606789344 | 0.184708803394672 |
68 | 0.733431570344759 | 0.533136859310482 | 0.266568429655241 |
69 | 0.736116518896938 | 0.527766962206125 | 0.263883481103062 |
70 | 0.622127573783823 | 0.755744852432354 | 0.377872426216177 |
71 | 0.496131599733921 | 0.992263199467841 | 0.503868400266079 |
72 | 0.561049649902757 | 0.877900700194485 | 0.438950350097243 |
73 | 0.409064141074102 | 0.818128282148204 | 0.590935858925898 |
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 |