Multiple Linear Regression - Estimated Regression Equation |
Aantal_Werknemers[t] = -2.12000159865992 -0.00152910182552142Activa[t] + 0.0100733378718534Omzet[t] + 0.000666066379215174Marktwaarde[t] + 0.0374019936078903Winst[t] -0.0315420048628704Cashflow[t] + 12.328801455594Dienst[t] + 14.2438423105841Product[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) | -2.12000159865992 | 5.112857 | -0.4146 | 0.679655 | 0.339827 |
Activa | -0.00152910182552142 | 0.000448 | -3.416 | 0.001055 | 0.000527 |
Omzet | 0.0100733378718534 | 0.000971 | 10.3725 | 0 | 0 |
Marktwaarde | 0.000666066379215174 | 0.0012 | 0.5551 | 0.580566 | 0.290283 |
Winst | 0.0374019936078903 | 0.027472 | 1.3614 | 0.177677 | 0.088838 |
Cashflow | -0.0315420048628704 | 0.017594 | -1.7927 | 0.077275 | 0.038637 |
Dienst | 12.328801455594 | 6.13975 | 2.008 | 0.048446 | 0.024223 |
Product | 14.2438423105841 | 7.568377 | 1.882 | 0.063932 | 0.031966 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.94363632152737 |
R-squared | 0.890449507305705 |
Adjusted R-squared | 0.879648754504859 |
F-TEST (value) | 82.4432818456839 |
F-TEST (DF numerator) | 7 |
F-TEST (DF denominator) | 71 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 22.3775893437347 |
Sum Squared Residuals | 35553.7118434149 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 18.2 | 8.20768542921332 | 9.99231457078668 |
2 | 143.8 | 61.807703802342 | 81.992296197658 |
3 | 23.4 | 18.7197586530227 | 4.68024134697729 |
4 | 1.1 | 8.19092162284392 | -7.09092162284392 |
5 | 49.5 | 55.1806766873105 | -5.68067668731051 |
6 | 4.8 | 28.065918171652 | -23.265918171652 |
7 | 20.8 | 26.6635590843253 | -5.86355908432534 |
8 | 19.4 | 5.5189440966883 | 13.8810559033117 |
9 | 2.1 | 8.84540561918255 | -6.74540561918255 |
10 | 79.4 | 38.1406168541843 | 41.2593831458157 |
11 | 2.8 | 15.5439428458293 | -12.7439428458293 |
12 | 3.8 | 6.2869932749472 | -2.4869932749472 |
13 | 4.1 | 7.51556353940158 | -3.41556353940158 |
14 | 13.2 | 23.3565373801188 | -10.1565373801188 |
15 | 2.8 | 1.38905370412212 | 1.41094629587788 |
16 | 48.5 | 101.225233615632 | -52.7252336156319 |
17 | 6.2 | 1.95929019821822 | 4.24070980178178 |
18 | 10.8 | 21.8609924715811 | -11.0609924715811 |
19 | 3.8 | 12.4996365026982 | -8.69963650269816 |
20 | 21.9 | 20.1998565763777 | 1.70014342362232 |
21 | 12.6 | 11.2053918783742 | 1.39460812162581 |
22 | 128 | 91.2063580512055 | 36.7936419487945 |
23 | 87.3 | 68.8355003402545 | 18.4644996597455 |
24 | 16 | 24.8796458216675 | -8.87964582166745 |
25 | 0.7 | 12.3722100128305 | -11.6722100128305 |
26 | 22.5 | 23.6471886348888 | -1.14718863488877 |
27 | 15.4 | 7.93758255171178 | 7.46241744828822 |
28 | 3 | 7.57590072471927 | -4.57590072471927 |
29 | 2.1 | 9.09649134900074 | -6.99649134900074 |
30 | 4.1 | 7.36278708553233 | -3.26278708553233 |
31 | 6.4 | 6.06408845790241 | 0.335911542097589 |
32 | 26.6 | 32.9506533307456 | -6.35065333074557 |
33 | 304 | 253.744172642929 | 50.2558273570707 |
34 | 18.6 | 31.5950881014359 | -12.9950881014359 |
35 | 65 | 72.8089263619535 | -7.80892636195345 |
36 | 66.2 | 44.5015851177596 | 21.6984148822404 |
37 | 83 | 68.8431685841837 | 14.1568314158163 |
38 | 62 | 38.5879595226888 | 23.4120404773112 |
39 | 1.6 | -0.528583304627026 | 2.12858330462703 |
40 | 400.2 | 433.336962116418 | -33.1369621164181 |
41 | 23.3 | 24.7811645783178 | -1.48116457831782 |
42 | 4.6 | 8.04143656592033 | -3.44143656592033 |
43 | 164.6 | 172.157076692305 | -7.55707669230454 |
44 | 1.9 | 4.09990202612825 | -2.19990202612825 |
45 | 57.5 | 73.1512354855731 | -15.6512354855731 |
46 | 2.4 | 8.14442061513064 | -5.74442061513064 |
47 | 77.3 | 55.3005777315167 | 21.9994222684833 |
48 | 15.8 | -7.71235979845015 | 23.5123597984502 |
49 | 0.6 | -3.6694251831854 | 4.2694251831854 |
50 | 3.5 | 0.816367007210633 | 2.68363299278937 |
51 | 9 | 4.58020270426516 | 4.41979729573484 |
52 | 62 | 46.1369516776323 | 15.8630483223677 |
53 | 7.4 | 5.71758604338395 | 1.68241395661606 |
54 | 15.6 | 2.2504139856385 | 13.3495860143615 |
55 | 25.2 | 39.3589809188284 | -14.1589809188284 |
56 | 25.4 | 35.966880340283 | -10.566880340283 |
57 | 3.5 | 11.4611289907925 | -7.96112899079255 |
58 | 27.3 | 105.264443253132 | -77.9644432531322 |
59 | 37.5 | 46.5373534400861 | -9.03735344008605 |
60 | 3.4 | 0.441650564781694 | 2.95834943521831 |
61 | 14.3 | 23.9425405911499 | -9.64254059114986 |
62 | 6.1 | 16.2651840872963 | -10.1651840872963 |
63 | 4.9 | 8.69099083469657 | -3.79099083469657 |
64 | 3.3 | 13.202701864527 | -9.90270186452704 |
65 | 7 | 4.11214406303496 | 2.88785593696504 |
66 | 8.2 | 6.15270703527172 | 2.04729296472828 |
67 | 43.5 | 44.1068501488631 | -0.606850148863126 |
68 | 48.5 | 58.9104595087513 | -10.4104595087513 |
69 | 5.4 | 18.0440326506326 | -12.6440326506326 |
70 | 49.5 | 53.3965673049476 | -3.89656730494763 |
71 | 29.1 | 35.753806155955 | -6.65380615595503 |
72 | 2.6 | 32.6245555851777 | -30.0245555851777 |
73 | 0.8 | 7.72691780640063 | -6.92691780640063 |
74 | 184.8 | 139.905077533847 | 44.8949224661535 |
75 | 2.3 | 19.9933635981138 | -17.6933635981138 |
76 | 8 | 18.8312411289131 | -10.8312411289131 |
77 | 10.3 | 20.5216945511726 | -10.2216945511726 |
78 | 50 | 32.8267676483913 | 17.1732323516087 |
79 | 118.1 | 65.1650427523023 | 52.9349572476977 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
11 | 0.0907166711172067 | 0.181433342234413 | 0.909283328882793 |
12 | 0.0327038514511933 | 0.0654077029023865 | 0.967296148548807 |
13 | 0.0101339860548259 | 0.0202679721096518 | 0.989866013945174 |
14 | 0.00842094604951569 | 0.0168418920990314 | 0.991579053950484 |
15 | 0.00269535007517302 | 0.00539070015034604 | 0.997304649924827 |
16 | 0.0738642716044126 | 0.147728543208825 | 0.926135728395587 |
17 | 0.0462457512441413 | 0.0924915024882826 | 0.953754248755859 |
18 | 0.0769657576509089 | 0.153931515301818 | 0.923034242349091 |
19 | 0.0670365278838074 | 0.134073055767615 | 0.932963472116193 |
20 | 0.0508038284364134 | 0.101607656872827 | 0.949196171563587 |
21 | 0.0308619685238117 | 0.0617239370476233 | 0.969138031476188 |
22 | 0.0301077542657039 | 0.0602155085314077 | 0.969892245734296 |
23 | 0.0677514898500458 | 0.135502979700092 | 0.932248510149954 |
24 | 0.0563820922003754 | 0.112764184400751 | 0.943617907799625 |
25 | 0.0506961794954139 | 0.101392358990828 | 0.949303820504586 |
26 | 0.0459258719887789 | 0.0918517439775577 | 0.954074128011221 |
27 | 0.0303912653507066 | 0.0607825307014133 | 0.969608734649293 |
28 | 0.0248600260140894 | 0.0497200520281788 | 0.975139973985911 |
29 | 0.0158901160785286 | 0.0317802321570572 | 0.984109883921471 |
30 | 0.0130138156487984 | 0.0260276312975968 | 0.986986184351202 |
31 | 0.00845789172401377 | 0.0169157834480275 | 0.991542108275986 |
32 | 0.00739279068520487 | 0.0147855813704097 | 0.992607209314795 |
33 | 0.0522838009993904 | 0.104567601998781 | 0.94771619900061 |
34 | 0.0485306399055244 | 0.0970612798110488 | 0.951469360094476 |
35 | 0.0366010472672255 | 0.073202094534451 | 0.963398952732775 |
36 | 0.0542283862605165 | 0.108456772521033 | 0.945771613739483 |
37 | 0.0444422179616773 | 0.0888844359233546 | 0.955557782038323 |
38 | 0.0956104753403302 | 0.19122095068066 | 0.90438952465967 |
39 | 0.0706827719004732 | 0.141365543800946 | 0.929317228099527 |
40 | 0.938712647329696 | 0.122574705340608 | 0.061287352670304 |
41 | 0.919962172209103 | 0.160075655581794 | 0.0800378277908969 |
42 | 0.896488015519915 | 0.207023968960171 | 0.103511984480085 |
43 | 0.968225551641334 | 0.0635488967173313 | 0.0317744483586657 |
44 | 0.953894343645622 | 0.092211312708756 | 0.046105656354378 |
45 | 0.975204913079175 | 0.0495901738416492 | 0.0247950869208246 |
46 | 0.962438438017091 | 0.0751231239658189 | 0.0375615619829095 |
47 | 0.954796885942797 | 0.0904062281144054 | 0.0452031140572027 |
48 | 0.966916254427755 | 0.0661674911444893 | 0.0330837455722447 |
49 | 0.990383995497027 | 0.0192320090059466 | 0.00961600450297328 |
50 | 0.990798412548299 | 0.0184031749034015 | 0.00920158745170075 |
51 | 0.984784878439507 | 0.0304302431209862 | 0.0152151215604931 |
52 | 0.978952110842034 | 0.0420957783159318 | 0.0210478891579659 |
53 | 0.967398202090268 | 0.0652035958194636 | 0.0326017979097318 |
54 | 0.951869046222589 | 0.0962619075548216 | 0.0481309537774108 |
55 | 0.936500123837389 | 0.126999752325222 | 0.0634998761626108 |
56 | 0.907264290955018 | 0.185471418089964 | 0.0927357090449822 |
57 | 0.873671908624983 | 0.252656182750034 | 0.126328091375017 |
58 | 0.978694523435266 | 0.0426109531294681 | 0.0213054765647341 |
59 | 0.975785584121415 | 0.0484288317571709 | 0.0242144158785854 |
60 | 0.969920913828538 | 0.0601581723429235 | 0.0300790861714618 |
61 | 0.9593101113934 | 0.0813797772132005 | 0.0406898886066003 |
62 | 0.93880787497631 | 0.122384250047381 | 0.0611921250236903 |
63 | 0.906424103228182 | 0.187151793543635 | 0.0935758967718175 |
64 | 0.867650888037357 | 0.264698223925286 | 0.132349111962643 |
65 | 0.784922897675524 | 0.430154204648951 | 0.215077102324475 |
66 | 0.667470034799359 | 0.665059930401282 | 0.332529965200641 |
67 | 0.529411049942416 | 0.941177900115169 | 0.470588950057584 |
68 | 0.680139695546539 | 0.639720608906922 | 0.319860304453461 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 1 | 0.0172413793103448 | NOK |
5% type I error level | 15 | 0.258620689655172 | NOK |
10% type I error level | 33 | 0.568965517241379 | NOK |