Multiple Linear Regression - Estimated Regression Equation |
Apple[t] = -89.980306402187 + 25.9301820373230Omzetgroei[t] + 4.83923660683462e-07Volume[t] + 6.43325933193157Microsoft[t] + 0.0903195954538196NASDAQ[t] -939.517745569973Inflatie[t] -1.93823831639427Cons_vertrouwen[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) | -89.980306402187 | 22.176341 | -4.0575 | 9.3e-05 | 4.7e-05 |
Omzetgroei | 25.9301820373230 | 13.52697 | 1.9169 | 0.057842 | 0.028921 |
Volume | 4.83923660683462e-07 | 0 | 1.6051 | 0.111338 | 0.055669 |
Microsoft | 6.43325933193157 | 1.513454 | 4.2507 | 4.5e-05 | 2.2e-05 |
NASDAQ | 0.0903195954538196 | 0.016513 | 5.4696 | 0 | 0 |
Inflatie | -939.517745569973 | 254.495487 | -3.6917 | 0.000348 | 0.000174 |
Cons_vertrouwen | -1.93823831639427 | 0.146652 | -13.2166 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.913237166920447 |
R-squared | 0.834002123044885 |
Adjusted R-squared | 0.824947693392788 |
F-TEST (value) | 92.1098462399247 |
F-TEST (DF numerator) | 6 |
F-TEST (DF denominator) | 110 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 31.7878356811424 |
Sum Squared Residuals | 111151.314702044 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 10.81 | 63.4800143839999 | -52.6700143839999 |
2 | 9.12 | 11.5056540130825 | -2.38565401308251 |
3 | 11.03 | -34.9476577878405 | 45.9776577878405 |
4 | 12.74 | 36.9901937522827 | -24.2501937522827 |
5 | 9.98 | 21.0411918380408 | -11.0611918380408 |
6 | 11.62 | 33.9491153925062 | -22.3291153925062 |
7 | 9.4 | 14.1112482751670 | -4.71124827516697 |
8 | 9.27 | -28.2995850131832 | 37.5695850131832 |
9 | 7.76 | -34.7279742316239 | 42.4879742316239 |
10 | 8.78 | 42.4502712921912 | -33.6702712921912 |
11 | 10.65 | 81.5249933036784 | -70.8749933036784 |
12 | 10.95 | 72.4640212605682 | -61.5140212605682 |
13 | 12.36 | 57.0954918872676 | -44.7354918872676 |
14 | 10.85 | 30.5488501055335 | -19.6988501055335 |
15 | 11.84 | 9.43515940050313 | 2.40484059949687 |
16 | 12.14 | -24.1658445587469 | 36.3058445587469 |
17 | 11.65 | -33.6395213283955 | 45.2895213283955 |
18 | 8.86 | -26.0737706230650 | 34.9337706230650 |
19 | 7.63 | -42.4335069508654 | 50.0635069508654 |
20 | 7.38 | -40.8102432520915 | 48.1902432520915 |
21 | 7.25 | -62.6197529125356 | 69.8697529125356 |
22 | 8.03 | 1.52067878542202 | 6.50932121457798 |
23 | 7.75 | 12.7687055953805 | -5.01870559538055 |
24 | 7.16 | -9.24364539203323 | 16.4036453920332 |
25 | 7.18 | -20.6959034411282 | 27.8759034411282 |
26 | 7.51 | 3.29020725818312 | 4.21979274181688 |
27 | 7.07 | 12.0783801337905 | -5.00838013379052 |
28 | 7.11 | 5.44180135523165 | 1.66819864476835 |
29 | 8.98 | 11.2748084026594 | -2.29480840265938 |
30 | 9.53 | 14.7683661434446 | -5.23836614344458 |
31 | 10.54 | 43.3313394064382 | -32.7913394064382 |
32 | 11.31 | 40.5690983092261 | -29.2590983092261 |
33 | 10.36 | 53.552593126796 | -43.1925931267960 |
34 | 11.44 | 57.7479522065992 | -46.3079522065992 |
35 | 10.45 | 38.7731323125545 | -28.3231323125545 |
36 | 10.69 | 51.6322218871421 | -40.9422218871421 |
37 | 11.28 | 50.0132250120639 | -38.7332250120639 |
38 | 11.96 | 56.3373762179714 | -44.3773762179714 |
39 | 13.52 | 48.4795103016563 | -34.9595103016563 |
40 | 12.89 | 33.0876916181363 | -20.1976916181363 |
41 | 14.03 | 29.2587301418428 | -15.2287301418428 |
42 | 16.27 | 28.3678374591684 | -12.0978374591684 |
43 | 16.17 | 13.3334038344770 | 2.83659616552303 |
44 | 17.25 | 18.3298860569358 | -1.07988605693579 |
45 | 19.38 | 30.4221067355482 | -11.0421067355482 |
46 | 26.2 | 57.2402589849444 | -31.0402589849445 |
47 | 33.53 | 76.9824084082835 | -43.4524084082835 |
48 | 32.2 | 63.9848012919705 | -31.7848012919705 |
49 | 38.45 | 59.1329257978746 | -20.6829257978746 |
50 | 44.86 | 49.5359912730844 | -4.6759912730844 |
51 | 41.67 | 32.3290280448934 | 9.34097195510664 |
52 | 36.06 | 44.9666776093238 | -8.90667760932376 |
53 | 39.76 | 51.7828038305373 | -12.0228038305373 |
54 | 36.81 | 40.0092481477978 | -3.19924814779780 |
55 | 42.65 | 50.3321754750179 | -7.6821754750179 |
56 | 46.89 | 48.2428363319817 | -1.35283633198169 |
57 | 53.61 | 66.8130248777108 | -13.2030248777108 |
58 | 57.59 | 79.0867975329776 | -21.4967975329776 |
59 | 67.82 | 79.7618761867403 | -11.9418761867403 |
60 | 71.89 | 57.6877138209828 | 14.2022861790172 |
61 | 75.51 | 67.9357474027165 | 7.5742525972835 |
62 | 68.49 | 68.8500772439185 | -0.360077243918477 |
63 | 62.72 | 68.8917828512036 | -6.17178285120359 |
64 | 70.39 | 41.3731175935756 | 29.0168824064244 |
65 | 59.77 | 18.3678205543539 | 41.4021794456461 |
66 | 57.27 | 19.6705149587124 | 37.5994850412876 |
67 | 67.96 | 19.0828420205863 | 48.8771579794137 |
68 | 67.85 | 51.9877827691538 | 15.8622172308462 |
69 | 76.98 | 75.7904920449815 | 1.18950795501853 |
70 | 81.08 | 96.332104612129 | -15.2521046121290 |
71 | 91.66 | 100.464309674999 | -8.80430967499931 |
72 | 84.84 | 90.958360075194 | -6.11836007519391 |
73 | 85.73 | 113.248966120043 | -27.5189661200432 |
74 | 84.61 | 77.4266745110507 | 7.18332548894929 |
75 | 92.91 | 78.2123077920361 | 14.6976922079639 |
76 | 99.8 | 106.377959999548 | -6.57795999954766 |
77 | 121.19 | 115.739578875215 | 5.45042112478457 |
78 | 122.04 | 119.926218242445 | 2.11378175755469 |
79 | 131.76 | 105.72062990219 | 26.0393700978100 |
80 | 138.48 | 122.901524790815 | 15.5784752091854 |
81 | 153.47 | 141.870469722208 | 11.5995302777921 |
82 | 189.95 | 202.450532300888 | -12.5005323008877 |
83 | 182.22 | 177.416135447814 | 4.80386455218603 |
84 | 198.08 | 178.307007702892 | 19.7729922971080 |
85 | 135.36 | 155.673040274325 | -20.3130402743249 |
86 | 125.02 | 130.099143705891 | -5.07914370589138 |
87 | 143.5 | 156.717388194759 | -13.2173881947587 |
88 | 173.95 | 171.403114883223 | 2.5468851167771 |
89 | 188.75 | 185.380640171393 | 3.36935982860714 |
90 | 167.44 | 165.759679996508 | 1.68032000349191 |
91 | 158.95 | 158.874560434792 | 0.0754395652082245 |
92 | 169.53 | 157.445049762352 | 12.084950237648 |
93 | 113.66 | 137.184993901735 | -23.5249939017346 |
94 | 107.59 | 128.423202074343 | -20.8332020743434 |
95 | 92.67 | 101.475730679276 | -8.80573067927566 |
96 | 85.35 | 116.479146965348 | -31.1291469653484 |
97 | 90.13 | 160.438728724576 | -70.3087287245764 |
98 | 89.31 | 100.118072676435 | -10.8080726764352 |
99 | 105.12 | 129.532018657467 | -24.4120186574666 |
100 | 125.83 | 136.166858248656 | -10.3368582486562 |
101 | 135.81 | 122.443849359452 | 13.366150640548 |
102 | 142.43 | 159.677592460384 | -17.2475924603841 |
103 | 163.39 | 173.790429882175 | -10.4004298821750 |
104 | 168.21 | 162.925145935586 | 5.28485406441425 |
105 | 185.35 | 181.890527342872 | 3.45947265712797 |
106 | 188.5 | 195.029606453597 | -6.52960645359696 |
107 | 199.91 | 189.67290082876 | 10.2370991712401 |
108 | 210.73 | 195.149117213710 | 15.5808827862898 |
109 | 192.06 | 174.90356687833 | 17.1564331216701 |
110 | 204.62 | 206.550677419071 | -1.93067741907121 |
111 | 235 | 211.059324459506 | 23.9406755404943 |
112 | 261.09 | 219.332758434926 | 41.7572415650737 |
113 | 256.88 | 169.694647538562 | 87.185352461438 |
114 | 251.53 | 161.306541557169 | 90.2234584428309 |
115 | 257.25 | 197.870733823665 | 59.3792661763347 |
116 | 243.1 | 162.262863568598 | 80.8371364314019 |
117 | 283.75 | 203.208970955787 | 80.5410290442125 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
10 | 7.05349581737511e-05 | 0.000141069916347502 | 0.999929465041826 |
11 | 6.63995828475425e-06 | 1.32799165695085e-05 | 0.999993360041715 |
12 | 2.76088454987290e-07 | 5.52176909974579e-07 | 0.999999723911545 |
13 | 1.14486101669958e-08 | 2.28972203339916e-08 | 0.99999998855139 |
14 | 4.1332024266942e-10 | 8.2664048533884e-10 | 0.99999999958668 |
15 | 1.67260927222011e-11 | 3.34521854444023e-11 | 0.999999999983274 |
16 | 1.79886977839267e-12 | 3.59773955678535e-12 | 0.999999999998201 |
17 | 6.65433771979008e-14 | 1.33086754395802e-13 | 0.999999999999933 |
18 | 4.50794069982022e-14 | 9.01588139964043e-14 | 0.999999999999955 |
19 | 3.99647490794641e-15 | 7.99294981589282e-15 | 0.999999999999996 |
20 | 2.36928540484906e-16 | 4.73857080969813e-16 | 1 |
21 | 2.20091861630273e-17 | 4.40183723260546e-17 | 1 |
22 | 1.34868451530872e-18 | 2.69736903061743e-18 | 1 |
23 | 5.74435555674214e-20 | 1.14887111134843e-19 | 1 |
24 | 3.10886208461634e-21 | 6.21772416923269e-21 | 1 |
25 | 2.95582226390478e-22 | 5.91164452780957e-22 | 1 |
26 | 4.59614843187513e-23 | 9.19229686375025e-23 | 1 |
27 | 2.85599311165207e-24 | 5.71198622330414e-24 | 1 |
28 | 2.53858941345152e-25 | 5.07717882690303e-25 | 1 |
29 | 1.57739409768045e-26 | 3.1547881953609e-26 | 1 |
30 | 1.10673737853708e-27 | 2.21347475707415e-27 | 1 |
31 | 8.22608419017279e-29 | 1.64521683803456e-28 | 1 |
32 | 7.3511586312905e-30 | 1.4702317262581e-29 | 1 |
33 | 3.56766113091449e-31 | 7.13532226182898e-31 | 1 |
34 | 2.94491678632257e-32 | 5.88983357264515e-32 | 1 |
35 | 1.77175867662495e-33 | 3.5435173532499e-33 | 1 |
36 | 1.18515599584402e-34 | 2.37031199168804e-34 | 1 |
37 | 7.218533736053e-36 | 1.4437067472106e-35 | 1 |
38 | 7.00264021917976e-37 | 1.40052804383595e-36 | 1 |
39 | 7.00060265889873e-37 | 1.40012053177975e-36 | 1 |
40 | 2.84106504476170e-37 | 5.68213008952339e-37 | 1 |
41 | 5.74872660567821e-37 | 1.14974532113564e-36 | 1 |
42 | 1.65168076224995e-36 | 3.30336152449991e-36 | 1 |
43 | 3.74809572961926e-37 | 7.49619145923852e-37 | 1 |
44 | 4.3380445852871e-37 | 8.6760891705742e-37 | 1 |
45 | 5.1123918592687e-36 | 1.02247837185374e-35 | 1 |
46 | 5.50004239488702e-36 | 1.10000847897740e-35 | 1 |
47 | 6.75022643355475e-34 | 1.35004528671095e-33 | 1 |
48 | 1.44401768367416e-33 | 2.88803536734832e-33 | 1 |
49 | 2.09299480306535e-34 | 4.18598960613069e-34 | 1 |
50 | 4.19163535555142e-32 | 8.38327071110284e-32 | 1 |
51 | 2.21146628356113e-29 | 4.42293256712227e-29 | 1 |
52 | 2.71893474635199e-30 | 5.43786949270398e-30 | 1 |
53 | 3.712065905958e-29 | 7.424131811916e-29 | 1 |
54 | 5.61632809586167e-29 | 1.12326561917233e-28 | 1 |
55 | 4.0739089548457e-26 | 8.1478179096914e-26 | 1 |
56 | 9.31927035973944e-24 | 1.86385407194789e-23 | 1 |
57 | 4.51982954021832e-21 | 9.03965908043663e-21 | 1 |
58 | 4.13006081836403e-19 | 8.26012163672806e-19 | 1 |
59 | 1.09322897985719e-14 | 2.18645795971438e-14 | 0.99999999999999 |
60 | 8.9009437117963e-12 | 1.78018874235926e-11 | 0.999999999991099 |
61 | 5.71949717688747e-10 | 1.14389943537749e-09 | 0.99999999942805 |
62 | 3.29092525803138e-09 | 6.58185051606276e-09 | 0.999999996709075 |
63 | 6.24079734958987e-09 | 1.24815946991797e-08 | 0.999999993759203 |
64 | 1.67824884304047e-08 | 3.35649768608094e-08 | 0.999999983217511 |
65 | 2.44914226624297e-08 | 4.89828453248594e-08 | 0.999999975508577 |
66 | 2.98173036990034e-08 | 5.96346073980068e-08 | 0.999999970182696 |
67 | 2.34438292819048e-07 | 4.68876585638095e-07 | 0.999999765561707 |
68 | 6.60040604164e-07 | 1.320081208328e-06 | 0.999999339959396 |
69 | 7.5964238241539e-06 | 1.51928476483078e-05 | 0.999992403576176 |
70 | 0.000189661346692619 | 0.000379322693385239 | 0.999810338653307 |
71 | 0.00127152584473796 | 0.00254305168947591 | 0.998728474155262 |
72 | 0.00150937653321818 | 0.00301875306643637 | 0.998490623466782 |
73 | 0.00115311817542732 | 0.00230623635085464 | 0.998846881824573 |
74 | 0.00167262064054003 | 0.00334524128108005 | 0.99832737935946 |
75 | 0.00383185548531815 | 0.0076637109706363 | 0.996168144514682 |
76 | 0.00680152384226875 | 0.0136030476845375 | 0.99319847615773 |
77 | 0.0137595796261374 | 0.0275191592522747 | 0.986240420373863 |
78 | 0.0138674867508001 | 0.0277349735016001 | 0.9861325132492 |
79 | 0.0167901642270028 | 0.0335803284540055 | 0.983209835772997 |
80 | 0.0214530613749476 | 0.0429061227498952 | 0.978546938625052 |
81 | 0.0299787922685723 | 0.0599575845371446 | 0.970021207731428 |
82 | 0.0863928358771158 | 0.172785671754232 | 0.913607164122884 |
83 | 0.0892278697572785 | 0.178455739514557 | 0.910772130242722 |
84 | 0.133843647484963 | 0.267687294969926 | 0.866156352515037 |
85 | 0.160938948513826 | 0.321877897027652 | 0.839061051486174 |
86 | 0.165753039557685 | 0.33150607911537 | 0.834246960442315 |
87 | 0.198850844374692 | 0.397701688749385 | 0.801149155625308 |
88 | 0.192032498203792 | 0.384064996407584 | 0.807967501796208 |
89 | 0.203591715554156 | 0.407183431108312 | 0.796408284445844 |
90 | 0.170438927288803 | 0.340877854577606 | 0.829561072711197 |
91 | 0.217244816987484 | 0.434489633974967 | 0.782755183012516 |
92 | 0.406303622706191 | 0.812607245412381 | 0.59369637729381 |
93 | 0.99473998521644 | 0.0105200295671213 | 0.00526001478356066 |
94 | 0.99294791429726 | 0.0141041714054785 | 0.00705208570273927 |
95 | 0.98769309631714 | 0.0246138073657191 | 0.0123069036828596 |
96 | 0.989258105752522 | 0.0214837884949563 | 0.0107418942474782 |
97 | 0.98229318770767 | 0.0354136245846597 | 0.0177068122923299 |
98 | 0.974034597854374 | 0.0519308042912523 | 0.0259654021456261 |
99 | 0.97032385637526 | 0.0593522872494803 | 0.0296761436247402 |
100 | 0.958763419245923 | 0.0824731615081533 | 0.0412365807540767 |
101 | 0.980724733434898 | 0.0385505331302036 | 0.0192752665651018 |
102 | 0.986557993521558 | 0.0268840129568846 | 0.0134420064784423 |
103 | 0.975101207420888 | 0.0497975851582234 | 0.0248987925791117 |
104 | 0.962898319128095 | 0.0742033617438094 | 0.0371016808719047 |
105 | 0.978984772708879 | 0.0420304545822421 | 0.0210152272911211 |
106 | 0.99455198029591 | 0.0108960394081803 | 0.00544801970409015 |
107 | 0.987931874595532 | 0.0241362508089368 | 0.0120681254044684 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 66 | 0.673469387755102 | NOK |
5% type I error level | 82 | 0.836734693877551 | NOK |
10% type I error level | 87 | 0.887755102040816 | NOK |