Multiple Linear Regression - Estimated Regression Equation |
Yt[t] = + 247.380841890866 -1.7746426149865Xt[t] + 78.1125743122357M1[t] + 65.7367308094882M2[t] + 80.5308594646116M3[t] + 68.6751867579987M4[t] + 48.8929798102283M5[t] + 54.0815320866645M6[t] + 32.8446193529302M7[t] + 20.7564387499451M8[t] + 28.3924274457508M9[t] + 45.068078292647M10[t] + 25.0159548712641M11[t] + 0.158264129372535t + 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) | 247.380841890866 | 262.863954 | 0.9411 | 0.351571 | 0.175785 |
Xt | -1.7746426149865 | 2.47651 | -0.7166 | 0.47725 | 0.238625 |
M1 | 78.1125743122357 | 6.167986 | 12.6642 | 0 | 0 |
M2 | 65.7367308094882 | 6.145482 | 10.6968 | 0 | 0 |
M3 | 80.5308594646116 | 6.171861 | 13.0481 | 0 | 0 |
M4 | 68.6751867579987 | 6.145933 | 11.1741 | 0 | 0 |
M5 | 48.8929798102283 | 6.122277 | 7.9861 | 0 | 0 |
M6 | 54.0815320866645 | 6.117187 | 8.8409 | 0 | 0 |
M7 | 32.8446193529302 | 6.110394 | 5.3752 | 2e-06 | 1e-06 |
M8 | 20.7564387499451 | 6.106396 | 3.3991 | 0.001406 | 0.000703 |
M9 | 28.3924274457508 | 6.104948 | 4.6507 | 2.8e-05 | 1.4e-05 |
M10 | 45.068078292647 | 6.102417 | 7.3853 | 0 | 0 |
M11 | 25.0159548712641 | 6.098994 | 4.1017 | 0.000166 | 8.3e-05 |
t | 0.158264129372535 | 0.264939 | 0.5974 | 0.553196 | 0.276598 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.943285641139972 |
R-squared | 0.889787800780847 |
Adjusted R-squared | 0.858640874914565 |
F-TEST (value) | 28.5674356628586 |
F-TEST (DF numerator) | 13 |
F-TEST (DF denominator) | 46 |
p-value | 0 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 9.642558735548 |
Sum Squared Residuals | 4277.03119255068 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 151.7 | 138.959277235894 | 12.740722764106 |
2 | 121.3 | 126.74169786252 | -5.44169786251956 |
3 | 133 | 140.984233601021 | -7.98423360102094 |
4 | 119.6 | 129.286825023781 | -9.6868250237806 |
5 | 122.2 | 108.598096636391 | 13.6019033636092 |
6 | 117.4 | 113.767448780701 | 3.63255121929907 |
7 | 106.7 | 92.5113359148404 | 14.1886640851596 |
8 | 87.5 | 79.6940981337347 | 7.80590186626532 |
9 | 81 | 86.9559581744169 | -5.95595817441694 |
10 | 110.3 | 103.612408889187 | 6.68759111081302 |
11 | 87 | 83.7185495971766 | 3.28145040282338 |
12 | 55.7 | 58.6833945937864 | -2.98339459378643 |
13 | 146 | 136.688036643147 | 9.3119633568533 |
14 | 137.5 | 123.902571632976 | 13.597428367024 |
15 | 138.5 | 137.967643109979 | 0.532356890021286 |
16 | 135.6 | 126.252488106589 | 9.34751189341147 |
17 | 107.3 | 107.444880891084 | -0.144880891084483 |
18 | 99 | 112.596486609245 | -13.5964866092447 |
19 | 91.4 | 91.3226273172343 | 0.0773726827656592 |
20 | 68.4 | 79.108768025224 | -10.708768025224 |
21 | 82.6 | 86.2996423613068 | -3.69964236130682 |
22 | 98.4 | 103.098064485276 | -4.69806448527576 |
23 | 71.3 | 82.5298409995705 | -11.2298409995705 |
24 | 47.6 | 57.6898966838289 | -10.0898966838289 |
25 | 130.8 | 135.960735125437 | -5.16073512543709 |
26 | 113.6 | 122.838088018419 | -9.23808801841897 |
27 | 125.7 | 137.417805853768 | -11.7178058537678 |
28 | 113.6 | 125.578425867329 | -11.9784258673285 |
29 | 97.1 | 106.273918719628 | -9.17391871962826 |
30 | 104.4 | 111.319045880889 | -6.9190458808893 |
31 | 91.8 | 90.0096937365792 | 1.7903062634208 |
32 | 75.1 | 77.778088018419 | -2.67808801841899 |
33 | 89.2 | 85.5191015651476 | 3.6808984348524 |
34 | 110.2 | 102.264284410667 | 7.93571558933304 |
35 | 78.4 | 82.7431000678038 | -4.34310006780378 |
36 | 68.4 | 57.6192129336643 | 10.7807870663357 |
37 | 122.8 | 135.890051375273 | -13.0900513752725 |
38 | 129.7 | 122.483461449857 | 7.21653855014343 |
39 | 159.1 | 137.151911415955 | 21.9480885840453 |
40 | 139 | 125.419009986415 | 13.5809900135854 |
41 | 102.2 | 108.0311168629 | -5.83111686289976 |
42 | 113.6 | 113.23596185951 | 0.364038140490425 |
43 | 81.5 | 91.7846383060006 | -10.2846383060006 |
44 | 77.4 | 79.5707790139902 | -2.17077901399021 |
45 | 87.6 | 87.3117925607189 | 0.288207439281135 |
46 | 101.2 | 104.074721832388 | -2.87472183238806 |
47 | 87.2 | 83.9856518527292 | 3.21434814727081 |
48 | 64.9 | 58.8617647185897 | 6.03823528141033 |
49 | 133.1 | 136.90189962025 | -3.8018996202497 |
50 | 118 | 124.134181036229 | -6.13418103622888 |
51 | 135.9 | 138.678406019278 | -2.7784060192779 |
52 | 125.7 | 126.963251015888 | -1.26325101588772 |
53 | 108 | 106.451986889997 | 1.54801311000335 |
54 | 128.3 | 111.781056869656 | 16.5189431303445 |
55 | 84.7 | 90.4717047253454 | -5.77170472534544 |
56 | 86.4 | 78.6482668086321 | 7.75173319136788 |
57 | 92.2 | 86.5135053384098 | 5.68649466159022 |
58 | 95.8 | 102.850520382482 | -7.05052038248224 |
59 | 92.3 | 83.2228574827199 | 9.07714251728012 |
60 | 54.3 | 58.0457310701307 | -3.74573107013076 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
17 | 0.216429971759851 | 0.432859943519703 | 0.783570028240149 |
18 | 0.104564506953574 | 0.209129013907149 | 0.895435493046426 |
19 | 0.054114093895671 | 0.108228187791342 | 0.945885906104329 |
20 | 0.0334247402822964 | 0.0668494805645928 | 0.966575259717704 |
21 | 0.259038010175741 | 0.518076020351482 | 0.740961989824259 |
22 | 0.186319109823204 | 0.372638219646409 | 0.813680890176796 |
23 | 0.1432378670823 | 0.2864757341646 | 0.8567621329177 |
24 | 0.100827552130183 | 0.201655104260367 | 0.899172447869817 |
25 | 0.0689300990923542 | 0.137860198184708 | 0.931069900907646 |
26 | 0.0566050765816932 | 0.113210153163386 | 0.943394923418307 |
27 | 0.0607805645067078 | 0.121561129013416 | 0.939219435493292 |
28 | 0.0651167858638647 | 0.130233571727729 | 0.934883214136135 |
29 | 0.0455646093874804 | 0.0911292187749608 | 0.95443539061252 |
30 | 0.14104799997077 | 0.282095999941539 | 0.85895200002923 |
31 | 0.117013039181388 | 0.234026078362776 | 0.882986960818612 |
32 | 0.201073127543682 | 0.402146255087363 | 0.798926872456318 |
33 | 0.502199229976007 | 0.995601540047985 | 0.497800770023993 |
34 | 0.584692248936274 | 0.830615502127452 | 0.415307751063726 |
35 | 0.787962707135545 | 0.42407458572891 | 0.212037292864455 |
36 | 0.840234919535038 | 0.319530160929924 | 0.159765080464962 |
37 | 0.957786161255724 | 0.0844276774885523 | 0.0422138387442761 |
38 | 0.947951486291877 | 0.104097027416246 | 0.0520485137081231 |
39 | 0.96878761837345 | 0.0624247632530997 | 0.0312123816265498 |
40 | 0.946224573400444 | 0.107550853199112 | 0.053775426599556 |
41 | 0.889695624402313 | 0.220608751195375 | 0.110304375597687 |
42 | 0.878928973320536 | 0.242142053358929 | 0.121071026679464 |
43 | 0.787526801025384 | 0.424946397949231 | 0.212473198974616 |
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 | 4 | 0.148148148148148 | NOK |