Multiple Linear Regression - Estimated Regression Equation |
y[t] = + 12815.4593063584 -1141.77225433526x[t] + 414.909267822725M1[t] + 777.13304431599M2[t] + 2687.02348747591M3[t] + 1102.1805973025M4[t] + 1334.13770712909M5[t] + 1352.31734104046M6[t] + 676.551117533716M7[t] -1760.43510597303M8[t] + 1811.53867052023M9[t] + 2418.23244701349M10[t] + 1164.36622350674M11[t] + 65.9262235067438t + 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) | 12815.4593063584 | 373.439499 | 34.3174 | 0 | 0 |
x | -1141.77225433526 | 346.35093 | -3.2966 | 0.001786 | 0.000893 |
M1 | 414.909267822725 | 444.426373 | 0.9336 | 0.354918 | 0.177459 |
M2 | 777.13304431599 | 443.227498 | 1.7534 | 0.085551 | 0.042775 |
M3 | 2687.02348747591 | 442.205619 | 6.0764 | 0 | 0 |
M4 | 1102.1805973025 | 441.361967 | 2.4972 | 0.015786 | 0.007893 |
M5 | 1334.13770712909 | 440.697564 | 3.0273 | 0.003863 | 0.001931 |
M6 | 1352.31734104046 | 462.268303 | 2.9254 | 0.005124 | 0.002562 |
M7 | 676.551117533716 | 461.319182 | 1.4666 | 0.148636 | 0.074318 |
M8 | -1760.43510597303 | 460.541174 | -3.8225 | 0.000361 | 0.00018 |
M9 | 1811.53867052023 | 459.935146 | 3.9387 | 0.00025 | 0.000125 |
M10 | 2418.23244701349 | 459.50178 | 5.2627 | 3e-06 | 1e-06 |
M11 | 1164.36622350674 | 459.241564 | 2.5354 | 0.01434 | 0.00717 |
t | 65.9262235067438 | 8.926957 | 7.3851 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.906748503016145 |
R-squared | 0.82219284772202 |
Adjusted R-squared | 0.776869455964888 |
F-TEST (value) | 18.1405851558459 |
F-TEST (DF numerator) | 13 |
F-TEST (DF denominator) | 51 |
p-value | 9.65894031423886e-15 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 725.987471786154 |
Sum Squared Residuals | 26879948.2687130 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 12398.4 | 13296.2947976879 | -897.894797687909 |
2 | 13882.3 | 13724.4447976879 | 157.85520231214 |
3 | 15861.5 | 15700.2614643545 | 161.238535645470 |
4 | 13286.1 | 14181.3447976879 | -895.244797687861 |
5 | 15634.9 | 14479.2281310212 | 1155.67186897881 |
6 | 14211 | 14563.3339884393 | -352.333988439303 |
7 | 13646.8 | 13953.4939884393 | -306.693988439302 |
8 | 12224.6 | 11582.4339884393 | 642.166011560695 |
9 | 15916.4 | 15220.3339884393 | 696.066011560696 |
10 | 16535.9 | 15892.9539884393 | 642.946011560698 |
11 | 15796 | 14705.0139884393 | 1090.98601156070 |
12 | 14418.6 | 13606.5739884393 | 812.026011560695 |
13 | 15044.5 | 14087.4094797688 | 957.090520231225 |
14 | 14944.2 | 14515.5594797688 | 428.640520231217 |
15 | 16754.8 | 16491.3761464355 | 263.423853564549 |
16 | 14254 | 14972.4594797688 | -718.459479768784 |
17 | 15454.9 | 15270.3428131021 | 184.557186897881 |
18 | 15644.8 | 15354.4486705202 | 290.351329479769 |
19 | 14568.3 | 14744.6086705202 | -176.308670520231 |
20 | 12520.2 | 12373.5486705202 | 146.651329479771 |
21 | 14803 | 16011.4486705202 | -1208.44867052023 |
22 | 15873.2 | 16684.0686705202 | -810.86867052023 |
23 | 14755.3 | 15496.1286705202 | -740.82867052023 |
24 | 12875.1 | 14397.6886705202 | -1522.58867052023 |
25 | 14291.1 | 13736.7519075144 | 554.34809248556 |
26 | 14205.3 | 14164.9019075144 | 40.3980924855489 |
27 | 15859.4 | 16140.7185741811 | -281.318574181116 |
28 | 15258.9 | 14621.8019075145 | 637.098092485549 |
29 | 15498.6 | 14919.6852408478 | 578.914759152215 |
30 | 14106.5 | 15003.7910982659 | -897.291098265896 |
31 | 15023.6 | 14393.9510982659 | 629.648901734103 |
32 | 12083 | 12022.8910982659 | 60.1089017341033 |
33 | 15761.3 | 15660.7910982659 | 100.508901734103 |
34 | 16943 | 16333.4110982659 | 609.588901734103 |
35 | 15070.3 | 15145.4710982659 | -75.1710982658971 |
36 | 13659.6 | 14047.0310982659 | -387.431098265898 |
37 | 14768.9 | 14527.8665895954 | 241.033410404633 |
38 | 14725.1 | 14956.0165895954 | -230.916589595376 |
39 | 15998.1 | 16931.8332562620 | -933.733256262041 |
40 | 15370.6 | 15412.9165895954 | -42.3165895953756 |
41 | 14956.9 | 15710.7999229287 | -753.899922928711 |
42 | 15469.7 | 15794.9057803468 | -325.205780346821 |
43 | 15101.8 | 15185.0657803468 | -83.2657803468231 |
44 | 11703.7 | 12814.0057803468 | -1110.30578034682 |
45 | 16283.6 | 16451.9057803468 | -168.305780346821 |
46 | 16726.5 | 17124.5257803468 | -398.025780346822 |
47 | 14968.9 | 15936.5857803468 | -967.685780346822 |
48 | 14861 | 14838.1457803468 | 22.8542196531758 |
49 | 14583.3 | 15318.9812716763 | -735.681271676292 |
50 | 15305.8 | 15747.1312716763 | -441.331271676302 |
51 | 17903.9 | 17722.9479383430 | 180.952061657034 |
52 | 16379.4 | 16204.0312716763 | 175.368728323698 |
53 | 15420.3 | 16501.9146050096 | -1081.61460500964 |
54 | 17870.5 | 16586.0204624277 | 1284.47953757225 |
55 | 15912.8 | 15976.1804624277 | -63.3804624277486 |
56 | 13866.5 | 13605.1204624277 | 261.379537572253 |
57 | 17823.2 | 17243.0204624277 | 580.179537572254 |
58 | 17872 | 17915.6404624277 | -43.6404624277479 |
59 | 17420.4 | 16727.7004624277 | 692.699537572254 |
60 | 16704.4 | 15629.2604624277 | 1075.13953757225 |
61 | 15991.2 | 16110.0959537572 | -118.895953757216 |
62 | 16583.6 | 16538.2459537572 | 45.3540462427719 |
63 | 19123.5 | 18514.0626204239 | 609.437379576107 |
64 | 17838.7 | 16995.1459537572 | 843.554046242774 |
65 | 17209.4 | 17293.0292870906 | -83.6292870905593 |