Multiple Linear Regression - Estimated Regression Equation |
Oliezaden[t] = + 108.461953652097 + 51.4663244353184Fluctuatie[t] -0.0077442065121429M1[t] + 1.80475579348780M2[t] + 7.06725579348783M3[t] + 7.41725579348786M4[t] + 10.0672557934878M5[t] + 10.8922557934878M6[t] + 9.30475579348785M7[t] + 8.83804634790263M8[t] + 10.3255463479026M9[t] -5.41428571428569M10[t] -1.11428571428569M11[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) | 108.461953652097 | 7.558603 | 14.3495 | 0 | 0 |
Fluctuatie | 51.4663244353184 | 6.726389 | 7.6514 | 0 | 0 |
M1 | -0.0077442065121429 | 10.266769 | -8e-04 | 0.9994 | 0.4997 |
M2 | 1.80475579348780 | 10.266769 | 0.1758 | 0.860906 | 0.430453 |
M3 | 7.06725579348783 | 10.266769 | 0.6884 | 0.493216 | 0.246608 |
M4 | 7.41725579348786 | 10.266769 | 0.7225 | 0.472123 | 0.236061 |
M5 | 10.0672557934878 | 10.266769 | 0.9806 | 0.329762 | 0.164881 |
M6 | 10.8922557934878 | 10.266769 | 1.0609 | 0.291917 | 0.145959 |
M7 | 9.30475579348785 | 10.266769 | 0.9063 | 0.3675 | 0.18375 |
M8 | 8.83804634790263 | 10.310939 | 0.8572 | 0.393921 | 0.196961 |
M9 | 10.3255463479026 | 10.310939 | 1.0014 | 0.319645 | 0.159822 |
M10 | -5.41428571428569 | 10.602748 | -0.5106 | 0.611003 | 0.305501 |
M11 | -1.11428571428569 | 10.602748 | -0.1051 | 0.916564 | 0.458282 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.665170802242955 |
R-squared | 0.442452196156536 |
Adjusted R-squared | 0.358820025580017 |
F-TEST (value) | 5.29045453569465 |
F-TEST (DF numerator) | 12 |
F-TEST (DF denominator) | 80 |
p-value | 1.72666663089682e-06 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 19.8359247378468 |
Sum Squared Residuals | 31477.1128164418 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 99.5 | 108.454209445585 | -8.95420944558508 |
2 | 101.6 | 110.266709445586 | -8.66670944558562 |
3 | 103.9 | 115.529209445585 | -11.6292094455852 |
4 | 106.6 | 115.879209445585 | -9.27920944558523 |
5 | 108.3 | 118.529209445585 | -10.2292094455852 |
6 | 102 | 119.354209445585 | -17.3542094455853 |
7 | 93.8 | 117.766709445585 | -23.9667094455852 |
8 | 91.6 | 117.3 | -25.7 |
9 | 97.7 | 118.7875 | -21.0875000000000 |
10 | 94.8 | 103.047667937812 | -8.24766793781169 |
11 | 98 | 107.347667937812 | -9.34766793781168 |
12 | 103.8 | 108.461953652097 | -4.66195365209737 |
13 | 97.8 | 108.454209445585 | -10.6542094455852 |
14 | 91.2 | 110.266709445585 | -19.0667094455852 |
15 | 89.3 | 115.529209445585 | -26.2292094455852 |
16 | 87.5 | 115.879209445585 | -28.3792094455852 |
17 | 90.4 | 118.529209445585 | -28.1292094455852 |
18 | 94.2 | 119.354209445585 | -25.1542094455852 |
19 | 102.2 | 117.766709445585 | -15.5667094455852 |
20 | 101.3 | 117.3 | -16 |
21 | 96 | 118.7875 | -22.7875 |
22 | 90.8 | 103.047667937812 | -12.2476679378117 |
23 | 93.2 | 107.347667937812 | -14.1476679378117 |
24 | 90.9 | 108.461953652097 | -17.5619536520974 |
25 | 91.1 | 108.454209445585 | -17.3542094455852 |
26 | 90.2 | 110.266709445585 | -20.0667094455852 |
27 | 94.3 | 115.529209445585 | -21.2292094455852 |
28 | 96 | 115.879209445585 | -19.8792094455852 |
29 | 99 | 118.529209445585 | -19.5292094455852 |
30 | 103.3 | 119.354209445585 | -16.0542094455852 |
31 | 113.1 | 117.766709445585 | -4.66670944558523 |
32 | 112.8 | 117.3 | -4.5 |
33 | 112.1 | 118.7875 | -6.6875 |
34 | 107.4 | 103.047667937812 | 4.35233206218833 |
35 | 111 | 107.347667937812 | 3.65233206218832 |
36 | 110.5 | 108.461953652097 | 2.03804634790263 |
37 | 110.8 | 108.454209445585 | 2.34579055441477 |
38 | 112.4 | 110.266709445585 | 2.13329055441485 |
39 | 111.5 | 115.529209445585 | -4.02920944558522 |
40 | 116.2 | 115.879209445585 | 0.320790554414797 |
41 | 122.5 | 118.529209445585 | 3.97079055441477 |
42 | 121.3 | 119.354209445585 | 1.94579055441478 |
43 | 113.9 | 117.766709445585 | -3.86670944558522 |
44 | 110.7 | 117.3 | -6.59999999999999 |
45 | 120.8 | 118.7875 | 2.01250000000000 |
46 | 141.1 | 154.51399237313 | -13.4139923731299 |
47 | 147.4 | 158.81399237313 | -11.4139923731299 |
48 | 148 | 159.928278087416 | -11.9282780874156 |
49 | 158.1 | 159.920533880904 | -1.82053388090351 |
50 | 165 | 161.733033880903 | 3.26696611909656 |
51 | 187 | 166.995533880904 | 20.0044661190965 |
52 | 190.3 | 167.345533880903 | 22.9544661190965 |
53 | 182.4 | 169.995533880904 | 12.4044661190965 |
54 | 168.8 | 170.820533880903 | -2.02053388090348 |
55 | 151.2 | 169.233033880904 | -18.0330338809035 |
56 | 120.1 | 117.3 | 2.80000000000000 |
57 | 112.5 | 118.7875 | -6.2875 |
58 | 106.2 | 103.047667937812 | 3.15233206218833 |
59 | 107.1 | 107.347667937812 | -0.247667937811685 |
60 | 108.5 | 108.461953652097 | 0.0380463479026356 |
61 | 106.5 | 108.454209445585 | -1.95420944558523 |
62 | 108.3 | 110.266709445585 | -1.96670944558516 |
63 | 125.6 | 115.529209445585 | 10.0707905544148 |
64 | 124 | 115.879209445585 | 8.1207905544148 |
65 | 127.2 | 118.529209445585 | 8.67079055441478 |
66 | 136.9 | 119.354209445585 | 17.5457905544148 |
67 | 135.8 | 117.766709445585 | 18.0332905544148 |
68 | 124.3 | 117.3 | 7 |
69 | 115.4 | 118.7875 | -3.38749999999999 |
70 | 113.6 | 103.047667937812 | 10.5523320621883 |
71 | 114.4 | 107.347667937812 | 7.05233206218833 |
72 | 118.4 | 108.461953652097 | 9.93804634790264 |
73 | 117 | 108.454209445585 | 8.54579055441477 |
74 | 116.5 | 110.266709445585 | 6.23329055441484 |
75 | 115.4 | 115.529209445585 | -0.129209445585217 |
76 | 113.6 | 115.879209445585 | -2.27920944558521 |
77 | 117.4 | 118.529209445585 | -1.12920944558522 |
78 | 116.9 | 119.354209445585 | -2.45420944558521 |
79 | 116.4 | 117.766709445585 | -1.36670944558522 |
80 | 111.1 | 117.3 | -6.2 |
81 | 110.2 | 118.7875 | -8.5875 |
82 | 118.9 | 103.047667937812 | 15.8523320621883 |
83 | 131.8 | 107.347667937812 | 24.4523320621883 |
84 | 130.6 | 108.461953652097 | 22.1380463479026 |
85 | 138.3 | 108.454209445585 | 29.8457905544148 |
86 | 148.4 | 110.266709445585 | 38.1332905544148 |
87 | 148.7 | 115.529209445585 | 33.1707905544148 |
88 | 144.3 | 115.879209445585 | 28.4207905544148 |
89 | 152.5 | 118.529209445585 | 33.9707905544148 |
90 | 162.9 | 119.354209445585 | 43.5457905544148 |
91 | 167.2 | 117.766709445585 | 49.4332905544148 |
92 | 166.5 | 117.3 | 49.2 |
93 | 185.6 | 118.7875 | 66.8125 |