Multiple Linear Regression - Estimated Regression Equation |
olie[t] = + 266.990447890280 + 0.0738268262780373auto[t] -1.94100985624765electric[t] -0.140847432036701vervoer[t] -9.69338508432732M1[t] -2.94497280317953M2[t] + 16.3592288303806M3[t] + 35.8549981526060M4[t] + 44.8296305047298M5[t] + 48.893937994268M6[t] + 32.3703754437297M7[t] + 18.5310130663871M8[t] + 26.9018041142079M9[t] + 10.5413368531085M10[t] + 5.13864638469737M11[t] + 0.653509189796642t + 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) | 266.990447890280 | 59.374346 | 4.4967 | 3.5e-05 | 1.8e-05 |
auto | 0.0738268262780373 | 0.262954 | 0.2808 | 0.77993 | 0.389965 |
electric | -1.94100985624765 | 0.55603 | -3.4908 | 0.000947 | 0.000473 |
vervoer | -0.140847432036701 | 0.254161 | -0.5542 | 0.581672 | 0.290836 |
M1 | -9.69338508432732 | 14.705934 | -0.6591 | 0.512502 | 0.256251 |
M2 | -2.94497280317953 | 17.124992 | -0.172 | 0.864082 | 0.432041 |
M3 | 16.3592288303806 | 14.507954 | 1.1276 | 0.264295 | 0.132148 |
M4 | 35.8549981526060 | 15.117273 | 2.3718 | 0.021165 | 0.010582 |
M5 | 44.8296305047298 | 19.403066 | 2.3104 | 0.024572 | 0.012286 |
M6 | 48.893937994268 | 25.532501 | 1.915 | 0.060609 | 0.030305 |
M7 | 32.3703754437297 | 19.619087 | 1.6499 | 0.104553 | 0.052277 |
M8 | 18.5310130663871 | 14.926831 | 1.2415 | 0.219612 | 0.109806 |
M9 | 26.9018041142079 | 15.917039 | 1.6901 | 0.096564 | 0.048282 |
M10 | 10.5413368531085 | 13.776977 | 0.7651 | 0.4474 | 0.2237 |
M11 | 5.13864638469737 | 12.55453 | 0.4093 | 0.683876 | 0.341938 |
t | 0.653509189796642 | 0.162906 | 4.0116 | 0.000181 | 9e-05 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.640211545029573 |
R-squared | 0.409870822389154 |
Adjusted R-squared | 0.251800506957677 |
F-TEST (value) | 2.59296517040755 |
F-TEST (DF numerator) | 15 |
F-TEST (DF denominator) | 56 |
p-value | 0.00510596940206898 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 21.2585706020548 |
Sum Squared Residuals | 25307.9021463827 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 85.6 | 83.3455065308451 | 2.25449346915486 |
2 | 89 | 91.2666880576695 | -2.26668805766948 |
3 | 97.5 | 90.5569410093282 | 6.9430589906718 |
4 | 104 | 97.8114522282626 | 6.18854777173742 |
5 | 99.4 | 96.696731403897 | 2.70326859610300 |
6 | 103.2 | 79.0850881901762 | 24.1149118098238 |
7 | 103 | 53.2149357925202 | 49.7850642074798 |
8 | 91.2 | 76.9834601987568 | 14.2165398012432 |
9 | 85.9 | 81.2696890777685 | 4.63031092223150 |
10 | 80.7 | 73.9185398033182 | 6.78146019668178 |
11 | 86.7 | 77.2999661576444 | 9.4000338423556 |
12 | 80.7 | 87.546939216811 | -6.84693921681092 |
13 | 81.5 | 94.2161179342861 | -12.7161179342861 |
14 | 83.4 | 81.8887415669889 | 1.51125843301116 |
15 | 83.5 | 93.4385307427412 | -9.93853074274125 |
16 | 89.5 | 87.4897616732957 | 2.01023832670432 |
17 | 85.8 | 93.8847295218022 | -8.0847295218022 |
18 | 77.4 | 85.905094818784 | -8.50509481878397 |
19 | 67.5 | 63.7748728337593 | 3.72512716624068 |
20 | 63.7 | 75.3211136666966 | -11.6211136666966 |
21 | 59.4 | 76.8555509408117 | -17.4555509408117 |
22 | 62 | 72.213301559546 | -10.2133015595460 |
23 | 62.4 | 76.0033285364186 | -13.6033285364185 |
24 | 58.1 | 78.03520732092 | -19.9352073209200 |
25 | 58 | 76.4924496364872 | -18.4924496364872 |
26 | 56.3 | 78.5473370931052 | -22.2473370931052 |
27 | 61.4 | 84.0901196301006 | -22.6901196301006 |
28 | 59.8 | 81.5771210803696 | -21.7771210803696 |
29 | 54.3 | 86.2626241298411 | -31.9626241298411 |
30 | 47 | 69.324939636073 | -22.3249396360730 |
31 | 50.5 | 83.864472968368 | -33.364472968368 |
32 | 48.1 | 75.3902329827201 | -27.2902329827201 |
33 | 58.8 | 72.5677574629518 | -13.7677574629518 |
34 | 70.4 | 75.2045772641017 | -4.80457726410166 |
35 | 71.9 | 87.9010644595542 | -16.0010644595542 |
36 | 73.3 | 86.6091851480366 | -13.3091851480366 |
37 | 83.5 | 83.5347654921634 | -0.0347654921634399 |
38 | 90.1 | 90.8454963154327 | -0.745496315432724 |
39 | 101.3 | 99.8975042349588 | 1.40249576504123 |
40 | 98.3 | 91.429863094446 | 6.87013690555391 |
41 | 106.7 | 84.9822540491347 | 21.7177459508653 |
42 | 109.9 | 85.7056486023754 | 24.1943513976246 |
43 | 111.1 | 103.783903793805 | 7.3160962061947 |
44 | 119 | 90.003576101003 | 28.996423898997 |
45 | 120.7 | 88.6777128256726 | 32.0222871743274 |
46 | 104.5 | 91.2196282182169 | 13.2803717817831 |
47 | 121.6 | 107.051450516601 | 14.5485494833988 |
48 | 129.6 | 103.355385070724 | 26.2446149292757 |
49 | 124.5 | 97.9590885209472 | 26.5409114790528 |
50 | 130.1 | 106.245191358240 | 23.8548086417596 |
51 | 142.3 | 110.186798287325 | 32.1132017126751 |
52 | 140 | 109.101385037771 | 30.8986149622290 |
53 | 143.3 | 100.909325072354 | 42.3906749276463 |
54 | 113.4 | 99.6303838786358 | 13.7696161213642 |
55 | 113.8 | 115.297647084876 | -1.49764708487557 |
56 | 120.7 | 99.7925197841132 | 20.9074802158868 |
57 | 112.9 | 100.456870293814 | 12.4431297061856 |
58 | 115.5 | 105.853910892067 | 9.64608910793288 |
59 | 121.9 | 119.313732537439 | 2.58626746256124 |
60 | 119.3 | 110.698033349032 | 8.60196665096763 |
61 | 111 | 108.552071885271 | 2.44792811472914 |
62 | 114.2 | 114.306545608563 | -0.106545608563337 |
63 | 113.5 | 121.330106095546 | -7.83010609554628 |
64 | 94 | 118.190416885855 | -24.190416885855 |
65 | 83.2 | 109.964335822971 | -26.7643358229713 |
66 | 82.8 | 114.048844873956 | -31.2488448739556 |
67 | 85.8 | 111.764167526672 | -25.9641675266717 |
68 | 88.7 | 113.909097266710 | -25.2090972667102 |
69 | 105.3 | 123.172419398981 | -17.872419398981 |
70 | 113.1 | 127.79004226275 | -14.6900422627501 |
71 | 113.8 | 110.730457792343 | 3.06954220765711 |
72 | 109.4 | 104.155249894476 | 5.24475010552434 |