Multiple Linear Regression - Estimated Regression Equation |
Veilingprijs[t] = -1338.95134047589 + 12.7405740971494Ouderdom[t] + 85.9529843693435Aantalaanbieders[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) | -1338.95134047589 | 173.809471 | -7.7036 | 0 | 0 |
Ouderdom | 12.7405740971494 | 0.90474 | 14.082 | 0 | 0 |
Aantalaanbieders | 85.9529843693435 | 8.728523 | 9.8474 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.94463956954658 |
R-squared | 0.892343916353148 |
Adjusted R-squared | 0.884919358860261 |
F-TEST (value) | 120.188161679416 |
F-TEST (DF numerator) | 2 |
F-TEST (DF denominator) | 29 |
p-value | 9.2148511043888e-15 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 133.48466783961 |
Sum Squared Residuals | 516726.539899283 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 1235 | 1396.49036666354 | -161.490366663544 |
2 | 1080 | 1157.65049312841 | -77.6504931284076 |
3 | 845 | 880.772460447482 | -35.7724604474823 |
4 | 1522 | 1345.71163342061 | 176.288366579395 |
5 | 1047 | 1164.29612489547 | -117.29612489547 |
6 | 1979 | 1925.31597326807 | 53.6840267319281 |
7 | 1822 | 1680.01403111153 | 141.985968888468 |
8 | 1253 | 1202.33428404126 | 50.6657159587403 |
9 | 1297 | 1180.08417015766 | 116.915829842337 |
10 | 946 | 874.310391826078 | 71.6896081739219 |
11 | 1713 | 1695.80207637372 | 17.1979236262757 |
12 | 1024 | 1097.17865695336 | -73.1786569533627 |
13 | 1147 | 1094.13118578832 | 52.8688142116805 |
14 | 1092 | 1126.07440260402 | -34.0744026040224 |
15 | 1152 | 1269.08462569205 | -117.08462569205 |
16 | 1336 | 1125.89083945836 | 210.109160541636 |
17 | 2131 | 2030.28803721031 | 100.71196278969 |
18 | 1550 | 1667.45702016004 | -117.457020160041 |
19 | 1884 | 1670.50449132508 | 213.495508674916 |
20 | 2041 | 1864.84413709303 | 176.155862906973 |
21 | 845 | 998.668661632529 | -153.668661632529 |
22 | 1483 | 1460.37680029495 | 22.6231997050507 |
23 | 1055 | 1240.37244318705 | -185.372443187049 |
24 | 1545 | 1578.27300148 | -33.2730014799957 |
25 | 729 | 552.748568232301 | 176.251431767699 |
26 | 1792 | 1715.18828223794 | 76.8117177620633 |
27 | 1175 | 1364.54714984784 | -189.547149847841 |
28 | 1593 | 1731.15989064579 | -138.159890645788 |
29 | 785 | 676.923274893092 | 108.076725106908 |
30 | 744 | 727.88557128169 | 16.1144287183101 |
31 | 1356 | 1562.4849562178 | -206.484956217803 |
32 | 1262 | 1403.13599843061 | -141.135998430607 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
6 | 0.61676018655246 | 0.766479626895081 | 0.38323981344754 |
7 | 0.569167572168276 | 0.861664855663449 | 0.430832427831724 |
8 | 0.460321364794833 | 0.920642729589666 | 0.539678635205167 |
9 | 0.429730372352499 | 0.859460744704998 | 0.570269627647501 |
10 | 0.366961668197687 | 0.733923336395374 | 0.633038331802313 |
11 | 0.253268160972244 | 0.506536321944488 | 0.746731839027756 |
12 | 0.178657550858081 | 0.357315101716162 | 0.821342449141919 |
13 | 0.115138720292065 | 0.230277440584131 | 0.884861279707935 |
14 | 0.0771686545781017 | 0.154337309156203 | 0.922831345421898 |
15 | 0.0610487325986577 | 0.122097465197315 | 0.938951267401342 |
16 | 0.139180997005671 | 0.278361994011342 | 0.860819002994329 |
17 | 0.105792039651862 | 0.211584079303723 | 0.894207960348138 |
18 | 0.116439935323897 | 0.232879870647794 | 0.883560064676103 |
19 | 0.229836464239271 | 0.459672928478541 | 0.770163535760729 |
20 | 0.451038329468655 | 0.90207665893731 | 0.548961670531345 |
21 | 0.550564034641836 | 0.898871930716327 | 0.449435965358164 |
22 | 0.497176768749944 | 0.994353537499888 | 0.502823231250056 |
23 | 0.468951826167506 | 0.937903652335012 | 0.531048173832494 |
24 | 0.376901808640385 | 0.753803617280769 | 0.623098191359615 |
25 | 0.363027575986897 | 0.726055151973794 | 0.636972424013103 |
26 | 0.841918990760707 | 0.316162018478587 | 0.158081009239293 |
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 |