Multiple Linear Regression - Estimated Regression Equation |
y[t] = + 578882.352941177 -14961.4379084967M1[t] -16722.8758169936M2[t] -34170.5882352942M3[t] -33818.3006535949M4[t] -32466.0130718955M5[t] -37113.7254901961M6[t] -46761.4379084968M7[t] -54409.1503267974M8[t] -62456.8627450981M9[t] -62704.5751633988M10[t] -9752.28758169938M11[t] + 647.712418300652t + 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) | 578882.352941177 | 16469.671251 | 35.1484 | 0 | 0 |
M1 | -14961.4379084967 | 19207.511251 | -0.7789 | 0.43984 | 0.21992 |
M2 | -16722.8758169936 | 20160.315253 | -0.8295 | 0.410931 | 0.205465 |
M3 | -34170.5882352942 | 20134.570309 | -1.6971 | 0.096152 | 0.048076 |
M4 | -33818.3006535949 | 20111.507424 | -1.6815 | 0.099154 | 0.049577 |
M5 | -32466.0130718955 | 20091.135834 | -1.6159 | 0.112662 | 0.056331 |
M6 | -37113.7254901961 | 20073.463733 | -1.8489 | 0.070637 | 0.035318 |
M7 | -46761.4379084968 | 20058.498256 | -2.3313 | 0.023986 | 0.011993 |
M8 | -54409.1503267974 | 20046.245465 | -2.7142 | 0.009202 | 0.004601 |
M9 | -62456.8627450981 | 20036.710336 | -3.1171 | 0.003082 | 0.001541 |
M10 | -62704.5751633988 | 20029.89675 | -3.1305 | 0.002968 | 0.001484 |
M11 | -9752.28758169938 | 20025.807486 | -0.487 | 0.628485 | 0.314242 |
t | 647.712418300652 | 233.665254 | 2.772 | 0.007907 | 0.003953 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.629253196570935 |
R-squared | 0.39595958539474 |
Adjusted R-squared | 0.244949481743425 |
F-TEST (value) | 2.62207346277318 |
F-TEST (DF numerator) | 12 |
F-TEST (DF denominator) | 48 |
p-value | 0.00894497169121755 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 31661.4262949836 |
Sum Squared Residuals | 48117403921.5686 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 523000 | 564568.62745098 | -41568.6274509798 |
2 | 519000 | 563454.901960784 | -44454.9019607844 |
3 | 509000 | 546654.901960784 | -37654.9019607843 |
4 | 512000 | 547654.901960784 | -35654.9019607842 |
5 | 519000 | 549654.901960784 | -30654.9019607843 |
6 | 517000 | 545654.901960784 | -28654.9019607843 |
7 | 510000 | 536654.901960784 | -26654.9019607844 |
8 | 509000 | 529654.901960784 | -20654.9019607843 |
9 | 501000 | 522254.901960784 | -21254.9019607845 |
10 | 507000 | 522654.901960784 | -15654.9019607844 |
11 | 569000 | 576254.901960784 | -7254.90196078425 |
12 | 580000 | 586654.901960784 | -6654.90196078437 |
13 | 578000 | 572341.176470588 | 5658.82352941166 |
14 | 565000 | 571227.450980392 | -6227.45098039218 |
15 | 547000 | 554427.450980392 | -7427.45098039216 |
16 | 555000 | 555427.450980392 | -427.450980392176 |
17 | 562000 | 557427.450980392 | 4572.54901960783 |
18 | 561000 | 553427.450980392 | 7572.54901960783 |
19 | 555000 | 544427.450980392 | 10572.5490196078 |
20 | 544000 | 537427.450980392 | 6572.54901960783 |
21 | 537000 | 530027.450980392 | 6972.54901960786 |
22 | 543000 | 530427.450980392 | 12572.5490196078 |
23 | 594000 | 584027.450980392 | 9972.54901960781 |
24 | 611000 | 594427.450980392 | 16572.5490196078 |
25 | 613000 | 580113.725490196 | 32886.2745098038 |
26 | 611000 | 579000 | 32000 |
27 | 594000 | 562200 | 31800 |
28 | 595000 | 563200 | 31800 |
29 | 591000 | 565200 | 25800 |
30 | 589000 | 561200 | 27800 |
31 | 584000 | 552200 | 31800 |
32 | 573000 | 545200 | 27800 |
33 | 567000 | 537800 | 29200 |
34 | 569000 | 538200 | 30800 |
35 | 621000 | 591800 | 29200.0000000000 |
36 | 629000 | 602200 | 26799.9999999999 |
37 | 628000 | 587886.274509804 | 40113.725490196 |
38 | 612000 | 586772.549019608 | 25227.4509803922 |
39 | 595000 | 569972.549019608 | 25027.4509803922 |
40 | 597000 | 570972.549019608 | 26027.4509803922 |
41 | 593000 | 572972.549019608 | 20027.4509803922 |
42 | 590000 | 568972.549019608 | 21027.4509803922 |
43 | 580000 | 559972.549019608 | 20027.4509803922 |
44 | 574000 | 552972.549019608 | 21027.4509803922 |
45 | 573000 | 545572.549019608 | 27427.4509803922 |
46 | 573000 | 545972.549019608 | 27027.4509803922 |
47 | 620000 | 599572.549019608 | 20427.4509803921 |
48 | 626000 | 609972.549019608 | 16027.4509803921 |
49 | 620000 | 595658.823529412 | 24341.1764705881 |
50 | 588000 | 594545.098039216 | -6545.09803921566 |
51 | 566000 | 577745.098039216 | -11745.0980392157 |
52 | 557000 | 578745.098039216 | -21745.0980392157 |
53 | 561000 | 580745.098039216 | -19745.0980392157 |
54 | 549000 | 576745.098039216 | -27745.0980392157 |
55 | 532000 | 567745.098039216 | -35745.0980392157 |
56 | 526000 | 560745.098039216 | -34745.0980392157 |
57 | 511000 | 553345.098039216 | -42345.0980392156 |
58 | 499000 | 553745.098039216 | -54745.0980392156 |
59 | 555000 | 607345.098039216 | -52345.0980392157 |
60 | 565000 | 617745.098039216 | -52745.0980392157 |
61 | 542000 | 603431.37254902 | -61431.3725490197 |