Multiple Linear Regression - Estimated Regression Equation |
Suiker[t] = + 136.236829836830 -2.9437393162393`9/11`[t] + 2.72223727661227M1[t] + 5.64754370629367M2[t] + 5.06451680264176M3[t] + 3.57315656565654M4[t] + 6.27346299533796M5[t] + 2.69043609168607M6[t] + 0.107409188034164M7[t] -0.492284382284406M8[t] -0.516977952602984M9[t] -5.56974067599071M10[t] -3.46470036907539M11[t] -0.0919730963480966t + 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) | 136.236829836830 | 11.13662 | 12.2332 | 0 | 0 |
`9/11` | -2.9437393162393 | 10.96146 | -0.2686 | 0.788709 | 0.394354 |
M1 | 2.72223727661227 | 13.487038 | 0.2018 | 0.840364 | 0.420182 |
M2 | 5.64754370629367 | 13.485301 | 0.4188 | 0.676075 | 0.338038 |
M3 | 5.06451680264176 | 13.484909 | 0.3756 | 0.707864 | 0.353932 |
M4 | 3.57315656565654 | 13.485864 | 0.265 | 0.791473 | 0.395737 |
M5 | 6.27346299533796 | 13.488165 | 0.4651 | 0.64265 | 0.321325 |
M6 | 2.69043609168607 | 13.491811 | 0.1994 | 0.842259 | 0.421129 |
M7 | 0.107409188034164 | 13.496801 | 0.008 | 0.993663 | 0.496831 |
M8 | -0.492284382284406 | 13.503134 | -0.0365 | 0.970975 | 0.485488 |
M9 | -0.516977952602984 | 13.510808 | -0.0383 | 0.969537 | 0.484769 |
M10 | -5.56974067599071 | 13.794337 | -0.4038 | 0.687061 | 0.34353 |
M11 | -3.46470036907539 | 13.773249 | -0.2516 | 0.801793 | 0.400897 |
t | -0.0919730963480966 | 0.134738 | -0.6826 | 0.4961 | 0.24805 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.197719735252443 |
R-squared | 0.0390930937082961 |
Adjusted R-squared | -0.0592674557546342 |
F-TEST (value) | 0.397446882126551 |
F-TEST (DF numerator) | 13 |
F-TEST (DF denominator) | 127 |
p-value | 0.968475030801442 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 32.2995854276903 |
Sum Squared Residuals | 132494.428787685 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 145.9 | 138.867094017094 | 7.03290598290635 |
2 | 158.5 | 141.700427350427 | 16.7995726495726 |
3 | 152.2 | 141.025427350427 | 11.1745726495726 |
4 | 153.7 | 139.442094017094 | 14.257905982906 |
5 | 157.9 | 142.050427350427 | 15.8495726495727 |
6 | 154.4 | 138.375427350427 | 16.0245726495726 |
7 | 150.7 | 135.700427350427 | 14.9995726495727 |
8 | 151.2 | 135.008760683761 | 16.1912393162393 |
9 | 147.3 | 134.892094017094 | 12.407905982906 |
10 | 146.6 | 129.747358197358 | 16.8526418026418 |
11 | 145.2 | 131.760425407925 | 13.4395745920746 |
12 | 139.3 | 135.133152680653 | 4.16684731934731 |
13 | 145.7 | 137.763416860917 | 7.93658313908312 |
14 | 163.3 | 140.596750194250 | 22.7032498057498 |
15 | 181.8 | 139.921750194250 | 41.8782498057498 |
16 | 188.1 | 138.338416860917 | 49.7615831390831 |
17 | 222.9 | 140.946750194250 | 81.9532498057498 |
18 | 206.3 | 137.271750194250 | 69.0282498057498 |
19 | 184.9 | 134.596750194250 | 50.3032498057498 |
20 | 183.6 | 133.905083527584 | 49.6949164724165 |
21 | 186.6 | 133.788416860917 | 52.8115831390831 |
22 | 176.5 | 128.643681041181 | 47.856318958819 |
23 | 173.9 | 130.656748251748 | 43.2432517482518 |
24 | 184.9 | 134.029475524476 | 50.8705244755245 |
25 | 182.5 | 136.659739704740 | 45.8402602952603 |
26 | 183.6 | 139.493073038073 | 44.106926961927 |
27 | 172.4 | 138.818073038073 | 33.5819269619270 |
28 | 168.9 | 137.234739704740 | 31.6652602952603 |
29 | 163.3 | 139.843073038073 | 23.4569269619270 |
30 | 152.4 | 136.168073038073 | 16.2319269619270 |
31 | 145.8 | 133.493073038073 | 12.3069269619270 |
32 | 148.6 | 132.801406371406 | 15.7985936285936 |
33 | 143.4 | 132.684739704740 | 10.7152602952603 |
34 | 141.2 | 127.540003885004 | 13.6599961149961 |
35 | 144.6 | 129.553071095571 | 15.0469289044289 |
36 | 144.5 | 132.925798368298 | 11.5742016317016 |
37 | 140.8 | 135.556062548563 | 5.24393745143744 |
38 | 133.3 | 138.389395881896 | -5.08939588189587 |
39 | 127.3 | 137.714395881896 | -10.4143958818959 |
40 | 119.6 | 136.131062548563 | -16.5310625485626 |
41 | 120.2 | 138.739395881896 | -18.5393958818959 |
42 | 121.9 | 135.064395881896 | -13.1643958818959 |
43 | 112.4 | 132.389395881896 | -19.9893958818959 |
44 | 111 | 131.697729215229 | -20.6977292152292 |
45 | 107.8 | 131.581062548563 | -23.7810625485625 |
46 | 110.5 | 126.436326728827 | -15.9363267288267 |
47 | 118.3 | 128.449393939394 | -10.1493939393939 |
48 | 123 | 131.822121212121 | -8.82212121212123 |
49 | 112.1 | 134.452385392385 | -22.3523853923854 |
50 | 104.2 | 137.285718725719 | -33.0857187257187 |
51 | 102.4 | 136.610718725719 | -34.2107187257187 |
52 | 100.3 | 135.027385392385 | -34.7273853923854 |
53 | 102.6 | 137.635718725719 | -35.0357187257187 |
54 | 101.5 | 133.960718725719 | -32.4607187257187 |
55 | 103.4 | 131.285718725719 | -27.8857187257187 |
56 | 99.4 | 130.594052059052 | -31.1940520590521 |
57 | 97.9 | 130.477385392385 | -32.5773853923854 |
58 | 98 | 125.332649572650 | -27.3326495726496 |
59 | 90.2 | 127.345716783217 | -37.1457167832168 |
60 | 87.1 | 130.718444055944 | -43.6184440559441 |
61 | 91.8 | 133.348708236208 | -41.5487082362082 |
62 | 94.8 | 136.182041569542 | -41.3820415695416 |
63 | 91.8 | 135.507041569542 | -43.7070415695416 |
64 | 89.3 | 133.923708236208 | -44.6237082362082 |
65 | 91.7 | 136.532041569542 | -44.8320415695416 |
66 | 86.2 | 132.857041569542 | -46.6570415695416 |
67 | 82.8 | 130.182041569542 | -47.3820415695416 |
68 | 82.3 | 129.490374902875 | -47.1903749028749 |
69 | 79.8 | 129.373708236208 | -49.5737082362082 |
70 | 79.4 | 124.228972416472 | -44.8289724164724 |
71 | 85.3 | 123.298300310800 | -37.9983003108003 |
72 | 87.5 | 126.671027583528 | -39.1710275835276 |
73 | 88.3 | 129.301291763792 | -41.0012917637918 |
74 | 88.6 | 132.134625097125 | -43.5346250971251 |
75 | 94.9 | 131.459625097125 | -36.5596250971251 |
76 | 94.7 | 129.876291763792 | -35.1762917637918 |
77 | 92.6 | 132.484625097125 | -39.8846250971251 |
78 | 91.8 | 128.809625097125 | -37.0096250971251 |
79 | 96.4 | 126.134625097125 | -29.7346250971251 |
80 | 96.4 | 125.442958430458 | -29.0429584304584 |
81 | 107.1 | 125.326291763792 | -18.2262917637918 |
82 | 111.9 | 120.181555944056 | -8.28155594405593 |
83 | 107.8 | 122.194623154623 | -14.3946231546232 |
84 | 109.2 | 125.567350427350 | -16.3673504273504 |
85 | 115.3 | 128.197614607615 | -12.8976146076146 |
86 | 119.2 | 131.030947940948 | -11.8309479409479 |
87 | 107.8 | 130.355947940948 | -22.5559479409479 |
88 | 106.8 | 128.772614607615 | -21.9726146076146 |
89 | 104.2 | 131.380947940948 | -27.1809479409479 |
90 | 94.8 | 127.705947940948 | -32.9059479409479 |
91 | 97.5 | 125.030947940948 | -27.5309479409479 |
92 | 98.3 | 124.339281274281 | -26.0392812742813 |
93 | 100.6 | 124.222614607615 | -23.6226146076146 |
94 | 94.9 | 119.077878787879 | -24.1778787878788 |
95 | 93.6 | 121.090945998446 | -27.490945998446 |
96 | 98 | 124.463673271173 | -26.4636732711733 |
97 | 104.3 | 127.093937451437 | -22.7939374514375 |
98 | 103.9 | 129.927270784771 | -26.0272707847708 |
99 | 105.3 | 129.252270784771 | -23.9522707847708 |
100 | 102.6 | 127.668937451437 | -25.0689374514374 |
101 | 103.3 | 130.277270784771 | -26.9772707847708 |
102 | 107.9 | 126.602270784771 | -18.7022707847708 |
103 | 107.8 | 123.927270784771 | -16.1272707847708 |
104 | 109.8 | 123.235604118104 | -13.4356041181041 |
105 | 110.6 | 123.118937451437 | -12.5189374514374 |
106 | 110.8 | 117.974201631702 | -7.17420163170162 |
107 | 119.3 | 119.987268842269 | -0.68726884226884 |
108 | 128.1 | 123.359996114996 | 4.74000388500386 |
109 | 127.6 | 125.990260295260 | 1.60973970473969 |
110 | 137.9 | 128.823593628594 | 9.0764063714064 |
111 | 151.4 | 128.148593628594 | 23.2514063714064 |
112 | 143.6 | 126.565260295260 | 17.0347397047397 |
113 | 143.4 | 129.173593628594 | 14.2264063714064 |
114 | 141.9 | 125.498593628594 | 16.4014063714064 |
115 | 135.2 | 122.823593628594 | 12.3764063714064 |
116 | 133.1 | 122.131926961927 | 10.9680730380730 |
117 | 129.6 | 122.015260295260 | 7.58473970473971 |
118 | 134.1 | 116.870524475524 | 17.2294755244755 |
119 | 136.8 | 118.883591686092 | 17.9164083139083 |
120 | 143.5 | 122.256318958819 | 21.2436810411810 |
121 | 162.5 | 124.886583139083 | 37.6134168609168 |
122 | 163.1 | 127.719916472416 | 35.3800835275835 |
123 | 157.2 | 127.044916472416 | 30.1550835275835 |
124 | 158.8 | 125.461583139083 | 33.3384168609169 |
125 | 155.4 | 128.069916472416 | 27.3300835275835 |
126 | 148.5 | 124.394916472416 | 24.1050835275835 |
127 | 154.2 | 121.719916472416 | 32.4800835275835 |
128 | 153.3 | 121.028249805750 | 32.2717501942502 |
129 | 149.4 | 120.911583139083 | 28.4884168609169 |
130 | 147.9 | 115.766847319347 | 32.1331526806527 |
131 | 156 | 117.779914529915 | 38.2200854700855 |
132 | 163 | 121.152641802642 | 41.8473581973582 |
133 | 159.1 | 123.782905982906 | 35.317094017094 |
134 | 159.5 | 126.616239316239 | 32.8837606837607 |
135 | 157.3 | 125.941239316239 | 31.3587606837607 |
136 | 156.4 | 124.357905982906 | 32.0420940170940 |
137 | 156.6 | 126.966239316239 | 29.6337606837607 |
138 | 162.4 | 123.291239316239 | 39.1087606837607 |
139 | 166.8 | 120.616239316239 | 46.1837606837607 |
140 | 162.6 | 119.924572649573 | 42.6754273504274 |
141 | 168.1 | 119.807905982906 | 48.292094017094 |