Multiple Linear Regression - Estimated Regression Equation |
Totaal[t] = -0.0792831553802387 + 1.00001186862561TerugbetalingAanDeAandeelhouders[t] + 1.00000207516186AanzuiveringVanVerliezen[t] + 1.00002220665309Andere[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.0792831553802387 | 0.0637 | -1.2446 | 0.215891 | 0.107945 |
TerugbetalingAanDeAandeelhouders | 1.00001186862561 | 1.2e-05 | 82770.9872 | 0 | 0 |
AanzuiveringVanVerliezen | 1.00000207516186 | 1.3e-05 | 76762.1282 | 0 | 0 |
Andere | 1.00002220665309 | 1.6e-05 | 63418.1467 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.999999997622779 |
R-squared | 0.999999995245557 |
Adjusted R-squared | 0.999999995117059 |
F-TEST (value) | 7782194854.13493 |
F-TEST (DF numerator) | 3 |
F-TEST (DF denominator) | 111 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 0.587322171522531 |
Sum Squared Residuals | 38.2891539809755 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 239 | 239.923716581914 | -0.923716581913556 |
2 | 503 | 502.929333860276 | 0.0706661397240333 |
3 | 598 | 598.927988361886 | -0.927988361885916 |
4 | 2999 | 2999.95608988262 | -0.956089882615069 |
5 | 1673 | 1671.94336881702 | 1.05663118298118 |
6 | 14333 | 14332.9882987492 | 0.0117012508261434 |
7 | 4438 | 4438.97465207387 | -0.974652073871865 |
8 | 157 | 155.922306122316 | 1.07769387768379 |
9 | 3126 | 3125.96018453954 | 0.0398154604632863 |
10 | 2379 | 2378.95545180447 | 0.0445481955344446 |
11 | 469 | 468.92625336586 | 0.0737466341401371 |
12 | 10171 | 10171.1004874628 | -0.10048746282824 |
13 | 2698 | 2697.95224229276 | 0.0477577072398341 |
14 | 2381 | 2380.95362599367 | 0.0463740063287732 |
15 | 3136 | 3135.97980942391 | 0.0201905760879576 |
16 | 830 | 829.930368684584 | 0.0696313154160013 |
17 | 681 | 679.928065032756 | 1.07193496724406 |
18 | 1730 | 1729.94012458139 | 0.0598754186104111 |
19 | 3780 | 3779.99188149755 | 0.00811850244873569 |
20 | 1196 | 1195.9378940433 | 0.0621059566961445 |
21 | 4870 | 4869.00865750981 | 0.991342490187754 |
22 | 3144 | 3144.96201130514 | -0.962011305137979 |
23 | 1908 | 1907.94443681862 | 0.055563181375132 |
24 | 5807 | 5807.03028904994 | -0.0302890499377829 |
25 | 324 | 323.924246183026 | 0.075753816973689 |
26 | 337 | 336.924716580134 | 0.0752834198664939 |
27 | 1125 | 1123.94229445287 | 1.05770554713015 |
28 | 2121 | 2120.94868370599 | 0.0513162940061355 |
29 | 7910 | 7908.94563292282 | 1.05436707717704 |
30 | 3551 | 3550.97251223529 | 0.0274877647076379 |
31 | 1842 | 1842.95219043605 | -0.952190436054532 |
32 | 175 | 174.922562631601 | 0.0774373683986935 |
33 | 2846 | 2845.96290090199 | 0.0370990980114815 |
34 | 5934 | 5934.04979020212 | -0.0497902021195158 |
35 | 2214 | 2212.95562698652 | 1.04437301347664 |
36 | 11672 | 11672.1520466695 | -0.152046669512949 |
37 | 1012 | 1010.94000762792 | 1.05999237208237 |
38 | 222 | 221.922889234505 | 0.0771107654951736 |
39 | 1494 | 1493.9383425637 | 0.0616574362964857 |
40 | 1022 | 1020.93241960868 | 1.06758039132386 |
41 | 881 | 880.933125383334 | 0.0668746166659636 |
42 | 11267 | 11267.0630748139 | -0.0630748138563077 |
43 | 1248 | 1247.93177541757 | 0.0682245824336706 |
44 | 924 | 923.92709417555 | 0.0729058244502465 |
45 | 8451 | 8450.05603093978 | 0.94396906022512 |
46 | 2274 | 2273.94730952041 | 0.0526904795866182 |
47 | 1504 | 1503.95051042815 | 0.0494895718535559 |
48 | 8090 | 8090.01965438086 | -0.0196543808630612 |
49 | 2221 | 2220.94801892041 | 0.0519810795935415 |
50 | 305 | 304.925860277417 | 0.0741397225832393 |
51 | 971 | 970.931513400588 | 0.0684865994119374 |
52 | 850 | 849.935316385682 | 0.0646836143176983 |
53 | 1986 | 1985.94704773937 | 0.0529522606299156 |
54 | 3128 | 3127.9522768079 | 0.0477231920956839 |
55 | 3571 | 3570.97205032968 | 0.0279496703211496 |
56 | 2842 | 2842.95366452112 | -0.953664521120296 |
57 | 1352 | 1352.93668323747 | -0.93668323746644 |
58 | 5806 | 5805.98575130563 | 0.014248694374591 |
59 | 4049 | 4047.98382586431 | 1.01617413568523 |
60 | 19550 | 19550.2280563649 | -0.228056364897931 |
61 | 58941 | 58941.0002572619 | -0.000257261883502888 |
62 | 1621 | 1620.93892272406 | 0.0610772759355816 |
63 | 1067 | 1067.93964055205 | -0.939640552048952 |
64 | 393 | 392.927890649711 | 0.0721093502891081 |
65 | 7059 | 7059.00546926474 | -0.00546926473522774 |
66 | 7278 | 7277.96045824891 | 0.0395417510862333 |
67 | 1433 | 1433.94322003429 | -0.943220034285947 |
68 | 2410 | 2409.94990788358 | 0.0500921164231945 |
69 | 902 | 901.932842000218 | 0.0671579997822477 |
70 | 3679 | 3678.96501269984 | 0.0349873001621951 |
71 | 607 | 607.931694930549 | -0.931694930549446 |
72 | 4527 | 4526.99960518995 | 0.000394810052891814 |
73 | 2352 | 2351.95559642387 | 0.0444035761262821 |
74 | 524 | 523.924381034263 | 0.0756189657368493 |
75 | 5784 | 5784.99034157375 | -0.990341573749278 |
76 | 11475 | 11474.9630783644 | 0.0369216355703308 |
77 | 2940 | 2939.95332598049 | 0.0466740195138716 |
78 | 36980 | 36980.0185964615 | -0.0185964615188058 |
79 | 1576 | 1576.94895013286 | -0.948950132859335 |
80 | 607 | 605.930101991376 | 1.0698980086243 |
81 | 1190 | 1190.93674001918 | -0.93674001917527 |
82 | 1731 | 1731.94716609272 | -0.947166092724231 |
83 | 617 | 616.927017549964 | 0.0729824500362657 |
84 | 6107 | 6106.00086890994 | 0.999131090054694 |
85 | 3524 | 3523.96804663901 | 0.0319533609931426 |
86 | 1432 | 1431.95049815972 | 0.0495018402817715 |
87 | 1150 | 1149.9367610059 | 0.0632389941019911 |
88 | 879 | 878.932497701346 | 0.0675022986540449 |
89 | 7430 | 7430.94016201094 | -0.940162010937796 |
90 | 3404 | 3402.98491610564 | 1.01508389436303 |
91 | 4945 | 4945.02157660902 | -0.0215766090189246 |
92 | 602 | 601.928112627448 | 0.0718873725517812 |
93 | 3590 | 3589.96978667745 | 0.0302133225492684 |
94 | 5262 | 5261.99122947153 | 0.00877052847304662 |
95 | 3349 | 3349.96661322432 | -0.966613224322041 |
96 | 44336 | 44335.4718327071 | 0.52816729287391 |
97 | 947 | 945.937482488476 | 1.06251751152359 |
98 | 1311 | 1311.94477768777 | -0.94477768777337 |
99 | 1006 | 1005.93031445387 | 0.0696855461268437 |
100 | 6224 | 6223.99678050065 | 0.0032194993464831 |
101 | 6890 | 6889.94776537666 | 0.0522346233359336 |
102 | 3014 | 3014.968281928 | -0.968281928003072 |
103 | 3288 | 3286.97363696607 | 1.02636303392594 |
104 | 1787 | 1786.93304239599 | 0.0669576040100311 |
105 | 12518 | 12518.1428563706 | -0.142856370583427 |
106 | 5500 | 5499.98220381805 | 0.0177961819495401 |
107 | 27519 | 27519.2464231692 | -0.246423169200306 |
108 | 14607 | 14608.148298855 | -1.14829885498203 |
109 | 815 | 814.93162764102 | 0.0683723589798796 |
110 | 851 | 851.933310083651 | -0.933310083651394 |
111 | 1152 | 1151.93483898968 | 0.0651610103231723 |
112 | 3179 | 3177.97970722883 | 1.02029277116699 |
113 | 25090 | 25090.0086216435 | -0.00862164348807401 |
114 | 3373 | 3372.96543316654 | 0.0345668334633046 |
115 | 10931 | 10931.058437311 | -0.0584373109777049 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
7 | 0.537488786796147 | 0.925022426407706 | 0.462511213203853 |
8 | 0.974850351885828 | 0.0502992962283446 | 0.0251496481141723 |
9 | 0.950707234443723 | 0.0985855311125537 | 0.0492927655562768 |
10 | 0.96213420051167 | 0.0757315989766598 | 0.0378657994883299 |
11 | 0.934914644754806 | 0.130170710490389 | 0.0650853552451945 |
12 | 0.925084491541684 | 0.149831016916633 | 0.0749155084583164 |
13 | 0.896072339301151 | 0.207855321397698 | 0.103927660698849 |
14 | 0.85497924879233 | 0.29004150241534 | 0.14502075120767 |
15 | 0.797788926854424 | 0.404422146291151 | 0.202211073145576 |
16 | 0.731398158701693 | 0.537203682596614 | 0.268601841298307 |
17 | 0.811248097614085 | 0.37750380477183 | 0.188751902385915 |
18 | 0.751661899071769 | 0.496676201856462 | 0.248338100928231 |
19 | 0.688866325090086 | 0.622267349819829 | 0.311133674909914 |
20 | 0.617767291364845 | 0.76446541727031 | 0.382232708635155 |
21 | 0.738108558092678 | 0.523782883814644 | 0.261891441907322 |
22 | 0.756100656699136 | 0.487798686601729 | 0.243899343300864 |
23 | 0.701227087238507 | 0.597545825522987 | 0.298772912761493 |
24 | 0.650628814873747 | 0.698742370252505 | 0.349371185126253 |
25 | 0.586945460169217 | 0.826109079661566 | 0.413054539830783 |
26 | 0.52075620596351 | 0.958487588072981 | 0.47924379403649 |
27 | 0.597027112078898 | 0.805945775842205 | 0.402972887921102 |
28 | 0.534156335618659 | 0.931687328762682 | 0.465843664381341 |
29 | 0.567096590511392 | 0.865806818977217 | 0.432903409488608 |
30 | 0.507215516763848 | 0.985568966472304 | 0.492784483236152 |
31 | 0.644583626783479 | 0.710832746433041 | 0.35541637321652 |
32 | 0.589473314833937 | 0.821053370332125 | 0.410526685166063 |
33 | 0.533491262444363 | 0.933017475111273 | 0.466508737555637 |
34 | 0.482671720620021 | 0.965343441240042 | 0.517328279379979 |
35 | 0.599107071094089 | 0.801785857811822 | 0.400892928905911 |
36 | 0.540512961331082 | 0.918974077337835 | 0.459487038668918 |
37 | 0.618845157017165 | 0.762309685965669 | 0.381154842982835 |
38 | 0.570147678103774 | 0.859704643792452 | 0.429852321896226 |
39 | 0.512438437901464 | 0.975123124197072 | 0.487561562098536 |
40 | 0.62583204100591 | 0.748335917988181 | 0.37416795899409 |
41 | 0.573770296111688 | 0.852459407776625 | 0.426229703888313 |
42 | 0.653638398182139 | 0.692723203635722 | 0.346361601817861 |
43 | 0.603261793617057 | 0.793476412765885 | 0.396738206382943 |
44 | 0.551049885866953 | 0.897900228266094 | 0.448950114133047 |
45 | 0.684643481475866 | 0.630713037048268 | 0.315356518524134 |
46 | 0.634223389487384 | 0.731553221025232 | 0.365776610512616 |
47 | 0.583281795138341 | 0.833436409723317 | 0.416718204861659 |
48 | 0.532720801488711 | 0.934558397022577 | 0.467279198511289 |
49 | 0.478376656394867 | 0.956753312789733 | 0.521623343605133 |
50 | 0.426230120924084 | 0.852460241848168 | 0.573769879075916 |
51 | 0.375246953116494 | 0.750493906232988 | 0.624753046883506 |
52 | 0.326511460404038 | 0.653022920808077 | 0.673488539595962 |
53 | 0.279896139504312 | 0.559792279008625 | 0.720103860495688 |
54 | 0.237200474279229 | 0.474400948558458 | 0.762799525720771 |
55 | 0.197516178900696 | 0.395032357801391 | 0.802483821099304 |
56 | 0.261582765319732 | 0.523165530639464 | 0.738417234680268 |
57 | 0.338031089721147 | 0.676062179442295 | 0.661968910278853 |
58 | 0.290731544028135 | 0.581463088056271 | 0.709268455971865 |
59 | 0.39704057618222 | 0.794081152364439 | 0.60295942381778 |
60 | 0.34782613281751 | 0.69565226563502 | 0.65217386718249 |
61 | 0.300174868004606 | 0.600349736009211 | 0.699825131995394 |
62 | 0.255685728624003 | 0.511371457248007 | 0.744314271375997 |
63 | 0.32980642248174 | 0.659612844963481 | 0.67019357751826 |
64 | 0.283351796427558 | 0.566703592855117 | 0.716648203572442 |
65 | 0.240423536705475 | 0.48084707341095 | 0.759576463294525 |
66 | 0.201699026503645 | 0.40339805300729 | 0.798300973496355 |
67 | 0.26374480438489 | 0.52748960876978 | 0.73625519561511 |
68 | 0.221215909891415 | 0.44243181978283 | 0.778784090108585 |
69 | 0.183194681328755 | 0.36638936265751 | 0.816805318671245 |
70 | 0.149127160654843 | 0.298254321309685 | 0.850872839345157 |
71 | 0.197443754224907 | 0.394887508449814 | 0.802556245775093 |
72 | 0.161049928335541 | 0.322099856671082 | 0.838950071664459 |
73 | 0.129336719468754 | 0.258673438937508 | 0.870663280531246 |
74 | 0.102480748579682 | 0.204961497159365 | 0.897519251420318 |
75 | 0.140524649978688 | 0.281049299957376 | 0.859475350021312 |
76 | 0.113811274025841 | 0.227622548051681 | 0.886188725974159 |
77 | 0.0887625095592963 | 0.177525019118593 | 0.911237490440704 |
78 | 0.0731233101490437 | 0.146246620298087 | 0.926876689850956 |
79 | 0.106855500387465 | 0.21371100077493 | 0.893144499612535 |
80 | 0.174620331301158 | 0.349240662602316 | 0.825379668698842 |
81 | 0.231193265336258 | 0.462386530672516 | 0.768806734663742 |
82 | 0.305029797552332 | 0.610059595104664 | 0.694970202447668 |
83 | 0.253531706177741 | 0.507063412355481 | 0.746468293822259 |
84 | 0.354297970244955 | 0.708595940489909 | 0.645702029755045 |
85 | 0.297607021711079 | 0.595214043422158 | 0.702392978288921 |
86 | 0.245434926174827 | 0.490869852349653 | 0.754565073825173 |
87 | 0.198163038961942 | 0.396326077923884 | 0.801836961038058 |
88 | 0.156520586281267 | 0.313041172562534 | 0.843479413718733 |
89 | 0.206790401083251 | 0.413580802166502 | 0.793209598916749 |
90 | 0.319789108287108 | 0.639578216574217 | 0.680210891712892 |
91 | 0.26520519404839 | 0.530410388096779 | 0.73479480595161 |
92 | 0.21216083608165 | 0.4243216721633 | 0.78783916391835 |
93 | 0.165119117517344 | 0.330238235034688 | 0.834880882482656 |
94 | 0.12455882860946 | 0.249117657218919 | 0.87544117139054 |
95 | 0.177736429027209 | 0.355472858054419 | 0.822263570972791 |
96 | 0.196012971576649 | 0.392025943153297 | 0.803987028423351 |
97 | 0.31141245494571 | 0.62282490989142 | 0.68858754505429 |
98 | 0.413653845251805 | 0.82730769050361 | 0.586346154748195 |
99 | 0.332506824330206 | 0.665013648660413 | 0.667493175669794 |
100 | 0.256630608720849 | 0.513261217441699 | 0.743369391279151 |
101 | 0.189228776025487 | 0.378457552050973 | 0.810771223974513 |
102 | 0.295621993552109 | 0.591243987104218 | 0.704378006447891 |
103 | 0.454766210113938 | 0.909532420227877 | 0.545233789886062 |
104 | 0.348502203661034 | 0.697004407322068 | 0.651497796338966 |
105 | 0.315609081734105 | 0.63121816346821 | 0.684390918265895 |
106 | 0.213909259551685 | 0.427818519103371 | 0.786090740448315 |
107 | 0.130630094516489 | 0.261260189032978 | 0.869369905483511 |
108 | 0.470546822706652 | 0.941093645413303 | 0.529453177293348 |
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 | 3 | 0.0294117647058824 | OK |