Multiple Linear Regression - Estimated Regression Equation |
Apple[t] = -167.424814295902 -8.72819190638523Omzetgroei[t] -4.30135459798218e-07Volume[t] + 8.83841129074744Microsoft[t] -0.66873809382994Consumentenvertrouwen[t] + 6.27872053212582M1[t] + 10.5105860530226M2[t] + 15.0431505457878M3[t] + 18.1188764739720M4[t] + 24.7843160355318M5[t] + 17.5713482106206M6[t] + 22.3168235770649M7[t] + 19.8568271551399M8[t] + 21.4874096649532M9[t] + 3.79266552398288M10[t] + 0.0655665756245509M11[t] + 1.54972876039673t + 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) | -167.424814295902 | 19.521004 | -8.5766 | 0 | 0 |
Omzetgroei | -8.72819190638523 | 10.288069 | -0.8484 | 0.398253 | 0.199126 |
Volume | -4.30135459798218e-07 | 0 | -1.6745 | 0.09715 | 0.048575 |
Microsoft | 8.83841129074744 | 0.832748 | 10.6135 | 0 | 0 |
Consumentenvertrouwen | -0.66873809382994 | 0.160171 | -4.1751 | 6.4e-05 | 3.2e-05 |
M1 | 6.27872053212582 | 11.415391 | 0.55 | 0.58353 | 0.291765 |
M2 | 10.5105860530226 | 11.063574 | 0.95 | 0.344394 | 0.172197 |
M3 | 15.0431505457878 | 11.009187 | 1.3664 | 0.174872 | 0.087436 |
M4 | 18.1188764739720 | 10.957164 | 1.6536 | 0.101343 | 0.050671 |
M5 | 24.7843160355318 | 11.040727 | 2.2448 | 0.026983 | 0.013492 |
M6 | 17.5713482106206 | 10.992791 | 1.5984 | 0.1131 | 0.05655 |
M7 | 22.3168235770649 | 10.983927 | 2.0318 | 0.044829 | 0.022415 |
M8 | 19.8568271551399 | 11.066657 | 1.7943 | 0.075788 | 0.037894 |
M9 | 21.4874096649532 | 10.957483 | 1.961 | 0.052663 | 0.026331 |
M10 | 3.79266552398288 | 11.329386 | 0.3348 | 0.738505 | 0.369252 |
M11 | 0.0655665756245509 | 11.145967 | 0.0059 | 0.995318 | 0.497659 |
t | 1.54972876039673 | 0.147584 | 10.5007 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.957710226610274 |
R-squared | 0.917208878153903 |
Adjusted R-squared | 0.903962298658528 |
F-TEST (value) | 69.241186260507 |
F-TEST (DF numerator) | 16 |
F-TEST (DF denominator) | 100 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 23.5449579349573 |
Sum Squared Residuals | 55436.5044158911 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 10.81 | -29.1289346330786 | 39.9389346330786 |
2 | 9.12 | -21.8629293042176 | 30.9829293042175 |
3 | 11.03 | -37.8618195587563 | 48.8918195587563 |
4 | 12.74 | 15.8191941614226 | -3.07919416142259 |
5 | 9.98 | 28.4414830991175 | -18.4614830991175 |
6 | 11.62 | 33.9882169765274 | -22.3682169765274 |
7 | 9.4 | 17.6408173547179 | -8.24081735471787 |
8 | 9.27 | -11.1474465044169 | 20.4174465044169 |
9 | 7.76 | -19.8369714406764 | 27.5969714406764 |
10 | 8.78 | -7.831002486951 | 16.611002486951 |
11 | 10.65 | 12.8078003888549 | -2.15780038885488 |
12 | 10.95 | 15.4526920100372 | -4.50269201003722 |
13 | 12.36 | 12.1036487574918 | 0.256351242508245 |
14 | 10.85 | 0.620794122307139 | 10.2292058776929 |
15 | 11.84 | 5.72395740774697 | 6.11604259225303 |
16 | 12.14 | -16.5775122145614 | 28.7175122145614 |
17 | 11.65 | -14.0859379216871 | 25.7359379216871 |
18 | 8.86 | -6.1075695953539 | 14.9675695953539 |
19 | 7.63 | -16.8562599716215 | 24.4862599716215 |
20 | 7.38 | -9.78485602718026 | 17.1648560271803 |
21 | 7.25 | -25.4985835759382 | 32.7485835759382 |
22 | 8.03 | 1.23196201938232 | 6.79803798061768 |
23 | 7.75 | 11.3812859040641 | -3.63128590406407 |
24 | 7.16 | -5.31966796601336 | 12.4796679660134 |
25 | 7.18 | -11.7249246568766 | 18.9049246568766 |
26 | 7.51 | 4.96057352962868 | 2.54942647037132 |
27 | 7.07 | 17.2899390327428 | -10.2199390327428 |
28 | 7.11 | 14.7279488222825 | -7.61794882228252 |
29 | 8.98 | 12.2329173121377 | -3.25291731213774 |
30 | 9.53 | 17.5267717732773 | -7.99677177327734 |
31 | 10.54 | 33.4039351298877 | -22.8639351298877 |
32 | 11.31 | 30.6567552749444 | -19.3467552749444 |
33 | 10.36 | 45.3067025210455 | -34.9467025210455 |
34 | 11.44 | 13.0754575258651 | -1.63545752586509 |
35 | 10.45 | 1.34700980675376 | 9.10299019324624 |
36 | 10.69 | 15.3627618198796 | -4.67276181987963 |
37 | 11.28 | 20.3781618147631 | -9.09816181476309 |
38 | 11.96 | 25.2728146088783 | -13.3128146088783 |
39 | 13.52 | 16.2860072990066 | -2.76600729900656 |
40 | 12.89 | 27.5456874102571 | -14.6556874102571 |
41 | 14.03 | 39.0887992601856 | -25.0587992601856 |
42 | 16.27 | 41.4498449447815 | -25.1798449447815 |
43 | 16.17 | 43.7135139851325 | -27.5435139851325 |
44 | 17.25 | 41.0322112286433 | -23.7822112286433 |
45 | 19.38 | 47.957566689102 | -28.5775666891020 |
46 | 26.2 | 26.9848384046912 | -0.78483840469119 |
47 | 33.53 | 37.5638539443877 | -4.03385394438768 |
48 | 32.2 | 33.7655396498255 | -1.56553964982551 |
49 | 38.45 | 27.1047709883906 | 11.3452290116094 |
50 | 44.86 | 28.2152262679419 | 16.6447737320581 |
51 | 41.67 | 34.4560788646183 | 7.21392113538167 |
52 | 36.06 | 47.4625291208946 | -11.4025291208946 |
53 | 39.76 | 61.4918559914739 | -21.7318559914739 |
54 | 36.81 | 47.5662944562746 | -10.7562944562746 |
55 | 42.65 | 63.3982633935495 | -20.7482633935495 |
56 | 46.89 | 77.702976868646 | -30.812976868646 |
57 | 53.61 | 76.7894369524919 | -23.1794369524919 |
58 | 57.59 | 56.2951178397668 | 1.29488216023321 |
59 | 67.82 | 66.0204213227497 | 1.79957867725033 |
60 | 71.89 | 51.718786966296 | 20.1712130337040 |
61 | 75.51 | 68.8686566886356 | 6.64134331136442 |
62 | 68.49 | 69.071756514849 | -0.581756514848955 |
63 | 62.72 | 74.8427344024244 | -12.1227344024244 |
64 | 70.39 | 53.2307715219882 | 17.1592284780118 |
65 | 59.77 | 58.454383717183 | 1.31561628281698 |
66 | 57.27 | 56.1779314592343 | 1.09206854076570 |
67 | 67.96 | 66.0774898296879 | 1.88251017031206 |
68 | 67.85 | 85.6368170614178 | -17.7868170614178 |
69 | 76.98 | 96.8473018730143 | -19.8673018730143 |
70 | 81.08 | 96.5646572599 | -15.4846572598999 |
71 | 91.66 | 99.9915897284772 | -8.33158972847715 |
72 | 84.84 | 99.4434417737356 | -14.6034417737356 |
73 | 85.73 | 107.742314508484 | -22.0123145084845 |
74 | 84.61 | 101.362023352933 | -16.7520233529329 |
75 | 92.91 | 107.279193279517 | -14.369193279517 |
76 | 99.8 | 130.430002832845 | -30.6300028328452 |
77 | 121.19 | 141.937008363237 | -20.7470083632374 |
78 | 122.04 | 123.507306046263 | -1.46730604626286 |
79 | 131.76 | 119.604966151996 | 12.1550338480041 |
80 | 138.48 | 123.584783515897 | 14.8952164841034 |
81 | 153.47 | 136.380498835399 | 17.0895011646011 |
82 | 189.95 | 184.374081452730 | 5.57591854727026 |
83 | 182.22 | 157.593166659243 | 24.6268333407566 |
84 | 198.08 | 180.179466815272 | 17.9005331847278 |
85 | 135.36 | 151.444911624608 | -16.0849116246079 |
86 | 125.02 | 127.552761331245 | -2.53276133124545 |
87 | 143.5 | 152.419301067743 | -8.9193010677427 |
88 | 173.95 | 163.407098659772 | 10.5429013402276 |
89 | 188.75 | 176.900514929889 | 11.8494850701109 |
90 | 167.44 | 168.277653301704 | -0.837653301703777 |
91 | 158.95 | 155.784767286365 | 3.16523271363479 |
92 | 169.53 | 168.650480585262 | 0.879519414737715 |
93 | 113.66 | 156.068556343813 | -42.4085563438127 |
94 | 107.59 | 113.744518120294 | -6.154518120294 |
95 | 92.67 | 100.310998012182 | -7.64099801218245 |
96 | 85.35 | 104.266506063077 | -18.916506063077 |
97 | 90.13 | 115.575994244093 | -25.4459942440926 |
98 | 89.31 | 102.575169337853 | -13.2651693378535 |
99 | 105.12 | 127.117420713788 | -21.9974207137881 |
100 | 125.83 | 139.387273796008 | -13.5572737960081 |
101 | 135.81 | 146.178344363205 | -10.3683443632048 |
102 | 142.43 | 167.312791478231 | -24.8827914782306 |
103 | 163.39 | 175.964235147452 | -12.574235147452 |
104 | 168.21 | 182.912081270901 | -14.7020812709006 |
105 | 185.35 | 194.518521350729 | -9.16852135072932 |
106 | 188.5 | 194.720369864322 | -6.22036986432195 |
107 | 199.91 | 209.643874233287 | -9.73387423328693 |
108 | 210.73 | 217.020472867890 | -6.2904728678903 |
109 | 192.06 | 196.505400663489 | -4.44540066348925 |
110 | 204.62 | 218.581810238581 | -13.9618102385807 |
111 | 235 | 226.827187491169 | 8.17281250883056 |
112 | 261.09 | 236.567005889091 | 24.5229941109093 |
113 | 256.88 | 196.160630885258 | 60.7193691147421 |
114 | 251.53 | 174.100759159061 | 77.4292408409385 |
115 | 257.25 | 206.968271692833 | 50.2817283071671 |
116 | 243.1 | 190.026196725886 | 53.0738032741139 |
117 | 283.75 | 203.03697045102 | 80.71302954898 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
20 | 0.000298062341214584 | 0.000596124682429168 | 0.999701937658785 |
21 | 2.10230122855615e-05 | 4.20460245711231e-05 | 0.999978976987714 |
22 | 1.64092555787286e-06 | 3.28185111574572e-06 | 0.999998359074442 |
23 | 1.31343213228661e-07 | 2.62686426457322e-07 | 0.999999868656787 |
24 | 7.44455761869439e-09 | 1.48891152373888e-08 | 0.999999992555442 |
25 | 7.72586811908544e-10 | 1.54517362381709e-09 | 0.999999999227413 |
26 | 7.01162955072654e-11 | 1.40232591014531e-10 | 0.999999999929884 |
27 | 3.94236890332906e-12 | 7.88473780665813e-12 | 0.999999999996058 |
28 | 3.23935930685226e-12 | 6.47871861370452e-12 | 0.99999999999676 |
29 | 2.92733709203216e-13 | 5.85467418406431e-13 | 0.999999999999707 |
30 | 4.10100907222041e-14 | 8.20201814444082e-14 | 0.99999999999996 |
31 | 1.62761385744921e-14 | 3.25522771489842e-14 | 0.999999999999984 |
32 | 3.16374958345139e-15 | 6.32749916690279e-15 | 0.999999999999997 |
33 | 2.28967388533606e-16 | 4.57934777067213e-16 | 1 |
34 | 2.34307109995587e-17 | 4.68614219991175e-17 | 1 |
35 | 2.35543625184074e-18 | 4.71087250368148e-18 | 1 |
36 | 2.01910832410833e-19 | 4.03821664821666e-19 | 1 |
37 | 5.4717579624161e-20 | 1.09435159248322e-19 | 1 |
38 | 5.57354219456854e-21 | 1.11470843891371e-20 | 1 |
39 | 1.01640108419724e-21 | 2.03280216839449e-21 | 1 |
40 | 9.9357642601199e-23 | 1.98715285202398e-22 | 1 |
41 | 1.82343342329806e-23 | 3.64686684659612e-23 | 1 |
42 | 7.36302382080776e-24 | 1.47260476416155e-23 | 1 |
43 | 8.04296570733311e-25 | 1.60859314146662e-24 | 1 |
44 | 2.52162742389237e-25 | 5.04325484778473e-25 | 1 |
45 | 4.81289543358375e-25 | 9.6257908671675e-25 | 1 |
46 | 8.94377176984193e-24 | 1.78875435396839e-23 | 1 |
47 | 9.2873509559076e-22 | 1.85747019118152e-21 | 1 |
48 | 1.32624221022537e-21 | 2.65248442045074e-21 | 1 |
49 | 2.25831446702500e-22 | 4.51662893405001e-22 | 1 |
50 | 1.86554228222618e-21 | 3.73108456445236e-21 | 1 |
51 | 6.4457706576303e-19 | 1.28915413152606e-18 | 1 |
52 | 1.27760077447776e-19 | 2.55520154895553e-19 | 1 |
53 | 7.99468666600894e-19 | 1.59893733320179e-18 | 1 |
54 | 1.39816679161451e-18 | 2.79633358322901e-18 | 1 |
55 | 2.90173885318742e-16 | 5.80347770637484e-16 | 1 |
56 | 1.04121122947436e-14 | 2.08242245894871e-14 | 0.99999999999999 |
57 | 9.46406655694178e-13 | 1.89281331138836e-12 | 0.999999999999054 |
58 | 1.09682883884725e-11 | 2.19365767769450e-11 | 0.999999999989032 |
59 | 4.69579445067325e-10 | 9.3915889013465e-10 | 0.99999999953042 |
60 | 1.13161093849962e-08 | 2.26322187699924e-08 | 0.99999998868389 |
61 | 2.77285856367911e-08 | 5.54571712735822e-08 | 0.999999972271414 |
62 | 2.26406705423355e-08 | 4.5281341084671e-08 | 0.99999997735933 |
63 | 1.21880737176313e-08 | 2.43761474352626e-08 | 0.999999987811926 |
64 | 1.37858336903611e-08 | 2.75716673807223e-08 | 0.999999986214166 |
65 | 7.21431811323129e-09 | 1.44286362264626e-08 | 0.999999992785682 |
66 | 3.1774502657413e-09 | 6.3549005314826e-09 | 0.99999999682255 |
67 | 1.68933674434146e-09 | 3.37867348868292e-09 | 0.999999998310663 |
68 | 6.37325753804302e-10 | 1.27465150760860e-09 | 0.999999999362674 |
69 | 2.32560519979752e-10 | 4.65121039959504e-10 | 0.99999999976744 |
70 | 8.95938626215301e-11 | 1.79187725243060e-10 | 0.999999999910406 |
71 | 5.0587852257088e-11 | 1.01175704514176e-10 | 0.999999999949412 |
72 | 2.21416893512476e-11 | 4.42833787024952e-11 | 0.999999999977858 |
73 | 1.21613418981507e-11 | 2.43226837963014e-11 | 0.999999999987839 |
74 | 4.66958290754624e-12 | 9.33916581509249e-12 | 0.99999999999533 |
75 | 3.45376561719772e-12 | 6.90753123439543e-12 | 0.999999999996546 |
76 | 6.83441154359331e-12 | 1.36688230871866e-11 | 0.999999999993166 |
77 | 1.82677310352172e-10 | 3.65354620704344e-10 | 0.999999999817323 |
78 | 1.46059632304137e-09 | 2.92119264608274e-09 | 0.999999998539404 |
79 | 1.29112628497994e-08 | 2.58225256995988e-08 | 0.999999987088737 |
80 | 1.06272791761512e-07 | 2.12545583523024e-07 | 0.999999893727208 |
81 | 1.72609360441872e-06 | 3.45218720883744e-06 | 0.999998273906396 |
82 | 2.42790336043989e-05 | 4.85580672087978e-05 | 0.999975720966396 |
83 | 0.000110652464152783 | 0.000221304928305566 | 0.999889347535847 |
84 | 0.00248714269368213 | 0.00497428538736427 | 0.997512857306318 |
85 | 0.00169965019642766 | 0.00339930039285532 | 0.998300349803572 |
86 | 0.00171519202309681 | 0.00343038404619362 | 0.998284807976903 |
87 | 0.00173255273999119 | 0.00346510547998239 | 0.998267447260009 |
88 | 0.0144975911513669 | 0.0289951823027337 | 0.985502408848633 |
89 | 0.0524945685855273 | 0.104989137171055 | 0.947505431414473 |
90 | 0.112909635390280 | 0.225819270780560 | 0.88709036460972 |
91 | 0.157451085487680 | 0.314902170975361 | 0.84254891451232 |
92 | 0.962871427458066 | 0.0742571450838675 | 0.0371285725419337 |
93 | 0.984890666247923 | 0.0302186675041538 | 0.0151093337520769 |
94 | 0.974204228246163 | 0.0515915435076742 | 0.0257957717538371 |
95 | 0.953848227983956 | 0.0923035440320882 | 0.0461517720160441 |
96 | 0.920666898298994 | 0.158666203402013 | 0.0793331017010065 |
97 | 0.824171674672076 | 0.351656650655847 | 0.175828325327924 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 68 | 0.871794871794872 | NOK |
5% type I error level | 70 | 0.897435897435897 | NOK |
10% type I error level | 73 | 0.935897435897436 | NOK |