Multiple Linear Regression - Estimated Regression Equation |
y[t] = + 264643732867.133 + 4944951048.95103x[t] -1359158508.15855M1[t] -3916789743.58974M2[t] + 242769230.769234M3[t] + 610128205.128208M4[t] + 2812487179.48718M5[t] -721153846.153844M6[t] + 248605128.20513M7[t] + 610764102.564104M8[t] + 1687923076.92308M9[t] + 2158882051.28205M10[t] + 3198041025.64103M11[t] + 172841025.641026t + 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) | 264643732867.133 | 1319786946.08101 | 200.52 | 0 | 0 |
x | 4944951048.95103 | 1102377214.50293 | 4.4857 | 4.8e-05 | 2.4e-05 |
M1 | -1359158508.15855 | 1535855108.89393 | -0.885 | 0.380785 | 0.190392 |
M2 | -3916789743.58974 | 1542379997.98633 | -2.5394 | 0.014547 | 0.007274 |
M3 | 242769230.769234 | 1538563462.872 | 0.1578 | 0.875313 | 0.437657 |
M4 | 610128205.128208 | 1535140625.56680 | 0.3974 | 0.69288 | 0.34644 |
M5 | 2812487179.48718 | 1532114124.70846 | 1.8357 | 0.072873 | 0.036436 |
M6 | -721153846.153844 | 1529486313.07421 | -0.4715 | 0.639512 | 0.319756 |
M7 | 248605128.20513 | 1527259248.62679 | 0.1628 | 0.871406 | 0.435703 |
M8 | 610764102.564104 | 1525434686.58458 | 0.4004 | 0.690725 | 0.345363 |
M9 | 1687923076.92308 | 1524014072.58572 | 1.1076 | 0.273814 | 0.136907 |
M10 | 2158882051.28205 | 1522998537.00778 | 1.4175 | 0.163069 | 0.081535 |
M11 | 3198041025.64103 | 1522388890.49446 | 2.1007 | 0.04118 | 0.02059 |
t | 172841025.641026 | 24877096.741715 | 6.9478 | 0 | 0 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.922582492100483 |
R-squared | 0.851158454730338 |
Adjusted R-squared | 0.809094539762825 |
F-TEST (value) | 20.2348843512950 |
F-TEST (DF numerator) | 13 |
F-TEST (DF denominator) | 46 |
p-value | 8.88178419700125e-15 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 2406786791.53277 |
Sum Squared Residuals | 2.66460642355245e+20 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 2.63418e+11 | 263457415384.616 | -39415384.6155328 |
2 | 2.62752e+11 | 261072625174.825 | 1679374825.17483 |
3 | 2.66433e+11 | 265405025174.825 | 1027974825.17483 |
4 | 2.67722e+11 | 265945225174.825 | 1776774825.17483 |
5 | 2.66003e+11 | 268320425174.825 | -2317425174.82516 |
6 | 2.62971e+11 | 264959625174.825 | -1988625174.82516 |
7 | 2.65521e+11 | 266102225174.825 | -581225174.825165 |
8 | 2.64676e+11 | 266637225174.825 | -1961225174.82517 |
9 | 2.70223e+11 | 267887225174.825 | 2335774825.17483 |
10 | 2.69508e+11 | 268531025174.825 | 976974825.174835 |
11 | 2.68457e+11 | 269743025174.825 | -1286025174.82517 |
12 | 2.65814e+11 | 266717825174.825 | -903825174.825165 |
13 | 2.6668e+11 | 265531507692.308 | 1148492307.69235 |
14 | 2.63018e+11 | 263146717482.517 | -128717482.517479 |
15 | 2.69285e+11 | 267479117482.517 | 1805882517.48252 |
16 | 2.69829e+11 | 268019317482.517 | 1809682517.48252 |
17 | 2.70911e+11 | 270394517482.517 | 516482517.482521 |
18 | 2.66844e+11 | 267033717482.517 | -189717482.51748 |
19 | 2.71244e+11 | 268176317482.517 | 3067682517.48252 |
20 | 2.69907e+11 | 268711317482.517 | 1195682517.48252 |
21 | 2.71296e+11 | 269961317482.517 | 1334682517.48252 |
22 | 2.70157e+11 | 270605117482.517 | -448117482.517479 |
23 | 2.71322e+11 | 271817117482.517 | -495117482.51748 |
24 | 2.67179e+11 | 268791917482.517 | -1612917482.51748 |
25 | 2.64101e+11 | 267605600000 | -3504599999.99996 |
26 | 2.65518e+11 | 265220809790.21 | 297190209.790207 |
27 | 2.69419e+11 | 269553209790.21 | -134209790.209793 |
28 | 2.68714e+11 | 270093409790.21 | -1379409790.20979 |
29 | 2.72482e+11 | 272468609790.21 | 13390209.7902062 |
30 | 2.68351e+11 | 269107809790.21 | -756809790.209793 |
31 | 2.68175e+11 | 270250409790.21 | -2075409790.20979 |
32 | 2.70674e+11 | 270785409790.21 | -111409790.209793 |
33 | 2.72764e+11 | 272035409790.21 | 728590209.790206 |
34 | 2.72599e+11 | 272679209790.21 | -80209790.2097939 |
35 | 2.70333e+11 | 273891209790.21 | -3558209790.20979 |
36 | 2.70846e+11 | 270866009790.21 | -20009790.2097929 |
37 | 2.70491e+11 | 269679692307.692 | 811307692.307727 |
38 | 2.6916e+11 | 267294902097.902 | 1865097902.09789 |
39 | 2.74027e+11 | 271627302097.902 | 2399697902.09789 |
40 | 2.73784e+11 | 272167502097.902 | 1616497902.09789 |
41 | 2.76663e+11 | 274542702097.902 | 2120297902.09789 |
42 | 2.74525e+11 | 271181902097.902 | 3343097902.09789 |
43 | 2.71344e+11 | 272324502097.902 | -980502097.902108 |
44 | 2.71115e+11 | 272859502097.902 | -1744502097.90211 |
45 | 2.70798e+11 | 274109502097.902 | -3311502097.90211 |
46 | 2.73911e+11 | 274753302097.902 | -842302097.902106 |
47 | 2.73985e+11 | 275965302097.902 | -1980302097.90211 |
48 | 2.71917e+11 | 272940102097.902 | -1023102097.90211 |
49 | 2.73338e+11 | 271753784615.385 | 1584215384.61541 |
50 | 2.70601e+11 | 274313945454.545 | -3712945454.54545 |
51 | 2.73547e+11 | 278646345454.545 | -5099345454.54545 |
52 | 2.75363e+11 | 279186545454.545 | -3823545454.54545 |
53 | 2.81229e+11 | 281561745454.545 | -332745454.545455 |
54 | 2.77793e+11 | 278200945454.545 | -407945454.545455 |
55 | 2.79913e+11 | 279343545454.545 | 569454545.454545 |
56 | 2.825e+11 | 279878545454.545 | 2621454545.45455 |
57 | 2.80041e+11 | 281128545454.545 | -1087545454.54545 |
58 | 2.82166e+11 | 281772345454.545 | 393654545.454546 |
59 | 2.90304e+11 | 282984345454.545 | 7319654545.45454 |
60 | 2.83519e+11 | 279959145454.545 | 3559854545.45455 |