Multiple Linear Regression - Estimated Regression Equation |
Apple[t] = -148.389379308089 -18.2064906878529Omzetgroei[t] -7.06273178125017e-07Volume[t] + 6.83287017871577Microsoft[t] + 0.0189694137186282NASDAQ[t] + 82.274316728171Inflatie[t] -0.611219563554505Cons_vertrouwen[t] + 1.65811032276012t + 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) | -148.389379308089 | 17.626702 | -8.4184 | 0 | 0 |
Omzetgroei | -18.2064906878529 | 11.098972 | -1.6404 | 0.10381 | 0.051905 |
Volume | -7.06273178125017e-07 | 0 | -2.7448 | 0.007083 | 0.003542 |
Microsoft | 6.83287017871577 | 1.127517 | 6.0601 | 0 | 0 |
NASDAQ | 0.0189694137186282 | 0.014423 | 1.3152 | 0.191204 | 0.095602 |
Inflatie | 82.274316728171 | 218.096923 | 0.3772 | 0.706731 | 0.353365 |
Cons_vertrouwen | -0.611219563554505 | 0.17777 | -3.4383 | 0.00083 | 0.000415 |
t | 1.65811032276012 | 0.175297 | 9.4589 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.953327788951627 |
R-squared | 0.908833873187398 |
Adjusted R-squared | 0.902979167795763 |
F-TEST (value) | 155.231358777832 |
F-TEST (DF numerator) | 7 |
F-TEST (DF denominator) | 109 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 23.6651650789451 |
Sum Squared Residuals | 61044.364165296 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 10.81 | -7.2562971997284 | 18.0662971997284 |
2 | 9.12 | -11.8938172664148 | 21.0138172664148 |
3 | 11.03 | -35.9471560679179 | 46.9771560679179 |
4 | 12.74 | 8.00592163519917 | 4.73407836480084 |
5 | 9.98 | 15.6435116393184 | -5.66351163931839 |
6 | 11.62 | 25.9664908898376 | -14.3464908898376 |
7 | 9.4 | 7.30583886604385 | 2.09416113395615 |
8 | 9.27 | -14.0289816713551 | 23.2989816713551 |
9 | 7.76 | -27.9641625344846 | 35.7241625344845 |
10 | 8.78 | -6.28813727547426 | 15.0681372754743 |
11 | 10.65 | 18.348086752952 | -7.69808675295201 |
12 | 10.95 | 20.5019083917910 | -9.55190839179096 |
13 | 12.36 | 13.7159467430930 | -1.35594674309297 |
14 | 10.85 | -1.66783320853259 | 12.5178332085326 |
15 | 11.84 | 2.39855802678800 | 9.441441973212 |
16 | 12.14 | -18.9773771404354 | 31.1173771404354 |
17 | 11.65 | -23.4477382787103 | 35.0977382787103 |
18 | 8.86 | -15.9944636090714 | 24.8544636090714 |
19 | 7.63 | -28.338082547479 | 35.968082547479 |
20 | 7.38 | -18.3397337339018 | 25.7197337339018 |
21 | 7.25 | -34.6075664130423 | 41.8575664130423 |
22 | 8.03 | 3.76377701645387 | 4.26622298354613 |
23 | 7.75 | 18.3074055892636 | -10.5574055892636 |
24 | 7.16 | 3.84585997289419 | 3.31414002710581 |
25 | 7.18 | -5.50795310910591 | 12.6879531091059 |
26 | 7.51 | 7.55899679398065 | -0.0489967939806476 |
27 | 7.07 | 14.7729373320438 | -7.70293733204384 |
28 | 7.11 | 7.11171336524197 | -0.00171336524196974 |
29 | 8.98 | 0.727710762624927 | 8.25228923737507 |
30 | 9.53 | 14.5055971361330 | -4.97559713613304 |
31 | 10.54 | 25.7610561328307 | -15.2210561328307 |
32 | 11.31 | 27.4719510025171 | -16.1619510025171 |
33 | 10.36 | 37.4505056793357 | -27.0905056793357 |
34 | 11.44 | 26.1257305101076 | -14.6857305101076 |
35 | 10.45 | 20.3567994669585 | -9.90679946695853 |
36 | 10.69 | 32.8196379052649 | -22.1296379052649 |
37 | 11.28 | 31.8784521117184 | -20.5984521117184 |
38 | 11.96 | 34.33606389021 | -22.37606389021 |
39 | 13.52 | 20.5235594591248 | -7.00355945912476 |
40 | 12.89 | 26.8274749188411 | -13.9374749188411 |
41 | 14.03 | 35.2727695470326 | -21.2427695470326 |
42 | 16.27 | 41.7302900552444 | -25.4602900552444 |
43 | 16.17 | 35.10920895656 | -18.93920895656 |
44 | 17.25 | 36.0721675869396 | -18.8221675869396 |
45 | 19.38 | 41.7793624298572 | -22.3993624298572 |
46 | 26.2 | 32.2492387747191 | -6.04923877471912 |
47 | 33.53 | 45.3859719600091 | -11.8559719600091 |
48 | 32.2 | 45.1794136375662 | -12.9794136375662 |
49 | 38.45 | 25.0629517745891 | 13.3870482254109 |
50 | 44.86 | 25.7593296484485 | 19.1006703515515 |
51 | 41.67 | 33.0273529483209 | 8.6426470516791 |
52 | 36.06 | 36.4939573251818 | -0.433957325181776 |
53 | 39.76 | 48.6278629707337 | -8.86786297073368 |
54 | 36.81 | 44.4741283007009 | -7.66412830070093 |
55 | 42.65 | 58.8100399117758 | -16.1600399117758 |
56 | 46.89 | 73.2396907361254 | -26.3496907361254 |
57 | 53.61 | 71.7884825284871 | -18.1784825284871 |
58 | 57.59 | 64.2220932111743 | -6.63209321117433 |
59 | 67.82 | 78.7661913964846 | -10.9461913964846 |
60 | 71.89 | 67.3788372262097 | 4.51116277379035 |
61 | 75.51 | 75.2996189284124 | 0.210381071587581 |
62 | 68.49 | 73.388425385918 | -4.89842538591804 |
63 | 62.72 | 75.4018417627668 | -12.6818417627668 |
64 | 70.39 | 56.8285475247992 | 13.5614524752008 |
65 | 59.77 | 58.8596137559758 | 0.910386244024243 |
66 | 57.27 | 61.9524316798376 | -4.68243167983761 |
67 | 67.96 | 62.8315910583938 | 5.12840894160618 |
68 | 67.85 | 83.9814792821416 | -16.1314792821416 |
69 | 76.98 | 89.8955146736437 | -12.9155146736437 |
70 | 81.08 | 109.265356797849 | -28.1853567978494 |
71 | 91.66 | 116.701207254884 | -25.0412072548836 |
72 | 84.84 | 113.857358290331 | -29.0173582903314 |
73 | 85.73 | 109.96614092045 | -24.2361409204501 |
74 | 84.61 | 109.945971681826 | -25.3359716818258 |
75 | 92.91 | 112.423071766595 | -19.5130717665951 |
76 | 99.8 | 130.308730431090 | -30.5087304310903 |
77 | 121.19 | 133.981578404424 | -12.7915784044243 |
78 | 122.04 | 121.849847856193 | 0.190152143807104 |
79 | 131.76 | 111.721525241619 | 20.0384747583807 |
80 | 138.48 | 120.123245557877 | 18.3567544421227 |
81 | 153.47 | 131.945434721764 | 21.5245652782355 |
82 | 189.95 | 187.238258055067 | 2.71174194493265 |
83 | 182.22 | 164.040710945616 | 18.1792890543843 |
84 | 198.08 | 186.919658987854 | 11.1603410121462 |
85 | 135.36 | 143.895211762662 | -8.53521176266158 |
86 | 125.02 | 127.024258859856 | -2.00425885985605 |
87 | 143.5 | 145.916186263863 | -2.41618626386301 |
88 | 173.95 | 158.356273936138 | 15.5937260638620 |
89 | 188.75 | 169.170903623261 | 19.579096376739 |
90 | 167.44 | 164.906415959316 | 2.53358404068357 |
91 | 158.95 | 149.027997297698 | 9.9220027023024 |
92 | 169.53 | 164.99220641348 | 4.53779358651992 |
93 | 113.66 | 140.975753105341 | -27.3157531053406 |
94 | 107.59 | 114.694156140423 | -7.10415614042256 |
95 | 92.67 | 109.629811992367 | -16.9598119923670 |
96 | 85.35 | 117.941860679225 | -32.5918606792251 |
97 | 90.13 | 123.718469444614 | -33.5884694446144 |
98 | 89.31 | 109.429071953966 | -20.1190719539662 |
99 | 105.12 | 128.092141566345 | -22.9721415663454 |
100 | 125.83 | 137.798060082972 | -11.9680600829715 |
101 | 135.81 | 138.888140749212 | -3.07814074921232 |
102 | 142.43 | 161.471995142760 | -19.0419951427598 |
103 | 163.39 | 170.969958455698 | -7.57995845569844 |
104 | 168.21 | 180.631328480647 | -12.4213284806473 |
105 | 185.35 | 189.909342094546 | -4.55934209454583 |
106 | 188.5 | 199.505779171235 | -11.0057791712348 |
107 | 199.91 | 220.124438930834 | -20.2144389308344 |
108 | 210.73 | 227.941368013672 | -17.2113680136724 |
109 | 192.06 | 198.723587232262 | -6.66358723226227 |
110 | 204.62 | 218.857212908644 | -14.2372129086436 |
111 | 235 | 225.424100221957 | 9.57589977804272 |
112 | 261.09 | 229.312975872687 | 31.7770241273128 |
113 | 256.88 | 184.458348804666 | 72.4216511953337 |
114 | 251.53 | 172.698121670036 | 78.8318783299642 |
115 | 257.25 | 197.816228826709 | 59.4337711732909 |
116 | 243.1 | 188.297365141005 | 54.802634858995 |
117 | 283.75 | 200.922235375498 | 82.8277646245024 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
11 | 0.00027663772149865 | 0.0005532754429973 | 0.999723362278501 |
12 | 1.32118051307657e-05 | 2.64236102615314e-05 | 0.99998678819487 |
13 | 6.18289109599182e-07 | 1.23657821919836e-06 | 0.99999938171089 |
14 | 2.52697611101983e-08 | 5.05395222203965e-08 | 0.999999974730239 |
15 | 2.6251729500623e-09 | 5.2503459001246e-09 | 0.999999997374827 |
16 | 3.52460288704445e-10 | 7.0492057740889e-10 | 0.99999999964754 |
17 | 1.90491888485379e-11 | 3.80983776970757e-11 | 0.99999999998095 |
18 | 1.64813992186741e-11 | 3.29627984373482e-11 | 0.999999999983519 |
19 | 1.57505323327943e-12 | 3.15010646655887e-12 | 0.999999999998425 |
20 | 1.13852461647358e-13 | 2.27704923294715e-13 | 0.999999999999886 |
21 | 1.22924062596919e-14 | 2.45848125193839e-14 | 0.999999999999988 |
22 | 1.62993357055266e-15 | 3.25986714110532e-15 | 0.999999999999998 |
23 | 9.85205552349457e-17 | 1.97041110469891e-16 | 1 |
24 | 8.05964884453106e-18 | 1.61192976890621e-17 | 1 |
25 | 1.19283679518757e-18 | 2.38567359037513e-18 | 1 |
26 | 3.06554929894649e-19 | 6.13109859789298e-19 | 1 |
27 | 3.65319242510013e-20 | 7.30638485020025e-20 | 1 |
28 | 7.62891516151893e-21 | 1.52578303230379e-20 | 1 |
29 | 1.98339526256837e-21 | 3.96679052513675e-21 | 1 |
30 | 5.45257125979081e-22 | 1.09051425195816e-21 | 1 |
31 | 9.9354383843536e-23 | 1.98708767687072e-22 | 1 |
32 | 1.8116375054732e-23 | 3.6232750109464e-23 | 1 |
33 | 2.36978147368195e-24 | 4.73956294736389e-24 | 1 |
34 | 1.95322666949368e-25 | 3.90645333898737e-25 | 1 |
35 | 2.72452494956219e-26 | 5.44904989912438e-26 | 1 |
36 | 2.5519700159105e-27 | 5.103940031821e-27 | 1 |
37 | 1.87001595046553e-28 | 3.74003190093107e-28 | 1 |
38 | 1.26037464609738e-29 | 2.52074929219477e-29 | 1 |
39 | 7.98055063650383e-30 | 1.59611012730077e-29 | 1 |
40 | 3.58711932288147e-30 | 7.17423864576294e-30 | 1 |
41 | 5.95626010672955e-30 | 1.19125202134591e-29 | 1 |
42 | 9.45641009499621e-30 | 1.89128201899924e-29 | 1 |
43 | 4.52361170611115e-30 | 9.0472234122223e-30 | 1 |
44 | 2.12069982473014e-29 | 4.24139964946027e-29 | 1 |
45 | 1.00046488107864e-27 | 2.00092976215728e-27 | 1 |
46 | 1.68171575568682e-26 | 3.36343151137364e-26 | 1 |
47 | 3.26126345211134e-24 | 6.52252690422269e-24 | 1 |
48 | 5.59635689932798e-24 | 1.11927137986560e-23 | 1 |
49 | 1.42366175256992e-24 | 2.84732350513985e-24 | 1 |
50 | 9.20740537612325e-22 | 1.84148107522465e-21 | 1 |
51 | 1.66390484630100e-18 | 3.32780969260199e-18 | 1 |
52 | 7.71090430554323e-19 | 1.54218086110865e-18 | 1 |
53 | 8.6140817871572e-18 | 1.72281635743144e-17 | 1 |
54 | 1.13945183337122e-17 | 2.27890366674244e-17 | 1 |
55 | 1.58869958305464e-15 | 3.17739916610927e-15 | 0.999999999999998 |
56 | 8.12692986791242e-14 | 1.62538597358248e-13 | 0.999999999999919 |
57 | 1.09244669772710e-11 | 2.18489339545421e-11 | 0.999999999989076 |
58 | 1.75361428704093e-10 | 3.50722857408187e-10 | 0.999999999824639 |
59 | 6.80901079946795e-08 | 1.36180215989359e-07 | 0.999999931909892 |
60 | 8.14828592415321e-06 | 1.62965718483064e-05 | 0.999991851714076 |
61 | 4.95780565604758e-05 | 9.91561131209516e-05 | 0.99995042194344 |
62 | 8.15463841357651e-05 | 0.000163092768271530 | 0.999918453615864 |
63 | 5.13341323143491e-05 | 0.000102668264628698 | 0.999948665867686 |
64 | 5.16580006943076e-05 | 0.000103316001388615 | 0.999948341999306 |
65 | 3.92578576286452e-05 | 7.85157152572905e-05 | 0.999960742142371 |
66 | 2.67171750013394e-05 | 5.34343500026788e-05 | 0.999973282824999 |
67 | 0.000133574397831228 | 0.000267148795662457 | 0.999866425602169 |
68 | 0.000259886032146490 | 0.000519772064292979 | 0.999740113967854 |
69 | 0.000588593631742843 | 0.00117718726348569 | 0.999411406368257 |
70 | 0.000702568829928257 | 0.00140513765985651 | 0.999297431170072 |
71 | 0.00109786777604697 | 0.00219573555209394 | 0.998902132223953 |
72 | 0.000772207890773729 | 0.00154441578154746 | 0.999227792109226 |
73 | 0.000870301131224264 | 0.00174060226244853 | 0.999129698868776 |
74 | 0.000548902296640392 | 0.00109780459328078 | 0.99945109770336 |
75 | 0.000492466571749727 | 0.000984933143499454 | 0.99950753342825 |
76 | 0.000592931765124056 | 0.00118586353024811 | 0.999407068234876 |
77 | 0.00215017485955435 | 0.00430034971910870 | 0.997849825140446 |
78 | 0.00666031708653625 | 0.0133206341730725 | 0.993339682913464 |
79 | 0.0187664262382314 | 0.0375328524764629 | 0.981233573761769 |
80 | 0.06786316392925 | 0.1357263278585 | 0.93213683607075 |
81 | 0.369416524229525 | 0.73883304845905 | 0.630583475770475 |
82 | 0.592064347175581 | 0.815871305648838 | 0.407935652824419 |
83 | 0.669134932680959 | 0.661730134638083 | 0.330865067319041 |
84 | 0.973241352869706 | 0.053517294260587 | 0.0267586471302935 |
85 | 0.969529782712865 | 0.060940434574269 | 0.0304702172871345 |
86 | 0.966125100562392 | 0.0677497988752169 | 0.0338748994376084 |
87 | 0.959062738516028 | 0.081874522967945 | 0.0409372614839725 |
88 | 0.967913954566471 | 0.064172090867057 | 0.0320860454335285 |
89 | 0.972522940552005 | 0.0549541188959902 | 0.0274770594479951 |
90 | 0.986905380380195 | 0.0261892392396093 | 0.0130946196198046 |
91 | 0.982182236930125 | 0.0356355261397508 | 0.0178177630698754 |
92 | 0.997710690231105 | 0.00457861953778968 | 0.00228930976889484 |
93 | 0.996545440135187 | 0.00690911972962614 | 0.00345455986481307 |
94 | 0.995731214324004 | 0.0085375713519926 | 0.0042687856759963 |
95 | 0.994266267702411 | 0.0114674645951772 | 0.00573373229758859 |
96 | 0.991721645529233 | 0.0165567089415344 | 0.00827835447076718 |
97 | 0.984440351583452 | 0.0311192968330954 | 0.0155596484165477 |
98 | 0.973677681059197 | 0.0526446378816068 | 0.0263223189408034 |
99 | 0.96386822456361 | 0.0722635508727803 | 0.0361317754363901 |
100 | 0.958327434381191 | 0.0833451312376172 | 0.0416725656188086 |
101 | 0.934119733111594 | 0.131760533776811 | 0.0658802668884056 |
102 | 0.884963201976872 | 0.230073596046256 | 0.115036798023128 |
103 | 0.824710689210806 | 0.350578621578387 | 0.175289310789194 |
104 | 0.72926892631173 | 0.541462147376541 | 0.270731073688271 |
105 | 0.87212375223441 | 0.255752495531181 | 0.127876247765591 |
106 | 0.971231455859264 | 0.0575370882814713 | 0.0287685441407356 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 70 | 0.729166666666667 | NOK |
5% type I error level | 77 | 0.802083333333333 | NOK |
10% type I error level | 87 | 0.90625 | NOK |