Multiple Linear Regression - Estimated Regression Equation |
veilingprijs[t] = -1294.27677878245 + 12.8537823990847Ouderdom[t] + 83.8868925815814Aantal_bieders[t] -2.50850015776336t + 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) | -1294.27677878245 | 180.698473 | -7.1626 | 0 | 0 |
Ouderdom | 12.8537823990847 | 0.914943 | 14.0487 | 0 | 0 |
Aantal_bieders | 83.8868925815814 | 9.025743 | 9.2942 | 0 | 0 |
t | -2.50850015776336 | 2.694479 | -0.931 | 0.359823 | 0.179912 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.94634891894696 |
R-squared | 0.89557627639208 |
Adjusted R-squared | 0.884388020291231 |
F-TEST (value) | 80.046100868584 |
F-TEST (DF numerator) | 3 |
F-TEST (DF denominator) | 28 |
p-value | 7.54951656745106e-14 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 133.792468841566 |
Sum Squared Residuals | 501211.8921242 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 1235 | 1426.17468930411 | -191.174689304109 |
2 | 1080 | 1185.53390777575 | -105.533907775748 |
3 | 845 | 917.836333499095 | -72.8363334990947 |
4 | 1522 | 1378.73861368344 | 143.261386316557 |
5 | 1047 | 1201.69213017544 | -154.692130175444 |
6 | 1979 | 1952.81643530179 | 26.1835646982086 |
7 | 1822 | 1699.99648534941 | 122.003514650594 |
8 | 1253 | 1221.22342245045 | 31.776577549554 |
9 | 1297 | 1199.09694170652 | 97.903058293475 |
10 | 946 | 888.097663970728 | 57.9023360292722 |
11 | 1713 | 1697.40129688049 | 15.5987031195132 |
12 | 1024 | 1102.2695784147 | -78.2695784147029 |
13 | 1147 | 1105.17604849389 | 41.8239515061099 |
14 | 1092 | 1140.55428155832 | -48.5542815583197 |
15 | 1152 | 1262.51786310458 | -110.517863104576 |
16 | 1336 | 1124.03272679383 | 211.967273206169 |
17 | 2131 | 2022.63822252212 | 108.361777477878 |
18 | 1550 | 1671.05375566389 | -121.053755663887 |
19 | 1884 | 1663.13028526917 | 220.869714730827 |
20 | 2041 | 1859.51810530969 | 181.481894690308 |
21 | 845 | 994.456956463129 | -149.456956463129 |
22 | 1483 | 1449.26965243547 | 33.7303475645344 |
23 | 1055 | 1210.65271283229 | -155.652712832287 |
24 | 1545 | 1566.02627792371 | -21.0262779237134 |
25 | 729 | 534.540571864109 | 194.459428135891 |
26 | 1792 | 1696.31129978611 | 95.688700213893 |
27 | 1175 | 1323.06695198007 | -148.06695198007 |
28 | 1593 | 1710.23766608168 | -117.237666081677 |
29 | 785 | 646.954811011892 | 138.045188988108 |
30 | 744 | 695.861440450467 | 48.1385595495328 |
31 | 1356 | 1541.02796465724 | -185.027964657236 |
32 | 1262 | 1372.09490728643 | -110.094907286432 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
7 | 0.616362950372345 | 0.76727409925531 | 0.383637049627655 |
8 | 0.482148965790258 | 0.964297931580517 | 0.517851034209742 |
9 | 0.327113330685627 | 0.654226661371254 | 0.672886669314373 |
10 | 0.208715045345977 | 0.417430090691953 | 0.791284954654023 |
11 | 0.178634505937174 | 0.357269011874348 | 0.821365494062826 |
12 | 0.190867974485544 | 0.381735948971088 | 0.809132025514456 |
13 | 0.119434751690945 | 0.238869503381889 | 0.880565248309055 |
14 | 0.125779796860167 | 0.251559593720334 | 0.874220203139833 |
15 | 0.161173328355622 | 0.322346656711243 | 0.838826671644378 |
16 | 0.191916590868518 | 0.383833181737037 | 0.808083409131482 |
17 | 0.132569691485391 | 0.265139382970781 | 0.86743030851461 |
18 | 0.246100273688985 | 0.492200547377969 | 0.753899726311015 |
19 | 0.285800029430385 | 0.571600058860769 | 0.714199970569615 |
20 | 0.390149591096049 | 0.780299182192098 | 0.609850408903951 |
21 | 0.777690207812307 | 0.444619584375387 | 0.222309792187693 |
22 | 0.661802340816536 | 0.676395318366928 | 0.338197659183464 |
23 | 0.76729028295568 | 0.465419434088639 | 0.23270971704432 |
24 | 0.705497981046286 | 0.589004037907427 | 0.294502018953714 |
25 | 0.750974484964861 | 0.498051030070278 | 0.249025515035139 |
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 |