Multiple Linear Regression - Estimated Regression Equation |
Y[t] = + 84.2627133872417 + 32.0095387840671X[t] + 7.15367157082959M1[t] + 8.04018231506439M2[t] + 7.26419305929919M3[t] + 4.92570380353399M4[t] + 4.19971454776879M5[t] + 1.96122529200359M6[t] + 2.71023603623839M7[t] + 1.20924678047320M8[t] + 1.80825752470799M9[t] -4.85159291704103M10[t] -3.52579645852052M11[t] + 0.388489255765199t + 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) | 84.2627133872417 | 4.286489 | 19.6577 | 0 | 0 |
X | 32.0095387840671 | 3.918467 | 8.1689 | 0 | 0 |
M1 | 7.15367157082959 | 5.051943 | 1.416 | 0.160699 | 0.08035 |
M2 | 8.04018231506439 | 5.049927 | 1.5921 | 0.115347 | 0.057674 |
M3 | 7.26419305929919 | 5.048917 | 1.4388 | 0.154168 | 0.077084 |
M4 | 4.92570380353399 | 5.048914 | 0.9756 | 0.332242 | 0.166121 |
M5 | 4.19971454776879 | 5.049916 | 0.8316 | 0.408119 | 0.204059 |
M6 | 1.96122529200359 | 5.051925 | 0.3882 | 0.698902 | 0.349451 |
M7 | 2.71023603623839 | 5.054938 | 0.5362 | 0.593357 | 0.296679 |
M8 | 1.20924678047320 | 5.058954 | 0.239 | 0.811701 | 0.40585 |
M9 | 1.80825752470799 | 5.06397 | 0.3571 | 0.721982 | 0.360991 |
M10 | -4.85159291704103 | 5.215048 | -0.9303 | 0.355047 | 0.177523 |
M11 | -3.52579645852052 | 5.213587 | -0.6763 | 0.500844 | 0.250422 |
t | 0.388489255765199 | 0.071286 | 5.4498 | 1e-06 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.941724895594095 |
R-squared | 0.886845778981708 |
Adjusted R-squared | 0.868225464130597 |
F-TEST (value) | 47.6278616163561 |
F-TEST (DF numerator) | 13 |
F-TEST (DF denominator) | 79 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 9.75281567270224 |
Sum Squared Residuals | 7514.27567011082 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 112.1 | 91.8048742138364 | 20.2951257861636 |
2 | 104.2 | 93.0798742138365 | 11.1201257861635 |
3 | 102.4 | 92.6923742138365 | 9.70762578616353 |
4 | 100.3 | 90.7423742138365 | 9.55762578616352 |
5 | 102.6 | 90.4048742138365 | 12.1951257861635 |
6 | 101.5 | 88.5548742138365 | 12.9451257861635 |
7 | 103.4 | 89.6923742138365 | 13.7076257861635 |
8 | 99.4 | 88.5798742138365 | 10.8201257861635 |
9 | 97.9 | 89.5673742138365 | 8.33262578616353 |
10 | 98 | 83.2960130278527 | 14.7039869721473 |
11 | 90.2 | 85.0102987421384 | 5.18970125786163 |
12 | 87.1 | 88.924584456424 | -1.82458445642409 |
13 | 91.8 | 96.4667452830189 | -4.66674528301887 |
14 | 94.8 | 97.7417452830189 | -2.94174528301886 |
15 | 91.8 | 97.3542452830189 | -5.55424528301887 |
16 | 89.3 | 95.4042452830189 | -6.10424528301887 |
17 | 91.7 | 95.0667452830189 | -3.36674528301887 |
18 | 86.2 | 93.2167452830189 | -7.01674528301887 |
19 | 82.8 | 94.3542452830189 | -11.5542452830189 |
20 | 82.3 | 93.2417452830189 | -10.9417452830189 |
21 | 79.8 | 94.2292452830189 | -14.4292452830189 |
22 | 79.4 | 87.957884097035 | -8.55788409703503 |
23 | 85.3 | 89.6721698113208 | -4.37216981132076 |
24 | 87.5 | 93.5864555256065 | -6.08645552560647 |
25 | 88.3 | 101.128616352201 | -12.8286163522013 |
26 | 88.6 | 102.403616352201 | -13.8036163522013 |
27 | 94.9 | 102.016116352201 | -7.11611635220125 |
28 | 94.7 | 100.066116352201 | -5.36611635220125 |
29 | 92.6 | 99.7286163522013 | -7.12861635220126 |
30 | 91.8 | 97.8786163522013 | -6.07861635220126 |
31 | 96.4 | 99.0161163522013 | -2.61611635220125 |
32 | 96.4 | 97.9036163522013 | -1.50361635220126 |
33 | 107.1 | 98.8911163522013 | 8.20888364779874 |
34 | 111.9 | 92.6197551662174 | 19.2802448337826 |
35 | 107.8 | 94.3340408805032 | 13.4659591194969 |
36 | 109.2 | 98.2483265947889 | 10.9516734052111 |
37 | 115.3 | 105.790487421384 | 9.50951257861635 |
38 | 119.2 | 107.065487421384 | 12.1345125786164 |
39 | 107.8 | 106.677987421384 | 1.12201257861635 |
40 | 106.8 | 104.727987421384 | 2.07201257861635 |
41 | 104.2 | 104.390487421384 | -0.190487421383643 |
42 | 94.8 | 102.540487421384 | -7.74048742138365 |
43 | 97.5 | 103.677987421384 | -6.17798742138365 |
44 | 98.3 | 102.565487421384 | -4.26548742138366 |
45 | 100.6 | 103.552987421384 | -2.95298742138365 |
46 | 94.9 | 97.2816262353998 | -2.38162623539982 |
47 | 93.6 | 98.9959119496855 | -5.39591194968554 |
48 | 98 | 102.910197663971 | -4.91019766397125 |
49 | 104.3 | 110.452358490566 | -6.15235849056604 |
50 | 103.9 | 111.727358490566 | -7.82735849056604 |
51 | 105.3 | 111.339858490566 | -6.03985849056604 |
52 | 102.6 | 109.389858490566 | -6.78985849056604 |
53 | 103.3 | 109.052358490566 | -5.75235849056604 |
54 | 107.9 | 107.202358490566 | 0.697641509433967 |
55 | 107.8 | 108.339858490566 | -0.539858490566037 |
56 | 109.8 | 107.227358490566 | 2.57264150943397 |
57 | 110.6 | 108.214858490566 | 2.38514150943396 |
58 | 110.8 | 133.953036088649 | -23.1530360886493 |
59 | 119.3 | 135.667321802935 | -16.367321802935 |
60 | 128.1 | 139.581607517221 | -11.4816075172207 |
61 | 127.6 | 147.123768343816 | -19.5237683438155 |
62 | 137.9 | 148.398768343816 | -10.4987683438155 |
63 | 151.4 | 148.011268343816 | 3.38873165618449 |
64 | 143.6 | 146.061268343816 | -2.46126834381552 |
65 | 143.4 | 145.723768343816 | -2.32376834381551 |
66 | 141.9 | 143.873768343816 | -1.97376834381551 |
67 | 135.2 | 145.011268343816 | -9.81126834381553 |
68 | 133.1 | 143.898768343816 | -10.7987683438155 |
69 | 129.6 | 144.886268343816 | -15.2862683438155 |
70 | 134.1 | 138.614907157832 | -4.51490715783169 |
71 | 136.8 | 140.329192872117 | -3.52919287211739 |
72 | 143.5 | 144.243478586403 | -0.74347858640312 |
73 | 162.5 | 151.785639412998 | 10.7143605870021 |
74 | 163.1 | 153.060639412998 | 10.0393605870021 |
75 | 157.2 | 152.673139412998 | 4.52686058700209 |
76 | 158.8 | 150.723139412998 | 8.07686058700211 |
77 | 155.4 | 150.385639412998 | 5.0143605870021 |
78 | 148.5 | 148.535639412998 | -0.0356394129979061 |
79 | 154.2 | 149.673139412998 | 4.52686058700209 |
80 | 153.3 | 148.560639412998 | 4.73936058700211 |
81 | 149.4 | 149.548139412998 | -0.148139412997894 |
82 | 147.9 | 143.276778227014 | 4.62322177298593 |
83 | 156 | 144.991063941300 | 11.0089360587002 |
84 | 163 | 148.905349655585 | 14.0946503444145 |
85 | 159.1 | 156.447510482180 | 2.6524895178197 |
86 | 159.5 | 157.722510482180 | 1.77748951781971 |
87 | 157.3 | 157.335010482180 | -0.0350104821802833 |
88 | 156.4 | 155.385010482180 | 1.01498951781971 |
89 | 156.6 | 155.047510482180 | 1.55248951781970 |
90 | 162.4 | 153.197510482180 | 9.20248951781971 |
91 | 166.8 | 154.335010482180 | 12.4649895178197 |
92 | 162.6 | 153.222510482180 | 9.3774895178197 |
93 | 168.1 | 154.210010482180 | 13.8899895178197 |