Multiple Linear Regression - Estimated Regression Equation |
prijsindex[t] = + 107.336807736924 + 46.1711729207669ontkoppelde_bedrijfstoeslag[t] + 10.3317727408991oogstomvang[t] + 0.345399032884517M1[t] + 1.80789903288454M2[t] + 3.47039903288455M3[t] + 1.78289903288455M4[t] + 3.80789903288454M5[t] + 3.42039903288454M6[t] + 2.10789903288454M7[t] -1.97202598959894M8[t] + 3.97797401040107M9[t] + 6.32797401040107M10[t] + 6.26150241778868M11[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) | 107.336807736924 | 7.933302 | 13.5299 | 0 | 0 |
ontkoppelde_bedrijfstoeslag | 46.1711729207669 | 4.708975 | 9.8049 | 0 | 0 |
oogstomvang | 10.3317727408991 | 4.022555 | 2.5685 | 0.012051 | 0.006026 |
M1 | 0.345399032884517 | 10.707083 | 0.0323 | 0.974345 | 0.487172 |
M2 | 1.80789903288454 | 10.707083 | 0.1689 | 0.866335 | 0.433167 |
M3 | 3.47039903288455 | 10.707083 | 0.3241 | 0.746681 | 0.373341 |
M4 | 1.78289903288455 | 10.707083 | 0.1665 | 0.868166 | 0.434083 |
M5 | 3.80789903288454 | 10.707083 | 0.3556 | 0.723032 | 0.361516 |
M6 | 3.42039903288454 | 10.707083 | 0.3195 | 0.750206 | 0.375103 |
M7 | 2.10789903288454 | 10.707083 | 0.1969 | 0.844423 | 0.422211 |
M8 | -1.97202598959894 | 10.724183 | -0.1839 | 0.854563 | 0.427281 |
M9 | 3.97797401040107 | 10.724183 | 0.3709 | 0.711654 | 0.355827 |
M10 | 6.32797401040107 | 10.724183 | 0.5901 | 0.556789 | 0.278395 |
M11 | 6.26150241778868 | 10.714015 | 0.5844 | 0.560561 | 0.28028 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.747080237425642 |
R-squared | 0.558128881151954 |
Adjusted R-squared | 0.487211294176342 |
F-TEST (value) | 7.8701053568544 |
F-TEST (DF numerator) | 13 |
F-TEST (DF denominator) | 81 |
p-value | 7.13105463567842e-10 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 20.6854981640099 |
Sum Squared Residuals | 34659.0765777537 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 102.7 | 107.682206769808 | -4.98220676980847 |
2 | 103.2 | 109.144706769808 | -5.94470676980827 |
3 | 105.6 | 110.807206769808 | -5.20720676980822 |
4 | 103.9 | 109.119706769808 | -5.21970676980827 |
5 | 107.2 | 111.144706769808 | -3.94470676980828 |
6 | 100.7 | 110.757206769808 | -10.0572067698082 |
7 | 92.1 | 109.444706769808 | -17.3447067698083 |
8 | 90.3 | 105.364781747325 | -15.0647817473248 |
9 | 93.4 | 111.314781747325 | -17.9147817473248 |
10 | 98.5 | 113.664781747325 | -15.1647817473248 |
11 | 100.8 | 113.598310154712 | -12.7983101547124 |
12 | 102.3 | 107.336807736924 | -5.03680773692372 |
13 | 104.7 | 107.682206769808 | -2.98220676980824 |
14 | 101.1 | 109.144706769808 | -8.04470676980827 |
15 | 101.4 | 110.807206769808 | -9.40720676980828 |
16 | 99.5 | 109.119706769808 | -9.61970676980828 |
17 | 98.4 | 111.144706769808 | -12.7447067698083 |
18 | 96.3 | 110.757206769808 | -14.4572067698083 |
19 | 100.7 | 109.444706769808 | -8.74470676980827 |
20 | 101.2 | 105.364781747325 | -4.16478174732478 |
21 | 100.3 | 111.314781747325 | -11.0147817473248 |
22 | 97.8 | 113.664781747325 | -15.8647817473248 |
23 | 97.4 | 113.598310154712 | -16.1983101547124 |
24 | 98.6 | 107.336807736924 | -8.73680773692373 |
25 | 99.7 | 107.682206769808 | -7.98220676980824 |
26 | 99 | 109.144706769808 | -10.1447067698083 |
27 | 98.1 | 110.807206769808 | -12.7072067698083 |
28 | 97 | 109.119706769808 | -12.1197067698083 |
29 | 98.5 | 111.144706769808 | -12.6447067698083 |
30 | 103.8 | 110.757206769808 | -6.95720676980827 |
31 | 114.4 | 109.444706769808 | 4.95529323019174 |
32 | 124.5 | 105.364781747325 | 19.1352182526752 |
33 | 134.2 | 111.314781747325 | 22.8852182526752 |
34 | 131.8 | 113.664781747325 | 18.1352182526752 |
35 | 125.6 | 113.598310154712 | 12.0016898452876 |
36 | 119.9 | 107.336807736924 | 12.5631922630763 |
37 | 114.9 | 107.682206769808 | 7.21779323019176 |
38 | 115.5 | 109.144706769808 | 6.35529323019173 |
39 | 112.5 | 110.807206769808 | 1.69279323019172 |
40 | 111.4 | 109.119706769808 | 2.28029323019173 |
41 | 115.3 | 111.144706769808 | 4.15529323019172 |
42 | 110.8 | 110.757206769808 | 0.0427932301917265 |
43 | 103.7 | 109.444706769808 | -5.74470676980827 |
44 | 111.1 | 115.696554488224 | -4.59655448822387 |
45 | 113 | 121.646554488224 | -8.64655448822388 |
46 | 111.2 | 123.996554488224 | -12.7965544882239 |
47 | 117.6 | 123.930082895611 | -6.3300828956115 |
48 | 121.7 | 117.668580477823 | 4.0314195221772 |
49 | 127.3 | 118.013979510707 | 9.28602048929267 |
50 | 129.8 | 119.476479510707 | 10.3235204892927 |
51 | 137.1 | 121.138979510707 | 15.9610204892926 |
52 | 141.4 | 119.451479510707 | 21.9485204892926 |
53 | 137.4 | 121.476479510707 | 15.9235204892927 |
54 | 130.7 | 121.088979510707 | 9.61102048929263 |
55 | 117.2 | 119.776479510707 | -2.57647951070735 |
56 | 110.8 | 95.0330090064257 | 15.7669909935743 |
57 | 111.4 | 100.983009006426 | 10.4169909935743 |
58 | 108.2 | 103.333009006426 | 4.86699099357429 |
59 | 108.8 | 103.266537413813 | 5.53346258618667 |
60 | 110.2 | 97.0050349960246 | 13.1949650039754 |
61 | 109.5 | 97.3504340289092 | 12.1495659710908 |
62 | 109.5 | 98.8129340289092 | 10.6870659710908 |
63 | 116 | 100.475434028909 | 15.5245659710908 |
64 | 111.2 | 98.7879340289092 | 12.4120659710908 |
65 | 112.1 | 100.812934028909 | 11.2870659710908 |
66 | 114 | 100.425434028909 | 13.5745659710908 |
67 | 119.1 | 99.1129340289092 | 19.9870659710908 |
68 | 114.1 | 141.204181927193 | -27.1041819271926 |
69 | 115.1 | 147.154181927193 | -32.0541819271926 |
70 | 115.4 | 149.504181927193 | -34.1041819271926 |
71 | 110.8 | 159.769483075479 | -48.9694830754793 |
72 | 116 | 153.507980657691 | -37.5079806576906 |
73 | 119.2 | 153.853379690575 | -34.6533796905752 |
74 | 126.5 | 155.315879690575 | -28.8158796905752 |
75 | 127.8 | 156.978379690575 | -29.1783796905752 |
76 | 131.3 | 155.290879690575 | -23.9908796905752 |
77 | 140.3 | 157.315879690575 | -17.0158796905752 |
78 | 137.3 | 156.928379690575 | -19.6283796905752 |
79 | 143 | 155.615879690575 | -12.6158796905752 |
80 | 134.5 | 151.535954668092 | -17.0359546680917 |
81 | 139.9 | 157.485954668092 | -17.5859546680917 |
82 | 159.3 | 159.835954668092 | -0.535954668091706 |
83 | 170.4 | 159.769483075479 | 10.6305169245207 |
84 | 175 | 153.507980657691 | 21.4920193423094 |
85 | 175.8 | 153.853379690575 | 21.9466203094248 |
86 | 180.9 | 155.315879690575 | 25.5841203094248 |
87 | 180.3 | 156.978379690575 | 23.3216203094248 |
88 | 169.6 | 155.290879690575 | 14.3091203094248 |
89 | 172.3 | 157.315879690575 | 14.9841203094248 |
90 | 184.8 | 156.928379690575 | 27.8716203094248 |
91 | 177.7 | 155.615879690575 | 22.0841203094248 |
92 | 184.6 | 151.535954668092 | 33.0640453319083 |
93 | 211.4 | 157.485954668092 | 53.9140453319083 |
94 | 215.3 | 159.835954668092 | 55.4640453319083 |
95 | 215.9 | 159.769483075479 | 56.1305169245207 |