Multiple Linear Regression - Estimated Regression Equation |
Yt[t] = + 3540.69197220564 + 0.130932028247943`Yt-1`[t] + 0.201818490077341`Yt-2`[t] + 0.264823448542266`Yt-3`[t] + 385.773255960303M1[t] -436.300069757011M2[t] + 469.50316191611M3[t] + 72.8939494758225M4[t] + 333.401103073757M5[t] + 79.6860766985085M6[t] + 718.477094565067M7[t] + 477.862169357032M8[t] + 160.878337540301M9[t] + 134.048534247598M10[t] -554.848198896825M11[t] + 5.16340774563458t + 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) | 3540.69197220564 | 1487.891151 | 2.3797 | 0.020759 | 0.01038 |
`Yt-1` | 0.130932028247943 | 0.133903 | 0.9778 | 0.332371 | 0.166186 |
`Yt-2` | 0.201818490077341 | 0.129049 | 1.5639 | 0.123476 | 0.061738 |
`Yt-3` | 0.264823448542266 | 0.134251 | 1.9726 | 0.053486 | 0.026743 |
M1 | 385.773255960303 | 200.187808 | 1.9271 | 0.059052 | 0.029526 |
M2 | -436.300069757011 | 220.764862 | -1.9763 | 0.053053 | 0.026527 |
M3 | 469.50316191611 | 159.044028 | 2.952 | 0.004605 | 0.002303 |
M4 | 72.8939494758225 | 235.72034 | 0.3092 | 0.758287 | 0.379144 |
M5 | 333.401103073757 | 212.06604 | 1.5722 | 0.121548 | 0.060774 |
M6 | 79.6860766985085 | 183.358501 | 0.4346 | 0.665529 | 0.332764 |
M7 | 718.477094565067 | 182.264961 | 3.9419 | 0.000227 | 0.000113 |
M8 | 477.862169357032 | 222.742583 | 2.1454 | 0.036275 | 0.018138 |
M9 | 160.878337540301 | 205.873838 | 0.7814 | 0.437834 | 0.218917 |
M10 | 134.048534247598 | 177.712911 | 0.7543 | 0.45383 | 0.226915 |
M11 | -554.848198896825 | 184.793507 | -3.0025 | 0.003996 | 0.001998 |
t | 5.16340774563458 | 2.422649 | 2.1313 | 0.037467 | 0.018733 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.881471388071222 |
R-squared | 0.776991807988208 |
Adjusted R-squared | 0.717257470842192 |
F-TEST (value) | 13.0074567679376 |
F-TEST (DF numerator) | 15 |
F-TEST (DF denominator) | 56 |
p-value | 3.57713858534225e-13 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 268.914224668372 |
Sum Squared Residuals | 4049632.17282355 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 9743 | 9522.51633976821 | 220.48366023179 |
2 | 8587 | 8628.5703692345 | -41.5703692344929 |
3 | 9731 | 9521.97243930522 | 209.02756069478 |
4 | 9563 | 9221.52935298616 | 341.470647013838 |
5 | 9998 | 9389.9477797177 | 608.052220282305 |
6 | 9437 | 9467.4041121753 | -30.4041121752958 |
7 | 10038 | 10081.2063737689 | -43.2063737689353 |
8 | 9918 | 9926.42303246605 | -8.42303246604665 |
9 | 9252 | 9571.61772290947 | -319.617722909468 |
10 | 9737 | 9597.69127031389 | 139.30872968611 |
11 | 9035 | 8811.27005039877 | 223.729949601227 |
12 | 9133 | 9200.87692416954 | -67.8769241695368 |
13 | 9487 | 9591.40771915248 | -104.407719152479 |
14 | 8700 | 8654.71989033148 | 45.28010966852 |
15 | 9627 | 9560.03946696362 | 66.9605330363752 |
16 | 8947 | 9224.88400154791 | -277.88400154791 |
17 | 9283 | 9380.19046998181 | -97.1904699818093 |
18 | 8829 | 9283.88677638959 | -454.886776389594 |
19 | 9947 | 9756.12912883447 | 190.870871165534 |
20 | 9628 | 9664.41470316836 | -36.414703168355 |
21 | 9318 | 9416.23018835444 | -98.230188354443 |
22 | 9605 | 9585.6673811861 | 19.3326188139058 |
23 | 8640 | 8792.4691358855 | -152.469135885506 |
24 | 9214 | 9201.9579728728 | 12.0420271272051 |
25 | 9567 | 9549.29910760005 | 17.7008923999518 |
26 | 8547 | 8638.897381061 | -91.8973810609998 |
27 | 9185 | 9639.56393812742 | -454.563938127416 |
28 | 9470 | 9219.28058491148 | 250.719415088517 |
29 | 9123 | 9380.90705346195 | -257.907053461947 |
30 | 9278 | 9313.3976508723 | -35.3976508723052 |
31 | 10170 | 9983.09020764064 | 186.909792359361 |
32 | 9434 | 9803.81818869323 | -369.818188693225 |
33 | 9655 | 9616.70151950468 | 38.2984804953184 |
34 | 9429 | 9711.65520960319 | -282.655209603187 |
35 | 8739 | 8848.02307400035 | -109.023074000348 |
36 | 9552 | 9330.60658452209 | 221.393415477912 |
37 | 9687 | 9628.88612966969 | 58.1138703303142 |
38 | 9019 | 8811.0022884502 | 207.997711549807 |
39 | 9672 | 9877.05329282463 | -205.053292824627 |
40 | 9206 | 9472.04251675742 | -266.042516757423 |
41 | 9069 | 9631.58416333172 | -562.58416333172 |
42 | 9788 | 9443.9771523542 | 344.022847645803 |
43 | 10312 | 10031.0148461154 | 280.98515388463 |
44 | 10105 | 9972.99839337021 | 132.001606629791 |
45 | 9863 | 9930.2359877542 | -67.2359877542048 |
46 | 9656 | 9973.87510096127 | -317.875100961272 |
47 | 9295 | 9159.38031726819 | 135.619682731807 |
48 | 9946 | 9566.2617597199 | 379.738240280092 |
49 | 9701 | 9914.76024504909 | -213.760245049086 |
50 | 9049 | 9101.55455227325 | -52.554552273252 |
51 | 10190 | 10050.1080442064 | 139.891955793584 |
52 | 9706 | 9611.58828331938 | 94.4117166806154 |
53 | 9765 | 9871.49775171964 | -106.497751719637 |
54 | 9893 | 9835.15452834595 | 57.8454716540549 |
55 | 9994 | 10379.600995394 | -385.600995393981 |
56 | 10433 | 10198.8309629785 | 234.169037021484 |
57 | 10073 | 9998.77076821949 | 74.2292317805112 |
58 | 10112 | 10045.3143279499 | 66.6856720501176 |
59 | 9266 | 9410.29018913498 | -144.290189134976 |
60 | 9820 | 9772.06777951748 | 47.9322204825245 |
61 | 10097 | 10075.1304587605 | 21.8695412395087 |
62 | 9115 | 9182.25551864958 | -67.2555186495819 |
63 | 10411 | 10167.2628185727 | 243.737181427304 |
64 | 9678 | 9820.67526047764 | -142.675260477637 |
65 | 10408 | 9991.87278178719 | 416.127218212808 |
66 | 10153 | 10034.1797798627 | 118.820220137337 |
67 | 10368 | 10597.9584482466 | -229.958448246608 |
68 | 10581 | 10532.5147193236 | 48.4852806763519 |
69 | 10597 | 10224.4438132577 | 372.556186742286 |
70 | 10680 | 10304.7967099857 | 375.203290014327 |
71 | 9738 | 9691.5672333122 | 46.4327666877956 |
72 | 9556 | 10149.2289791982 | -593.228979198197 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
19 | 0.724299647848354 | 0.551400704303292 | 0.275700352151646 |
20 | 0.63801872896644 | 0.723962542067119 | 0.361981271033559 |
21 | 0.576243413776378 | 0.847513172447244 | 0.423756586223622 |
22 | 0.46824636956869 | 0.93649273913738 | 0.53175363043131 |
23 | 0.377151798888826 | 0.754303597777652 | 0.622848201111174 |
24 | 0.456071486919632 | 0.912142973839264 | 0.543928513080368 |
25 | 0.402916691174363 | 0.805833382348726 | 0.597083308825637 |
26 | 0.31644303204329 | 0.63288606408658 | 0.68355696795671 |
27 | 0.28243038183386 | 0.56486076366772 | 0.71756961816614 |
28 | 0.542854502599968 | 0.914290994800065 | 0.457145497400032 |
29 | 0.499987254005359 | 0.999974508010719 | 0.500012745994641 |
30 | 0.445781647396218 | 0.891563294792436 | 0.554218352603782 |
31 | 0.679376031946822 | 0.641247936106357 | 0.320623968053178 |
32 | 0.715444183258559 | 0.569111633482883 | 0.284555816741441 |
33 | 0.738157894403987 | 0.523684211192027 | 0.261842105596013 |
34 | 0.670567578949322 | 0.658864842101357 | 0.329432421050678 |
35 | 0.693831641360628 | 0.612336717278744 | 0.306168358639372 |
36 | 0.714734304364503 | 0.570531391270993 | 0.285265695635496 |
37 | 0.672545520010682 | 0.654908959978636 | 0.327454479989318 |
38 | 0.68520595165028 | 0.629588096699442 | 0.314794048349721 |
39 | 0.608290217583566 | 0.783419564832868 | 0.391709782416434 |
40 | 0.552676505919104 | 0.894646988161793 | 0.447323494080896 |
41 | 0.782817392073495 | 0.43436521585301 | 0.217182607926505 |
42 | 0.826191377730368 | 0.347617244539264 | 0.173808622269632 |
43 | 0.81094049762113 | 0.378119004757741 | 0.18905950237887 |
44 | 0.805258967974177 | 0.389482064051646 | 0.194741032025823 |
45 | 0.740707286300682 | 0.518585427398635 | 0.259292713699317 |
46 | 0.675692339728253 | 0.648615320543494 | 0.324307660271747 |
47 | 0.588327678901859 | 0.823344642196282 | 0.411672321098141 |
48 | 0.780907954874464 | 0.438184090251071 | 0.219092045125536 |
49 | 0.695057528969957 | 0.609884942060087 | 0.304942471030043 |
50 | 0.700441050762411 | 0.599117898475178 | 0.299558949237589 |
51 | 0.721353335955172 | 0.557293328089656 | 0.278646664044828 |
52 | 0.772065792931163 | 0.455868414137674 | 0.227934207068837 |
53 | 0.629287079623446 | 0.741425840753109 | 0.370712920376554 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 0 | 0 | OK |
5% type I error level | 0 | 0 | OK |
10% type I error level | 0 | 0 | OK |