Multiple Linear Regression - Estimated Regression Equation |
Aantal_werknemers[t] = + 6.45466517236696 -0.00148584042151191Activa[t] + 0.0104249780876803Omzet[t] + 0.000673311632243301Marktwaarde[t] + 0.0445309265089534Winst[t] -0.0377493453559151Cashflow[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) | 6.45466517236696 | 3.443035 | 1.8747 | 0.064834 | 0.032417 |
Activa | -0.00148584042151191 | 0.000439 | -3.384 | 0.001152 | 0.000576 |
Omzet | 0.0104249780876803 | 0.000973 | 10.7147 | 0 | 0 |
Marktwaarde | 0.000673311632243301 | 0.001208 | 0.5575 | 0.578861 | 0.28943 |
Winst | 0.0445309265089534 | 0.027687 | 1.6084 | 0.112067 | 0.056034 |
Cashflow | -0.0377493453559151 | 0.017717 | -2.1307 | 0.036482 | 0.018241 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.939495070764463 |
R-squared | 0.882650987990724 |
Adjusted R-squared | 0.874613384428444 |
F-TEST (value) | 109.815193191792 |
F-TEST (DF numerator) | 5 |
F-TEST (DF denominator) | 73 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 22.8409201345601 |
Sum Squared Residuals | 38084.6571793147 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 18.2 | 16.4223165266676 | 1.77768347333239 |
2 | 143.8 | 71.7168503152216 | 72.0831496847784 |
3 | 23.4 | 27.4993201590538 | -4.09932015905381 |
4 | 1.1 | 4.67065506212421 | -3.57065506212421 |
5 | 49.5 | 52.1068141768362 | -2.60681417683619 |
6 | 4.8 | 22.8391647021591 | -18.0391647021591 |
7 | 20.8 | 21.3380264210753 | -0.538026421075281 |
8 | 19.4 | 13.950443561006 | 5.44955643899396 |
9 | 2.1 | 5.29751856732953 | -3.19751856732953 |
10 | 79.4 | 30.3100348490295 | 49.0899651509705 |
11 | 2.8 | 11.9371349192071 | -9.13713491920712 |
12 | 3.8 | 15.1348329802097 | -11.3348329802097 |
13 | 4.1 | 4.14093544551115 | -0.0409354455111481 |
14 | 13.2 | 17.7715668927657 | -4.57156689276567 |
15 | 2.8 | 9.97188780754144 | -7.17188780754144 |
16 | 48.5 | 103.960291756308 | -55.4602917563081 |
17 | 6.2 | 10.9168742557593 | -4.71687425575932 |
18 | 10.8 | 30.3773572960367 | -19.5773572960367 |
19 | 3.8 | 8.84170043259203 | -5.04170043259204 |
20 | 21.9 | 15.6986083021905 | 6.20139169780954 |
21 | 12.6 | 20.1420689411752 | -7.54206894117522 |
22 | 128 | 89.9557456862366 | 38.0442543137634 |
23 | 87.3 | 64.1659343534756 | 23.1340656465243 |
24 | 16 | 21.547679160879 | -5.54767916087896 |
25 | 0.7 | 8.74771594473479 | -8.04771594473479 |
26 | 22.5 | 18.3679330934317 | 4.1320669065683 |
27 | 15.4 | 16.8095653015247 | -1.4095653015247 |
28 | 3 | 4.15842273086476 | -1.15842273086477 |
29 | 2.1 | 5.54236111911203 | -3.44236111911203 |
30 | 4.1 | 3.94417388985063 | 0.155826110149371 |
31 | 6.4 | 14.5404536500256 | -8.14045365002563 |
32 | 26.6 | 27.743625656836 | -1.14362565683597 |
33 | 304 | 253.94760599292 | 50.0523940070797 |
34 | 18.6 | 28.487915940306 | -9.88791594030599 |
35 | 65 | 71.0246118671701 | -6.02461186717006 |
36 | 66.2 | 38.6355083127052 | 27.5644916872948 |
37 | 83 | 64.3226825145286 | 18.6773174854714 |
38 | 62 | 35.3537241492167 | 26.6462758507833 |
39 | 1.6 | 8.0769679277955 | -6.4769679277955 |
40 | 400.2 | 433.678734076102 | -33.4787340761024 |
41 | 23.3 | 21.1676193950827 | 2.13238060491728 |
42 | 4.6 | 16.878876641234 | -12.278876641234 |
43 | 164.6 | 173.485890373617 | -8.88589037361714 |
44 | 1.9 | 12.9242204980115 | -11.0242204980115 |
45 | 57.5 | 68.3968772993121 | -10.896877299312 |
46 | 2.4 | 4.65154518471247 | -2.25154518471247 |
47 | 77.3 | 52.9352448739693 | 24.3647551260307 |
48 | 15.8 | -8.97152683624272 | 24.7715268362427 |
49 | 0.6 | 4.39282959114051 | -3.79282959114051 |
50 | 3.5 | 9.47829520046423 | -5.97829520046423 |
51 | 9 | 1.78710539115831 | 7.21289460884169 |
52 | 62 | 40.9166259077317 | 21.0833740922683 |
53 | 7.4 | 2.59433969357193 | 4.80566030642807 |
54 | 15.6 | 0.0590843828373124 | 15.5409156171627 |
55 | 25.2 | 34.3055588822512 | -9.10555888225125 |
56 | 25.4 | 32.303254851619 | -6.90325485161902 |
57 | 3.5 | 20.4691501089661 | -16.9691501089661 |
58 | 27.3 | 113.869678436793 | -86.5696784367933 |
59 | 37.5 | 41.5145467063215 | -4.01454670632147 |
60 | 3.4 | 9.16241461920355 | -5.76241461920355 |
61 | 14.3 | 20.4453123896428 | -6.14531238964278 |
62 | 6.1 | 12.7466710420867 | -6.64667104208675 |
63 | 4.9 | 17.3859173959099 | -12.4859173959099 |
64 | 3.3 | 9.49669002762793 | -6.19669002762793 |
65 | 7 | 1.08310566883578 | 5.91689433116422 |
66 | 8.2 | 3.1140854092178 | 5.0859145907822 |
67 | 43.5 | 41.3164652020072 | 2.18353479799283 |
68 | 48.5 | 56.638805958222 | -8.13880595822201 |
69 | 5.4 | 12.4857982799179 | -7.08579827991789 |
70 | 49.5 | 49.7928311960457 | -0.29283119604573 |
71 | 29.1 | 31.8714850671075 | -2.77148506710752 |
72 | 2.6 | 27.7290987955109 | -25.1290987955109 |
73 | 0.8 | 4.35091040680033 | -3.55091040680033 |
74 | 184.8 | 137.819766326665 | 46.980233673335 |
75 | 2.3 | 29.2151685399705 | -26.9151685399705 |
76 | 8 | 28.3402999329623 | -20.3402999329623 |
77 | 10.3 | 16.9469002954369 | -6.64690029543692 |
78 | 50 | 29.8996188014077 | 20.1003811985923 |
79 | 118.1 | 63.1036733253538 | 54.9963266746462 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
9 | 0.0534622903374409 | 0.106924580674882 | 0.946537709662559 |
10 | 0.0222399831206958 | 0.0444799662413916 | 0.977760016879304 |
11 | 0.00644152708160479 | 0.0128830541632096 | 0.993558472918395 |
12 | 0.00198872616255685 | 0.0039774523251137 | 0.998011273837443 |
13 | 0.000501280802402102 | 0.0010025616048042 | 0.999498719197598 |
14 | 0.000840766275746463 | 0.00168153255149293 | 0.999159233724254 |
15 | 0.000237813278902555 | 0.00047562655780511 | 0.999762186721097 |
16 | 0.0426728168001001 | 0.0853456336002001 | 0.9573271831999 |
17 | 0.0252963918067485 | 0.0505927836134969 | 0.974703608193252 |
18 | 0.0434448633871575 | 0.086889726774315 | 0.956555136612843 |
19 | 0.028340126455151 | 0.0566802529103021 | 0.971659873544849 |
20 | 0.0260229631637569 | 0.0520459263275137 | 0.973977036836243 |
21 | 0.0156791767073264 | 0.0313583534146529 | 0.984320823292674 |
22 | 0.0232579252680332 | 0.0465158505360664 | 0.976742074731967 |
23 | 0.094930845386606 | 0.189861690773212 | 0.905069154613394 |
24 | 0.0668486593121885 | 0.133697318624377 | 0.933151340687812 |
25 | 0.0485656269471354 | 0.0971312538942707 | 0.951434373052865 |
26 | 0.0325427252259361 | 0.0650854504518723 | 0.967457274774064 |
27 | 0.0206330822940387 | 0.0412661645880773 | 0.979366917705961 |
28 | 0.0190063285746272 | 0.0380126571492545 | 0.980993671425373 |
29 | 0.0130012637982716 | 0.0260025275965432 | 0.986998736201728 |
30 | 0.011913477315542 | 0.0238269546310839 | 0.988086522684458 |
31 | 0.00766830105248702 | 0.015336602104974 | 0.992331698947513 |
32 | 0.00473513357601266 | 0.00947026715202532 | 0.995264866423987 |
33 | 0.0283651044057867 | 0.0567302088115734 | 0.971634895594213 |
34 | 0.0215012577084898 | 0.0430025154169796 | 0.97849874229151 |
35 | 0.0147414685867533 | 0.0294829371735066 | 0.985258531413247 |
36 | 0.0254504843009117 | 0.0509009686018235 | 0.974549515699088 |
37 | 0.021263735124064 | 0.0425274702481281 | 0.978736264875936 |
38 | 0.0679045227852702 | 0.13580904557054 | 0.93209547721473 |
39 | 0.0482335856641602 | 0.0964671713283205 | 0.95176641433584 |
40 | 0.742100656013311 | 0.515798687973378 | 0.257899343986689 |
41 | 0.705250562301559 | 0.589498875396883 | 0.294749437698441 |
42 | 0.657290359101644 | 0.685419281796711 | 0.342709640898356 |
43 | 0.845501631738085 | 0.30899673652383 | 0.154498368261915 |
44 | 0.821761220127903 | 0.356477559744195 | 0.178238779872097 |
45 | 0.906176664087328 | 0.187646671825343 | 0.0938233359126716 |
46 | 0.873546039061007 | 0.252907921877985 | 0.126453960938993 |
47 | 0.865231453975447 | 0.269537092049107 | 0.134768546024553 |
48 | 0.90452010270853 | 0.19095979458294 | 0.0954798972914698 |
49 | 0.934642239126858 | 0.130715521746284 | 0.065357760873142 |
50 | 0.911117967083734 | 0.177764065832532 | 0.0888820329162662 |
51 | 0.881505052834964 | 0.236989894330072 | 0.118494947165036 |
52 | 0.875404947329209 | 0.249190105341582 | 0.124595052670791 |
53 | 0.833423358930438 | 0.333153282139124 | 0.166576641069562 |
54 | 0.791647608398412 | 0.416704783203176 | 0.208352391601588 |
55 | 0.736478395563984 | 0.527043208872033 | 0.263521604436016 |
56 | 0.687439430471656 | 0.625121139056688 | 0.312560569528344 |
57 | 0.637934836154287 | 0.724130327691426 | 0.362065163845713 |
58 | 0.90900217080935 | 0.181995658381299 | 0.0909978291906496 |
59 | 0.872766087725615 | 0.25446782454877 | 0.127233912274385 |
60 | 0.819560167649439 | 0.360879664701122 | 0.180439832350561 |
61 | 0.751506848780431 | 0.496986302439137 | 0.248493151219569 |
62 | 0.673016738250244 | 0.653966523499512 | 0.326983261749756 |
63 | 0.629978209544159 | 0.740043580911681 | 0.370021790455841 |
64 | 0.539809235499306 | 0.920381529001388 | 0.460190764500694 |
65 | 0.445049257191965 | 0.890098514383929 | 0.554950742808035 |
66 | 0.3755796919185 | 0.751159383837001 | 0.6244203080815 |
67 | 0.270049662246574 | 0.540099324493148 | 0.729950337753426 |
68 | 0.208725881915667 | 0.417451763831334 | 0.791274118084333 |
69 | 0.127597733617624 | 0.255195467235247 | 0.872402266382376 |
70 | 0.0768315759792786 | 0.153663151958557 | 0.923168424020721 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 5 | 0.0806451612903226 | NOK |
5% type I error level | 17 | 0.274193548387097 | NOK |
10% type I error level | 27 | 0.435483870967742 | NOK |