Multiple Linear Regression - Estimated Regression Equation |
Omzet_product[t] = -480.616464654015 + 0.533659564985219Jaar[t] -0.0001356487609356Uitgaven_voor_promotie[t] -0.647651480072149Prijs_product[t] + 0.450211575231433Gem_budget[t] + 0.0196229415021703Index_cons_vertrouwen[t] -0.00826729887996951uitgave_lok_prom[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) | -480.616464654015 | 1248.06171 | -0.3851 | 0.703709 | 0.351854 |
Jaar | 0.533659564985219 | 0.631924 | 0.8445 | 0.407089 | 0.203544 |
Uitgaven_voor_promotie | -0.0001356487609356 | 0.000192 | -0.7065 | 0.486992 | 0.243496 |
Prijs_product | -0.647651480072149 | 0.191151 | -3.3882 | 0.00253 | 0.001265 |
Gem_budget | 0.450211575231433 | 0.000395 | 1139.7472 | 0 | 0 |
Index_cons_vertrouwen | 0.0196229415021703 | 0.084496 | 0.2322 | 0.818409 | 0.409205 |
uitgave_lok_prom | -0.00826729887996951 | 0.008993 | -0.9193 | 0.367474 | 0.183737 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.999992562355233 |
R-squared | 0.999985124765785 |
Adjusted R-squared | 0.999981244269903 |
F-TEST (value) | 257695.190292214 |
F-TEST (DF numerator) | 6 |
F-TEST (DF denominator) | 23 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 28.6248261545832 |
Sum Squared Residuals | 18845.7554647426 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 33907 | 33897.3596777405 | 9.64032225952268 |
2 | 35981 | 35998.911699792 | -17.9116997919542 |
3 | 36588 | 36585.4119880103 | 2.58801198973816 |
4 | 16967 | 16924.9793748368 | 42.0206251632287 |
5 | 25333 | 25308.8724395952 | 24.1275604047555 |
6 | 21027 | 21003.7463817704 | 23.2536182296456 |
7 | 21114 | 21165.3582248238 | -51.358224823775 |
8 | 28777 | 28751.2886074678 | 25.7113925322463 |
9 | 35612 | 35593.5369323211 | 18.4630676788965 |
10 | 24183 | 24168.6493000037 | 14.3506999962515 |
11 | 22262 | 22261.5008351182 | 0.49916488183501 |
12 | 20637 | 20657.0192591705 | -20.0192591705458 |
13 | 29948 | 30001.9668628494 | -53.9668628493769 |
14 | 22093 | 22111.8940516498 | -18.8940516497624 |
15 | 36997 | 36981.4089614716 | 15.5910385284063 |
16 | 31089 | 31108.0939613519 | -19.093961351911 |
17 | 19477 | 19455.4694736393 | 21.5305263606554 |
18 | 31301 | 31341.7415776267 | -40.741577626661 |
19 | 18497 | 18495.5966069799 | 1.4033930200797 |
20 | 30142 | 30157.0786648927 | -15.0786648926774 |
21 | 21326 | 21348.7069476537 | -22.7069476537017 |
22 | 16779 | 16793.0404714474 | -14.0404714473809 |
23 | 38068 | 38071.2495266592 | -3.24952665923964 |
24 | 29707 | 29726.1715794707 | -19.1715794707361 |
25 | 35016 | 35014.7732271573 | 1.22677284270564 |
26 | 26131 | 26104.5260078524 | 26.4739921475894 |
27 | 29251 | 29218.0197758763 | 32.9802241236634 |
28 | 22855 | 22862.5044290525 | -7.50442905250096 |
29 | 31806 | 31759.9739233731 | 46.0260766269477 |
30 | 34124 | 34126.1492303459 | -2.14923034594463 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
10 | 0.591799221867264 | 0.816401556265472 | 0.408200778132736 |
11 | 0.566683106762189 | 0.866633786475622 | 0.433316893237811 |
12 | 0.424909005950854 | 0.849818011901708 | 0.575090994049146 |
13 | 0.890365589268817 | 0.219268821462367 | 0.109634410731183 |
14 | 0.814930966778429 | 0.370138066443143 | 0.185069033221571 |
15 | 0.839596585327379 | 0.320806829345242 | 0.160403414672621 |
16 | 0.819414223314412 | 0.361171553371177 | 0.180585776685588 |
17 | 0.899558068355135 | 0.200883863289731 | 0.100441931644865 |
18 | 0.84324482837422 | 0.31351034325156 | 0.15675517162578 |
19 | 0.7646989626292 | 0.4706020747416 | 0.2353010373708 |
20 | 0.592937233595395 | 0.81412553280921 | 0.407062766404605 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 0 | 0 | OK |
5% type I error level | 0 | 0 | OK |
10% type I error level | 0 | 0 | OK |