Multiple Linear Regression - Estimated Regression Equation |
Oliezaden[t] = + 83.2959751769888 + 48.8972974659844Fluctuatie[t] + 2.60606597104575M1[t] + 3.88662883921507M2[t] + 8.61719170738446M3[t] + 8.43525457555386M4[t] + 10.5533174437232M5[t] + 10.8463803118926M6[t] + 8.72694318006193M7[t] + 7.40716823147933M8[t] + 8.36273109964869M9[t] -4.35041145062445M10[t] -0.582348582455086M11[t] + 0.531937131830638t + 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) | 83.2959751769888 | 5.365676 | 15.5239 | 0 | 0 |
Fluctuatie | 48.8972974659844 | 4.307753 | 11.351 | 0 | 0 |
M1 | 2.60606597104575 | 6.569531 | 0.3967 | 0.692666 | 0.346333 |
M2 | 3.88662883921507 | 6.567901 | 0.5918 | 0.5557 | 0.27785 |
M3 | 8.61719170738446 | 6.56664 | 1.3123 | 0.19323 | 0.096615 |
M4 | 8.43525457555386 | 6.565749 | 1.2847 | 0.202639 | 0.101319 |
M5 | 10.5533174437232 | 6.565226 | 1.6075 | 0.111944 | 0.055972 |
M6 | 10.8463803118926 | 6.565074 | 1.6521 | 0.102477 | 0.051238 |
M7 | 8.72694318006193 | 6.56529 | 1.3293 | 0.18759 | 0.093795 |
M8 | 7.40716823147933 | 6.594648 | 1.1232 | 0.264751 | 0.132375 |
M9 | 8.36273109964869 | 6.595821 | 1.2679 | 0.208564 | 0.104282 |
M10 | -4.35041145062445 | 6.780629 | -0.6416 | 0.522994 | 0.261497 |
M11 | -0.582348582455086 | 6.780092 | -0.0859 | 0.93177 | 0.465885 |
t | 0.531937131830638 | 0.049251 | 10.8004 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.880267809888163 |
R-squared | 0.774871417125303 |
Adjusted R-squared | 0.737824941462378 |
F-TEST (value) | 20.9161979178703 |
F-TEST (DF numerator) | 13 |
F-TEST (DF denominator) | 79 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 12.6840563780077 |
Sum Squared Residuals | 12709.9376098378 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 99.5 | 86.4339782798651 | 13.0660217201349 |
2 | 101.6 | 88.2464782798655 | 13.3535217201345 |
3 | 103.9 | 93.5089782798651 | 10.3910217201349 |
4 | 106.6 | 93.8589782798652 | 12.7410217201348 |
5 | 108.3 | 96.5089782798651 | 11.7910217201349 |
6 | 102 | 97.3339782798652 | 4.66602172013478 |
7 | 93.8 | 95.7464782798651 | -1.94647827986514 |
8 | 91.6 | 94.9586404631132 | -3.35864046311321 |
9 | 97.7 | 96.4461404631132 | 1.25385953688681 |
10 | 94.8 | 84.2649350446707 | 10.5350649553293 |
11 | 98 | 88.5649350446707 | 9.43506495532929 |
12 | 103.8 | 89.6792207589564 | 14.1207792410436 |
13 | 97.8 | 92.8172238618328 | 4.98277613816715 |
14 | 91.2 | 94.6297238618328 | -3.42972386183278 |
15 | 89.3 | 99.8922238618328 | -10.5922238618328 |
16 | 87.5 | 100.242223861833 | -12.7422238618328 |
17 | 90.4 | 102.892223861833 | -12.4922238618328 |
18 | 94.2 | 103.717223861833 | -9.51722386183282 |
19 | 102.2 | 102.129723861833 | 0.0702761381671688 |
20 | 101.3 | 101.341886045081 | -0.0418860450808649 |
21 | 96 | 102.829386045081 | -6.82938604508087 |
22 | 90.8 | 90.6481806266384 | 0.151819373361632 |
23 | 93.2 | 94.9481806266384 | -1.74818062663837 |
24 | 90.9 | 96.062466340924 | -5.16246634092409 |
25 | 91.1 | 99.2004694438005 | -8.1004694438005 |
26 | 90.2 | 101.012969443800 | -10.8129694438004 |
27 | 94.3 | 106.275469443800 | -11.9754694438005 |
28 | 96 | 106.625469443800 | -10.6254694438005 |
29 | 99 | 109.275469443800 | -10.2754694438005 |
30 | 103.3 | 110.100469443800 | -6.80046944380048 |
31 | 113.1 | 108.512969443800 | 4.5870305561995 |
32 | 112.8 | 107.725131627049 | 5.07486837295148 |
33 | 112.1 | 109.212631627049 | 2.88736837295148 |
34 | 107.4 | 97.031426208606 | 10.3685737913940 |
35 | 111 | 101.331426208606 | 9.66857379139398 |
36 | 110.5 | 102.445711922892 | 8.05428807710826 |
37 | 110.8 | 105.583715025768 | 5.21628497423185 |
38 | 112.4 | 107.396215025768 | 5.00378497423192 |
39 | 111.5 | 112.658715025768 | -1.15871502576813 |
40 | 116.2 | 113.008715025768 | 3.19128497423186 |
41 | 122.5 | 115.658715025768 | 6.84128497423186 |
42 | 121.3 | 116.483715025768 | 4.81628497423186 |
43 | 113.9 | 114.896215025768 | -0.996215025768139 |
44 | 110.7 | 114.108377209016 | -3.40837720901617 |
45 | 120.8 | 115.595877209016 | 5.20412279098383 |
46 | 141.1 | 152.311969256558 | -11.2119692565580 |
47 | 147.4 | 156.611969256558 | -9.21196925655796 |
48 | 148 | 157.726254970844 | -9.72625497084368 |
49 | 158.1 | 160.86425807372 | -2.76425807372009 |
50 | 165 | 162.67675807372 | 2.32324192627998 |
51 | 187 | 167.93925807372 | 19.0607419262799 |
52 | 190.3 | 168.28925807372 | 22.0107419262799 |
53 | 182.4 | 170.93925807372 | 11.4607419262799 |
54 | 168.8 | 171.76425807372 | -2.96425807372007 |
55 | 151.2 | 170.17675807372 | -18.9767580737201 |
56 | 120.1 | 120.491622790984 | -0.391622790983825 |
57 | 112.5 | 121.979122790984 | -9.47912279098382 |
58 | 106.2 | 109.797917372541 | -3.59791737254132 |
59 | 107.1 | 114.097917372541 | -6.99791737254134 |
60 | 108.5 | 115.212203086827 | -6.71220308682705 |
61 | 106.5 | 118.350206189703 | -11.8502061897035 |
62 | 108.3 | 120.162706189703 | -11.8627061897034 |
63 | 125.6 | 125.425206189703 | 0.174793810296551 |
64 | 124 | 125.775206189703 | -1.77520618970345 |
65 | 127.2 | 128.425206189703 | -1.22520618970344 |
66 | 136.9 | 129.250206189703 | 7.64979381029656 |
67 | 135.8 | 127.662706189703 | 8.13729381029656 |
68 | 124.3 | 126.874868372951 | -2.57486837295148 |
69 | 115.4 | 128.362368372951 | -12.9623683729515 |
70 | 113.6 | 116.181162954509 | -2.58116295450898 |
71 | 114.4 | 120.481162954509 | -6.08116295450897 |
72 | 118.4 | 121.595448668795 | -3.19544866879469 |
73 | 117 | 124.733451771671 | -7.73345177167111 |
74 | 116.5 | 126.545951771671 | -10.0459517716710 |
75 | 115.4 | 131.808451771671 | -16.4084517716711 |
76 | 113.6 | 132.158451771671 | -18.5584517716711 |
77 | 117.4 | 134.808451771671 | -17.4084517716711 |
78 | 116.9 | 135.633451771671 | -18.7334517716711 |
79 | 116.4 | 134.045951771671 | -17.6459517716711 |
80 | 111.1 | 133.258113954919 | -22.1581139549191 |
81 | 110.2 | 134.745613954919 | -24.5456139549191 |
82 | 118.9 | 122.564408536477 | -3.66440853647663 |
83 | 131.8 | 126.864408536477 | 4.93559146352338 |
84 | 130.6 | 127.978694250762 | 2.62130574923764 |
85 | 138.3 | 131.116697353639 | 7.18330264636125 |
86 | 148.4 | 132.929197353639 | 15.4708026463613 |
87 | 148.7 | 138.191697353639 | 10.5083026463612 |
88 | 144.3 | 138.541697353639 | 5.75830264636125 |
89 | 152.5 | 141.191697353639 | 11.3083026463612 |
90 | 162.9 | 142.016697353639 | 20.8833026463613 |
91 | 167.2 | 140.429197353639 | 26.7708026463612 |
92 | 166.5 | 139.641359536887 | 26.8586404631132 |
93 | 185.6 | 141.128859536887 | 44.4711404631132 |